Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-30831

Analytics: Parametrise queries are failing with service is temporarily unavailable

    XMLWordPrintable

Details

    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

          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            People

              dmitry.lychagin Dmitry Lychagin (Inactive)
              vikas.chaudhary Vikas Chaudhary
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty