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

[query_ansi_nest_unnest]No index available for ANSI join term

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 7.0.0
    • Cheshire-Cat
    • qe
    • Untriaged
    • 1
    • Yes

    Description

      The test job centos-query_ansi_nest_unnest is failling on build 4122 with following error during ansi join:

      2021-01-05 09:54:02 | INFO | MainProcess | test_thread | [tuq.run_cbq_query] RUN QUERY select t from default d UNNEST d.`transactions` as t INNER JOIN standard_bucket0 s ON (d.age == s.age)
      2021-01-05 09:54:02 | INFO | MainProcess | test_thread | [rest_client.query_tool] query params : statement=select+t+from+default+d+UNNEST+d.%60transactions%60+as+t+INNER+JOIN+standard_bucket0+s+ON+%28d.age+%3D%3D+s.age%29&scan_consistency=REQUEST_PLUS
      2021-01-05 09:54:06 | ERROR | MainProcess | test_thread | [rest_client._http_request] POST http://172.23.105.49:8093/query?statement=select+t+from+default+d+UNNEST+d.%60transactions%60+as+t+INNER+JOIN+standard_bucket0+s+ON+%28d.age+%3D%3D+s.age%29&scan_consistency=REQUEST_PLUS body:  headers: {'Authorization': 'Basic QWRtaW5pc3RyYXRvcjpwYXNzd29yZA=='} error: 500 reason: unknown b'{\n"requestID": "481bdde1-be1c-4460-9746-73b8ef62dbbb",\n"errors": [{"code":4330,"msg":"No index available for ANSI join term s"}],\n"status": "fatal",\n"metrics": {"elapsedTime": "3.836065281s","executionTime": "3.83599298s","resultCount": 0,"resultSize": 0,"serviceLoad": 1,"errorCount": 1}\n}\n' auth: Administrator:password
       

      Same tests were working on build 4078. Regression could be related to the following commit: 7ee61e99df79cf5abdf6027bf468a0772c6ee994 

       

      Attachments

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

        Activity

          People

            pierre.regazzoni Pierre Regazzoni
            pierre.regazzoni Pierre Regazzoni
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty