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

        For Gerrit Dashboard: MB-31630
        # Subject Branch Project Status CR V
        100917,3 MB-31630 fix broken test where JSON parsing produced an unexpected type of number master query Status: MERGED +2 +1

        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