Major Description
Given a system:completed_requests that looks like so:
cbq> select * from system:completed_requests;
{
"requestID": "9d21473c-bc2f-4214-a70c-5740b0a69c4b",
"signature": {
"": ""
},
"results": [
{
"completed_requests": {
"elapsedTime": "3.447567513s",
"errorCount": 0,
"node": "172.23.106.26",
"phaseCounts": {
"fetch": 12096,
"primaryScan": 12096
},
"phaseOperators": {
"authorize": 1,
"fetch": 1,
"primaryScan": 1
},
"remoteAddr": "10.17.4.219:53927",
"requestId": "de956e4f-3d3a-4d1d-9ace-7ee3d935d44c",
"resultCount": 12096,
"resultSize": 12819732,
"scanConsistency": "scan_plus",
"serviceTime": "3.446344006s",
"state": "completed",
"statement": "select * from default",
"time": "2017-03-29 13:13:32.929774516 -0700 PDT",
"userAgent": "Python-httplib2/$Rev: 259 $",
"users": "Administrator"
}
},
{
"completed_requests": {
"elapsedTime": "2.53664235s",
"errorCount": 0,
"node": "172.23.106.25",
"phaseCounts": {
"fetch": 12096,
"primaryScan": 12096
},
"phaseOperators": {
"authorize": 1,
"fetch": 1,
"primaryScan": 1
},
"remoteAddr": "10.17.4.219:53926",
"requestId": "b1b3d34d-cdf3-4ef5-b67d-8ab718ae76a1",
"requestTime": "2017-03-29T13:41:15.418994406-07:00",
"resultCount": 12096,
"resultSize": 12819732,
"scanConsistency": "scan_plus",
"serviceTime": "2.535834437s",
"state": "completed",
"statement": "select * from default",
"userAgent": "Python-httplib2/$Rev: 259 $",
"users": "Administrator"
}
}
],
"status": "success",
"metrics": {
"elapsedTime": "342.107324ms",
"executionTime": "342.027943ms",
"resultCount": 2,
"resultSize": 2050
}
}
When I try to delete from this system:completed requests I get the following error:
cbq> delete from system:completed_requests where node == '172.23.106.25';
{
"requestID": "b4b22a91-3427-4d3d-847e-1e00045b2703",
"signature": null,
"results": [
],
"warnings": [
{
"code": 11008,
"msg": "System datastore : scan on completedctive_requests failed - cause: unexpected end of JSON input"
}
],
"status": "success",
"metrics": {
"elapsedTime": "96.834287ms",
"executionTime": "96.794994ms",
"resultCount": 0,
"resultSize": 0,
"warningCount": 1
}
}
There are two points here one is that the error message is wonky, 'completedctive_requests' doesnt make sense. And two is that you used to be able to purge the completed:requests by node.
Filtering has the same error:
cbq> select * from system:completed_requests where node == '172.23.106.25';
{
"requestID": "061cc1cc-2c7d-4388-8f73-640d1c9a10c1",
"signature": {
"": ""
},
"results": [
],
"warnings": [
{
"code": 11008,
"msg": "System datastore : scan on completedctive_requests failed - cause: unexpected end of JSON input"
}
],
"status": "success",
"metrics": {
"elapsedTime": "87.132086ms",
"executionTime": "87.048555ms",
"resultCount": 0,
"resultSize": 0,
"warningCount": 1
}
}