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

[BP 6.6.3][Volume Test] Analytics query fails - ASX0032: Cannot execute request, cluster is UNUSABLE

    XMLWordPrintable

Details

    • Bug
    • Resolution: Declined
    • Critical
    • 6.6.3
    • 6.6.2
    • analytics
    • Enterprise Edition 7.0.0 build 4603 ‧ IPv4

    Description

      Follow steps in volume testing document here:
      https://docs.google.com/document/d/1mREdvTOC6JgGZ6-qSpATFWPmHLKnVvp7OTZPJn-dYK4/edit

      Number of Collection - 200
      Number of datasets - 300 (same test worked with the 200 collections with 100C on KV, though the data size on KV remained the same)

      Step 34: Swap Rebalance both KV and CBAS nodes (1 KV node IN, 1 KV node OUT, 1 CBAS node IN, 1 CBAS node OUT) with loading of data.

      Queries start failing -

      analytics_warn.log:2021-03-07T01:00:37.708-08:00 WARN CBAS.server.QueryServiceServlet [HttpExecutor(port:8095)-2] handleException: ASX0032: Cannot execute request, cluster is UNUSABLE: <ud>{"host":"172.23.121.78:8095","path":"/analytics/service","statement":"select count(*) from n5eqQ6QfQ0c.MEPu3zyA74zDlmLSwB1;","pretty":true,"mode":"immediate","clientContextID":"null","format":"CLEAN_JSON","timeout":300000,"maxResultReads":1,"planFormat":"JSON","expressionTree":false,"rewrittenExpressionTree":false,"logicalPlan":false,"optimizedLogicalPlan":false,"job":false,"profile":"counts","signature":true,"multiStatement":false,"parseOnly":false,"readOnly":false,"maxWarnings":0,"scanConsistency":null,"scanWait":null}</ud>
      

      Attachments

        Issue Links

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

          Activity

            People

              michael.blow Michael Blow
              ritam.sharma Ritam Sharma
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty