Details
-
Bug
-
Resolution: Fixed
-
Major
-
7.1.0
-
Untriaged
-
-
1
-
Unknown
Description
Build : 7.1.0-1614
Test : -test tests/2i/neo/test_neo_idx_clusterops_recovery.yml -scope tests/2i/neo/scope_neo_plasma_idx_dgm.yml
Scale : 2
Iteration : 1st
The N1QL/GSI component system test is now running UPDATE STATISTICS on some indexes periodically (once every 15 mins). For one such index, the UPDATE STATISTICS query failed. Later in the test, more such failures were observed.
{
|
"completed_requests": {
|
"optimizerEstimates": null,
|
"n1qlFeatCtrl": 76,
|
"userAgent": "libcouchbase/3.0.6 (Linux-3.10.0-1160.2.2.el7.x86_64; x86_64; GNU 9.3.0) PYCBC/3.0.10",
|
"errorCount": 1,
|
"errors": [
|
{
|
"code": 18060,
|
"message": "Decoded dictionary entry for keyspace default:bucket1.scope_0.coll_13 does not match default:bucket1.scope_0.coll_1",
|
"caller": "system_keyspace:716",
|
"key": "dictionary.keyspace_mismatch_error"
|
}
|
],
|
"phaseOperators": {
|
"authorize": 1,
|
"stream": 1
|
},
|
"elapsedTime": "40.900378784s",
|
"state": "completed",
|
"clientContextID": "e8ae93a81a0ccf5f",
|
"serviceTime": "40.900282071s",
|
"statement": "UPDATE STATISTICS FOR `bucket1`.`scope_0`.`coll_1` INDEX ALL;",
|
"requestId": "499b6c63-90ee-417e-a1a9-bfb5cfb17608",
|
"node": "172.23.97.236:8091",
|
"users": "Administrator",
|
"statementType": "UPDATE_STATISTICS",
|
"resultSize": 0,
|
"resultCount": 0,
|
"requestTime": "2021-11-01T17:42:43.184-07:00",
|
"useCBO": true,
|
"scanConsistency": "unbounded",
|
"remoteAddr": "172.23.106.127:52516",
|
"phaseTimes": {
|
"authorize": "28.141\u00b5s",
|
"run": "40.899762257s",
|
"stream": "24.589\u00b5s",
|
"instantiate": "18.88\u00b5s",
|
"parse": "441.382\u00b5s",
|
"plan": "30.318\u00b5s"
|
}
|
}
|
}
|
cbcollect_info from the cluster is attached. 172.23.97.227 and 172.23.97.236 are the query nodes, but nothing of interest was found in the logs around the time of execution of the above query.
Also attached is the completed_requests json.