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

Queries with at_plus scan consistency failing

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 6.5.0
    • 6.5.0
    • query
    • Untriaged
    • Yes

    Description

      Test : ./testrunner -i /tmp/testexec.29030.ini -p gsi_type=plasma,reset_services=True -t 2i.indexscans_2i.SecondaryIndexingScanTests.test_multi_create_query_explain_drop_index_scan_consistency,groups=simple,dataset=default,doc-per-day=20,use_gsi_for_primary=True,use_gsi_for_secondary=True,scan_consistency=at_plus,scan_vector_per_values=1.0,nodes_init=4,services_init=kv:n1ql-kv-index-index,GROUP=gsi

      Seeing failures in queries with at_plus consistency
      "errors": [

      {"code":1150,"msg":"Bad sequence number 37. Expected an unsigned 64-bit integer."}

      ],

      2018-10-11 13:55:27 | ERROR | MainProcess | Cluster_Thread | [rest_client._http_request] POST http://172.23.106.65:8093/query?scan_vector=%5B%5B37%2C+%22109004265362701%22%5D%2C+%5B52%2C+%22254544819632329%22%5D%2C+%5B37%2C+%22175336605162705%22%5D%2C+%5B38%2C+%2253109568331543%22%5D%2C+%5B46%2C+%22272156851016664%22%5D%2C+%5B...
      ...
      ... (truncated as the text was too long for the bug report. Pls see the attached console log for the full request)
      45797302831587%22%5D%2C+%5B45%2C+%22176016286481283%22%5D%2C+%5B33%2C+%22178203386124386%22%5D%5D&scan_consistency=at_plus&statement=SELECT+%2A+FROM+default+WHERE++join_yr+%3E+2010+and+join_yr+%3C+2014+ORDER+BY+_id+ body:  headers: {'Content-Type': 'application/x-www-form-urlencoded', 'Accept': '*/*', 'Authorization': 'Basic QWRtaW5pc3RyYXRvcjpwYXNzd29yZA==\n'} error: 500 reason: unknown {
      "requestID": "00b99e8f-bb97-44ef-9eb1-451c41f135e7",
      "errors": [{"code":1150,"msg":"Bad sequence number 37. Expected an unsigned 64-bit integer."}],
      "status": "fatal",
      "metrics": {"elapsedTime": "3.099253ms","executionTime": "2.504502ms","resultCount": 0,"resultSize": 0,"errorCount": 1}
      } auth: Administrator:password
      

      Test log and cbcollect_info attached.

      Similar failures are seen in other GSI jobs that issues queries with at_plus scan consistency as well, hence marked as Critical. Also the same tests works well in Alice, hence marked as Regression.

      Attachments

        1. console.log
          389 kB
          Mihir Kamdar
        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            mihir.kamdar Mihir Kamdar (Inactive)
            mihir.kamdar Mihir Kamdar (Inactive)
            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