{ "status": "success", "metrics": { "executionTime": "80.641198ms", "elapsedTime": "80.717786ms", "resultSize": 7858, "sortCount": 7, "serviceLoad": 6, "resultCount": 7 }, "results": [ { "completed_requests": { "node": "172.23.97.227:8091", "users": "Administrator", "state": "completed", "errors": [ { "code": 12016, "icause": "GSI index id b13ab6f09a1696bf not found.", "caller": "secondary_index:275", "retry": true, "key": "datastore.couchbase.index_not_found", "message": "Index Not Found" } ], "scanConsistency": "unbounded", "requestTime": "2021-11-01T17:52:20.272-07:00", "statementType": "CREATE_INDEX", "phaseOperators": { "authorize": 1, "stream": 1 }, "serviceTime": "5.249539391s", "remoteAddr": "172.23.106.127:52666", "elapsedTime": "5.249621336s", "resultSize": 0, "n1qlFeatCtrl": 76, "statement": "CREATE INDEX `idx11_O7QZAJNHH7_idxprefix` ON `bucket4`.`zTxUxPNos3`.`Pk6LlD5E8w`(ALL ARRAY FLATTEN_KEYS(`r`.`ratings`.`Rooms`,`r`.`ratings`.`Cleanliness`) FOR r IN `reviews` END, `email`, `free_parking`) partition by hash(meta().id) with {'num_partition':3,'num_replica':3}", "requestId": "97e5d7f5-53f3-4155-9a6d-3185c594df1e", "clientContextID": "43371d4c24c0d323", "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", "useCBO": true, "resultCount": 0, "errorCount": 1, "phaseTimes": { "authorize": "1.007098ms", "run": "5.247700705s", "stream": "3.894\u00b5s", "instantiate": "15.816\u00b5s", "parse": "1.01116ms", "plan": "760.266\u00b5s" } } }, { "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": 5360, "message": "Update Statistics timeout (60 seconds) exceeded", "caller": "upd_statistics:445", "key": "execution.update_statistics" } ], "phaseOperators": { "authorize": 1, "stream": 1 }, "elapsedTime": "1m1.02658627s", "state": "completed", "clientContextID": "83247fef2d63c484", "serviceTime": "1m1.026453126s", "statement": "UPDATE STATISTICS FOR `bucket3`.`scope_3`.`coll_1` INDEX ALL;", "requestId": "1aeafb27-ce2c-4151-b4e6-d103ca0b362d", "node": "172.23.97.236:8091", "users": "Administrator", "statementType": "UPDATE_STATISTICS", "resultSize": 0, "resultCount": 0, "requestTime": "2021-11-01T17:49:40.89-07:00", "useCBO": true, "scanConsistency": "unbounded", "remoteAddr": "172.23.106.127:43658", "phaseTimes": { "authorize": "31.274\u00b5s", "run": "1m1.025842244s", "stream": "16.303\u00b5s", "instantiate": "20.293\u00b5s", "parse": "530.057\u00b5s", "plan": "31.284\u00b5s" } } }, { "completed_requests": { "node": "172.23.97.227:8091", "users": "Administrator", "state": "completed", "errors": [ { "code": 5360, "message": "Update Statistics timeout (60 seconds) exceeded", "caller": "upd_statistics:445", "key": "execution.update_statistics" } ], "scanConsistency": "unbounded", "requestTime": "2021-11-01T17:48:37.861-07:00", "statementType": "UPDATE_STATISTICS", "phaseOperators": { "authorize": 1, "stream": 1 }, "serviceTime": "1m1.022707794s", "remoteAddr": "172.23.106.127:57984", "elapsedTime": "1m1.022788902s", "resultSize": 0, "n1qlFeatCtrl": 76, "statement": "UPDATE STATISTICS FOR `bucket3`.`scope_2`.`coll_7` INDEX ALL;", "requestId": "d05e71a2-11be-4598-abd9-dfd3d263f3d3", "clientContextID": "1ed80fe789c383a3", "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", "useCBO": true, "resultCount": 0, "errorCount": 1, "phaseTimes": { "authorize": "26.712\u00b5s", "run": "1m1.022187449s", "stream": "4.013\u00b5s", "instantiate": "19.027\u00b5s", "parse": "439.288\u00b5s", "plan": "33.993\u00b5s" } } }, { "completed_requests": { "node": "172.23.97.227:8091", "users": "Administrator", "state": "completed", "errors": [ { "code": 5360, "message": "Update Statistics timeout (60 seconds) exceeded", "caller": "upd_statistics:445", "key": "execution.update_statistics" } ], "scanConsistency": "unbounded", "requestTime": "2021-11-01T17:47:34.834-07:00", "statementType": "UPDATE_STATISTICS", "phaseOperators": { "authorize": 1, "stream": 1 }, "serviceTime": "1m1.019296008s", "remoteAddr": "172.23.106.127:57984", "elapsedTime": "1m1.019381577s", "resultSize": 0, "n1qlFeatCtrl": 76, "statement": "UPDATE STATISTICS FOR `bucket3`.`scope_0`.`coll_5` INDEX ALL;", "requestId": "bc32fac6-30bc-4f29-a891-b1a70c98d125", "clientContextID": "9b4bd6ef09c0d3b7", "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", "useCBO": true, "resultCount": 0, "errorCount": 1, "phaseTimes": { "authorize": "28.262\u00b5s", "run": "1m1.018735928s", "stream": "18.898\u00b5s", "instantiate": "21.893\u00b5s", "parse": "471.386\u00b5s", "plan": "33.671\u00b5s" } } }, { "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" } } }, { "completed_requests": { "node": "172.23.97.227:8091", "users": "Administrator", "state": "completed", "errors": [ { "code": 5000, "icause": "Index idx1_762PZUXIDN_idxprefix will retry building in the background for reason: Error Connecting KV 127.0.0.1:8091 Err MCResponse status=UNKNOWN_COLLECTION, opcode=DCP_GET_SEQNO, opaque=0, msg: {\"error\":{\"context\":\"Unknown scope or collection in operation\"},\"manifest_uid\":\"bf\"}.\n\n", "message": "GSI CreateIndex()", "caller": "secondary_index:573", "key": "Internal Error" } ], "scanConsistency": "unbounded", "requestTime": "2021-11-01T17:42:12.503-07:00", "statementType": "CREATE_INDEX", "phaseOperators": { "authorize": 1, "stream": 1 }, "serviceTime": "1m4.722950711s", "remoteAddr": "172.23.106.127:51188", "elapsedTime": "1m4.723065111s", "resultSize": 0, "n1qlFeatCtrl": 76, "statement": "CREATE INDEX `idx1_762PZUXIDN_idxprefix` ON `bucket4`.`g6lx3gh0q2WYE`.`V4mtw95IbDYIKZM5RgNuDegH5o`(country, DISTINCT ARRAY `r`.`ratings`.`Check in / front desk` FOR r in `reviews` END,array_count((`public_likes`)),array_count((`reviews`)) DESC,`type`,`phone`,`price`,`email`,`address`,`name`,`url`) with {'num_replica':1}", "requestId": "7c36a0ee-1c33-43ef-b1db-8c6e19551578", "clientContextID": "2169c0446fdb7dc0", "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", "useCBO": true, "resultCount": 0, "errorCount": 1, "phaseTimes": { "authorize": "27.149\u00b5s", "run": "1m4.717574488s", "stream": "16.279\u00b5s", "instantiate": "21.869\u00b5s", "parse": "1.817927ms", "plan": "3.479776ms" } } }, { "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": 5360, "message": "Update Statistics timeout (60 seconds) exceeded", "caller": "upd_statistics:445", "key": "execution.update_statistics" } ], "phaseOperators": { "authorize": 1, "stream": 1 }, "elapsedTime": "1m1.024470752s", "state": "completed", "clientContextID": "041d978a67b90f5c", "serviceTime": "1m1.024392921s", "statement": "UPDATE STATISTICS FOR `bucket3`.`scope_2`.`coll_9` INDEX ALL;", "requestId": "b8b1de22-7c8f-4ee8-bc1b-1196139ce803", "node": "172.23.97.236:8091", "users": "Administrator", "statementType": "UPDATE_STATISTICS", "resultSize": 0, "resultCount": 0, "requestTime": "2021-11-01T17:30:18.976-07:00", "useCBO": true, "scanConsistency": "unbounded", "remoteAddr": "172.23.106.127:40608", "phaseTimes": { "authorize": "29.394\u00b5s", "run": "1m1.023820391s", "stream": "5.182\u00b5s", "instantiate": "21.924\u00b5s", "parse": "482.177\u00b5s", "plan": "40.357\u00b5s" } } } ], "requestID": "6d40da6e-7abc-4c5d-b0ea-de4faadd91b1", "signature": { "*": "*" } }