Details
-
Bug
-
Resolution: Fixed
-
Critical
-
6.0.0
-
Untriaged
-
Centos 64-bit
-
-
Unknown
-
CX Sprint 115
Description
Build: 6.0.0-1466
- Create 2 node cluster 1-kv 1-cbas
- Load travel-sample bucket
- Run parametrise queriesÂ
- Few queries failed with Analytics Service is temporarily unavailable
[2018-08-09 12:45:33,322] - [cbas_parametrise_query:107] INFO - =========== Running SELECT city City, COUNT(DISTINCT name) LandmarkCount FROM %s WHERE `type` = ? GROUP BY city ORDER BY LandmarkCount DESC LIMIT 4&args=["landmark"]#validate
|
===============
|
[2018-08-09 12:45:33,325] - [cbas_parametrise_query:97] INFO - params:[{'args': ['landmark']}]
|
[2018-08-09 12:45:33,325] - [cbas_utils:86] INFO - Running query on cbas: SELECT city City, COUNT(DISTINCT name) LandmarkCount FROM travel_ds WHERE `type` = ? GROUP BY city ORDER BY LandmarkCount DESC LIMIT 4
|
[2018-08-09 12:45:41,615] - [Rest_Connection:174] ERROR - socket error while connecting to http://10.142.180.102:8095/analytics/service error [Errno 61] Connection refused
|
[2018-08-09 12:45:44,625] - [Rest_Connection:174] ERROR - socket error while connecting to http://10.142.180.102:8095/analytics/service error [Errno 61] Connection refused
|
[2018-08-09 12:45:48,503] - [Rest_Connection:170] ERROR - POST http://10.142.180.102:8095/analytics/service body: {"pretty": "true", "client_context_id": null, "timeout": "120s", "mode": null, "args": ["landmark"], "statement": "SELECT city City, COUNT(DISTINCT name) LandmarkCount FROM travel_ds WHERE `type` = ? GROUP BY city ORDER BY LandmarkCount DESC LIMIT 4"} headers: {'Accept': '*/*', 'Authorization': 'Basic QWRtaW5pc3RyYXRvcjpwYXNzd29yZA==\n', 'Content-Type': 'application/json'} error: 503 reason: unknown {
|
"requestID": "c70f82ff-eb74-442a-a6c2-fad5285b5c68",
|
"clientContextID": "null",
|
"signature": {
|
"*": "*"
|
},
|
"errors": [{
|
"code": 23000,
|
"msg": "Analytics Service is temporarily unavailable"
|
}],
|
"status": "fatal",
|
"metrics": {
|
"elapsedTime": "436.829812ms",
|
"executionTime": "72.900081ms",
|
"resultCount": 0,
|
"resultSize": 0,
|
"processedObjects": 0,
|
"errorCount": 1
|
}
|
} auth: Administrator:password
|
|
|
|
|
[2018-08-09 12:45:49,615] - [cbas_utils:86] INFO - Running query on cbas: SELECT callsign FROM travel_ds GROUP BY callsign HAVING count(callsign) BETWEEN $p1 and $p2
|
[2018-08-09 12:45:49,674] - [Rest_Connection:170] ERROR - POST http://10.142.180.102:8095/analytics/service body: {"pretty": "true", "$p1": 0, "$p2": 2, "client_context_id": null, "timeout": "120s", "mode": null, "statement": "SELECT callsign FROM travel_ds GROUP BY callsign HAVING count(callsign) BETWEEN $p1 and $p2"} headers: {'Accept': '*/*', 'Authorization': 'Basic QWRtaW5pc3RyYXRvcjpwYXNzd29yZA==\n', 'Content-Type': 'application/json'} error: 503 reason: unknown {
|
"requestID": "21de84f0-5d93-451d-80cf-b62799f6109b",
|
"clientContextID": "null",
|
"signature": {
|
"*": "*"
|
},
|
"errors": [{
|
"code": 23000,
|
"msg": "Analytics Service is temporarily unavailable"
|
}],
|
"status": "fatal",
|
"metrics": {
|
"elapsedTime": "18.336697ms",
|
"executionTime": "5.194758ms",
|
"resultCount": 0,
|
"resultSize": 0,
|
"processedObjects": 0,
|
"errorCount": 1
|
}
|
} auth: Administrator:password
|
Attachments
Issue Links
- relates to
-
MB-30841 [Analytics] Ingestion rate is 2-3 times slower with DEBUG logging level (new default)
- Closed