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

Internal error observed while running analytics query

    XMLWordPrintable

Details

    Description

      During volume test with cluster with 500M + query/fts/analytics/eventing workload + xdcr, analytics query failure with internal error is seen.

      Exception: com.couchbase.client.core.error.InternalServerFailureException: Internal Couchbase Server error {"completed":true,"coreId":"0x79352f0b00000002","errors":[{"code":25000,"message":"Internal error"}],"httpStatus":503,"idempotent":false,"lastDispatchedFrom":"172.23.123.184:59050","lastDispatchedTo":"svc-a-node-014.a4x15egrtcegybdm.sandbox.nonprod-project-avengers.com:18095","requestId":833392094,"requestType":"AnalyticsRequest","retried":1,"retryReasons":["ENDPOINT_NOT_AVAILABLE"],"service":{"httpMethod":"POST","operationId":"fecb3361-e362-489d-9b21-ad356c750551","priority":0,"statement":"SELECT * from ds1 where `type` is not null limit 100","type":"analytics","uri":"/analytics/service"},"timeoutMs":75000,"timings":{"dispatchMicros":481893,"totalDispatchMicros":481893,"totalMicros":796890}}
      Traceback (most recent call last):
        File "pytests/aGoodDoctor/hostedCbas.py", line 221, in _run_query
          status, _, _, results, _ = self.execute_statement_on_cbas(
        File "pytests/aGoodDoctor/hostedCbas.py", line 286, in execute_statement_on_cbas
          raise Exception(str(e))
      Exception: com.couchbase.client.core.error.InternalServerFailureException: Internal Couchbase Server error {"completed":true,"coreId":"0x79352f0b00000002","errors":[{"code":25000,"message":"Internal error"}],"httpStatus":503,"idempotent":false,"lastDispatchedFrom":"172.23.123.184:45708","lastDispatchedTo":"svc-a-node-015.a4x15egrtcegybdm.sandbox.nonprod-project-avengers.com:18095","requestId":833392374,"requestType":"AnalyticsRequest","retried":0,"service":{"httpMethod":"POST","operationId":"38d8f848-a0a3-442e-9a55-a101c9db76e7","priority":0,"statement":"WITH city_avg AS (SELECT city, AVG(price) AS avgprice FROM ds9 WHERE price IS NOT NULL GROUP BY city) SELECT h.name, h.price FROM ds9 h JOIN city_avg ON h.city = city_avg.city WHERE h.price < city_avg.avgprice AND h.price IS NOT NULL limit 100","type":"analytics","uri":"/analytics/service"},"timeoutMs":75000,"timings":{"dispatchMicros":468171,"totalDispatchMicros":468171,"totalMicros":468437}} 

      Attachments

        Issue Links

          For Gerrit Dashboard: MB-56788
          # Subject Branch Project Status CR V

          Activity

            People

              umang.agrawal Umang
              umang.agrawal Umang
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty