Sometimes looking at the “Query Monitor” I find queries with state “closed” but the duration keeps go on and they remain until I press the cancel button. Why this happens?
Here’s an example obatined by the query select active_requests.*, meta().plan from system:active_requests
{
"clientContextID": "79f3b0e2b067569f",
"elapsedTime": "21h47m48.662493175s",
"executionTime": "21h47m48.662414045s",
"node": "*****",
"phaseCounts": {
"fetch": 7
},
"phaseOperators": {
"authorize": 1,
"fetch": 1,
"filter": 1,
"indexScan": 1,
"update": 1
},
"phaseTimes": {
"authorize": "34.467µs",
"fetch": "27.368µs",
"filter": "56.651µs",
"indexScan": "3.198511ms",
"instantiate": "45.212µs",
"parse": "11.028019ms",
"plan": "177.79342ms",
"run": "59.232844664s",
"update": "22.272µs"
},
"remoteAddr": "*****",
"requestId": "f781ef7b-b002-4dca-b974-da26d0dabb1d",
"requestTime": "2021-03-10T16:36:51.826Z",
"scanConsistency": "unbounded",
"state": "closed",
"statement": "UPDATE `ipc-20002-prod` SET modules = ARRAY OBJECT_PUT(a, $productsName, (ARRAY c FOR c IN a.products WHEN c.productId != $productId END)) FOR a IN modules END WHERE type = $productType AND SOME c in channels SATISFIES c = $channel END AND isModular = true AND SOME c in modules SATISFIES (SOME d in c.products SATISFIES d.productId = $productId END) END",
"userAgent": "libcouchbase/3.0.7-njs couchnode/3.1.1 (node/8.12.0; v8/6.2.414.66; ssl/1.0.2p)",
"users": "*****"
}