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

XAttr query fails after upgrade

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 5.5.0
    • 6.5.0
    • query
    • None
    • Untriaged
    • Unknown

    Description

      1. Spin up a two node 4.6.5 cluster
      2. Load 3000 docs
      3. Offline upgrade the cluster to 5.5.0-2907
      4. Wait for buckets to be ready
      5. Write system xattr data to every doc using python sdk
      6. Execute the following rest calls to create proper indexes and query the xattrs:

        curl -v http://172.23.104.105:8093/query/service -d 'statement=CREATE INDEX idx1 ON default(meta().id, meta().xattrs._system1, join_day) USING GSI'
         
        curl -v http://172.23.104.105:8093/query/service -d 'statement=EXPLAIN SELECT meta().xattrs._system1 FROM default where meta().id is not missing'
         
        curl -v http://172.23.104.105:8093/query/service -d 'statement=SELECT meta().xattrs._system1 FROM default where meta().id is not missing'
         
        curl -v http://172.23.104.105:8093/query/service -d 'statement=SELECT meta().xattrs._system1 FROM default use index(`#primary`) where meta().id is not missing'
        

      The last query here with return an error: 

      {
      "requestID": "cfc4741b-fd05-4e21-8224-3ff45893924c",
      "signature": \{"_system1":"json"},
      "results": [
      ],
       
      "errors": [\{"code":12008,"msg":"Error performing bulk get operation  - cause: \{1 errors, starting with MCResponse status=NOT_SUPPORTED, opcode=SUBDOC_MULTI_LOOKUP, opaque=1, msg: }"}],
       
      "status": "errors",
      "metrics": \{"elapsedTime": "7.681754ms","executionTime": "7.55602ms","resultCount": 0,"resultSize": 0,"errorCount": 1}
      

       

      Attachments

        Issue Links

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

          Activity

            Build couchbase-server-6.5.0-1106 contains go-couchbase commit 5a0c9a5 with commit message:
            MB-30197 Add retry logic to rerun xattr queries when they get NOT_SUPPORTED error from gomemcached. Max number of retries will be twice the number of nodes.

            build-team Couchbase Build Team added a comment - Build couchbase-server-6.5.0-1106 contains go-couchbase commit 5a0c9a5 with commit message: MB-30197 Add retry logic to rerun xattr queries when they get NOT_SUPPORTED error from gomemcached. Max number of retries will be twice the number of nodes.

            Build couchbase-server-6.5.0-1106 contains gomemcached commit 20e69a1 with commit message:
            MB-30197 Add retry logic to rerun xattr queries when they get NOT_SUPPORTED error from gomemcached. Max number of retries will be twice the number of nodes.

            build-team Couchbase Build Team added a comment - Build couchbase-server-6.5.0-1106 contains gomemcached commit 20e69a1 with commit message: MB-30197 Add retry logic to rerun xattr queries when they get NOT_SUPPORTED error from gomemcached. Max number of retries will be twice the number of nodes.

            Build sync_gateway-2.5.0-134 contains go-couchbase commit 5a0c9a5 with commit message:
            MB-30197 Add retry logic to rerun xattr queries when they get NOT_SUPPORTED error from gomemcached. Max number of retries will be twice the number of nodes.

            build-team Couchbase Build Team added a comment - Build sync_gateway-2.5.0-134 contains go-couchbase commit 5a0c9a5 with commit message: MB-30197 Add retry logic to rerun xattr queries when they get NOT_SUPPORTED error from gomemcached. Max number of retries will be twice the number of nodes.

            Build sync_gateway-2.7.0-36 contains gomemcached commit 20e69a1 with commit message:
            MB-30197 Add retry logic to rerun xattr queries when they get NOT_SUPPORTED error from gomemcached. Max number of retries will be twice the number of nodes.

            build-team Couchbase Build Team added a comment - Build sync_gateway-2.7.0-36 contains gomemcached commit 20e69a1 with commit message: MB-30197 Add retry logic to rerun xattr queries when they get NOT_SUPPORTED error from gomemcached. Max number of retries will be twice the number of nodes.

            Could not reproduce the problem using build 4.6.5-4743 as initial and 5.5.0-2907 as upgraded.

            Verified for build 5.5.0-2907 as initial and 6.5.0-4558 as upgraded.

            evgeny.makarenko Evgeny Makarenko (Inactive) added a comment - Could not reproduce the problem using build 4.6.5-4743 as initial and 5.5.0-2907 as upgraded. Verified for build 5.5.0-2907 as initial and 6.5.0-4558 as upgraded.

            People

              ajay.bhullar Ajay Bhullar
              korrigan.clark Korrigan Clark (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              13 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                PagerDuty