hey,
i am using couchbase community 6.0.0 with the latest client
i got a 5,000,000 documents and 3 indexes
i got got query that run on the index with full coverage,
using the java client the query got stick and no result return ,
but if i am using the curl with same query against the database its run with no problems at all
mean the problem in the java client .
there is no laod ( 1 query )
what can cause it and how can i diagnose it ?
here is the explain plain of the query :
{
“plan”: {
“#operator”: “Sequence”,
“~children”: [
{
“#operator”: “IndexScan3”,
“covers”: [
“cover ((customData
.fieldType
))”,
“cover ((customData
.customerGid
))”,
“cover ((customData
.dataSetName
))”,
“cover ((customData
.dataSetVersion
))”,
“cover ((customData
.companyNameField
))”,
“cover ((customData
.fieldValueOutputData
))”,
“cover ((meta(customData
).id
))”
],
“index”: “idx_fieldType_customerGid_dataSet_version_companyNameField”,
“index_id”: “888d7dbadf66a97a”,
“index_projection”: {
“entry_keys”: [
0,
1,
2,
3,
4,
5
]
},
“keyspace”: “customData”,
“namespace”: “default”,
“spans”: [
{
“exact”: true,
“range”: [
{
“high”: ““FILE_ROW””,
“inclusion”: 3,
“low”: ““FILE_ROW””
},
{
“high”: ““customerGid””,
“inclusion”: 3,
“low”: ““customerGid””
},
{
“high”: ““dataSet””,
“inclusion”: 3,
“low”: ““dataSet””
},
{
“high”: “1”,
“inclusion”: 3,
“low”: “1”
},
{
“high”: ““eee4224c-d731-4f9d””,
“inclusion”: 3,
“low”: ““eee4224c-d731-4f9d””
}
]
}
],
“using”: “gsi”
},
{
“#operator”: “Parallel”,
“~child”: {
“#operator”: “Sequence”,
“~children”: [
{
“#operator”: “Filter”,
“condition”: “(((((cover ((customData
.fieldType
)) = “FILE_ROW”) and (cover ((customData
.customerGid
)) = “customerGid”)) and (cover ((customData
.dataSetName
)) = “dataSet”)) and (cover ((customData
.dataSetVersion
)) = 1)) and (cover ((customData
.companyNameField
)) = “eee4224c-d731-4f9d”))”
},
{
“#operator”: “InitialProject”,
“result_terms”: [
{
“expr”: “cover ((customData
.fieldValueOutputData
))”
}
]
},
{
“#operator”: “FinalProject”
}
]
}
}
]
},
“text”: “SELECT fieldValueOutputData FROM customData
WHERE fieldType = “FILE_ROW” AND customerGid = “customerGid” AND dataSetName = “dataSet” AND dataSetVersion = 1 AND ( companyNameField = “eee4224c-d731-4f9d” )”
}
also in the log:
eptember 25th 2019, 10:15:01.195 WARN WARN [2019-09-25 07:15:01,194] com.couchbase.client.core.endpoint.AbstractGenericHandler: [couchbase-6-0-0.lsqa.svc.cluster.local/10.32.7.11:8093][QueryEndpoint]: Got error while consuming KeepAliveResponse.
;
September 25th 2019, 10:15:01.195 - ! java.util.concurrent.TimeoutException: null
;