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

Alternate shard id's missing for indexes post upgrading the entire cluster

    XMLWordPrintable

Details

    • Untriaged
    • 0
    • Unknown

    Description

      Cluster config - kv-kv-index-index-n1ql-n1ql

      Upgrade from 7.2.1-5928 to 7.6.0-1755

      Steps to repro 

      1. Create bucket with named scopes and collections and load some data
      2. Create different types of indexes 
      3. Rebalance out an indexer node upgrade it (install in provisoned profile) and add it back to cluster
      4. Repeat step 3 alternately between index and n1ql once those are upgraded upgrade the kv nodes. The upgrade is done in provisioned profile only for indexing nodes
      5. Create indexes post upgrading of all the nodes in the cluster
      6. Post all nodes are upgraded it is observed that alternate shard id's for the indexes created in step 5 are missing

      Sample index metadata with missing alternate shard id

      {            "defnId": 14582871656700988136,            "instId": 14801300697344080784,            "name": "#primary_AHRTHBSYMD",            "bucket": "test_bucket",            "scope": "test_scope_1",            "collection": "test_collection_1",            "isPrimary": true,            "indexType": "plasma",            "status": "Ready",            "definition": "CREATE PRIMARY INDEX `#primary_AHRTHBSYMD` ON `test_bucket`.`test_scope_1`.`test_collection_1` WITH {  \"nodes\":[ \"192.168.64.28:8091\",\"192.168.64.29:8091\" ], \"num_replica\":1 }",            "hosts": [                "192.168.64.29:8091"            ],            "completion": 100,            "progress": 100,            "scheduled": false,            "partitioned": false,            "numPartition": 1,            "partitionMap": {                "192.168.64.29:8091": [                    0                ]            },            "numReplica": 1,            "indexName": "#primary_AHRTHBSYMD",            "replicaId": 0,            "stale": false,            "lastScanTime": "NA",            "alternateShardIds": {}        }, 

      Indexer metadata response file post upgrading all nodes

      response.json

      Logs ->

      https://cb-engineering.s3.amazonaws.com/yash-test-rebalnce/collectinfo-2023-11-07T074052-ns_1%40192.168.64.26.zip

      https://cb-engineering.s3.amazonaws.com/yash-test-rebalnce/collectinfo-2023-11-07T074052-ns_1%40192.168.64.28.zip

      https://cb-engineering.s3.amazonaws.com/yash-test-rebalnce/collectinfo-2023-11-07T074052-ns_1%40192.168.64.29.zip

      https://cb-engineering.s3.amazonaws.com/yash-test-rebalnce/collectinfo-2023-11-07T074052-ns_1%40192.168.64.30.zip

      https://cb-engineering.s3.amazonaws.com/yash-test-rebalnce/collectinfo-2023-11-07T074052-ns_1%40192.168.64.31.zip

      https://cb-engineering.s3.amazonaws.com/yash-test-rebalnce/collectinfo-2023-11-07T074052-ns_1%40192.168.64.32.zip

      CC Hemant Rajput 

      Attachments

        For Gerrit Dashboard: MB-59490
        # Subject Branch Project Status CR V

        Activity

          People

            yash.dodderi Yash Dodderi
            yash.dodderi Yash Dodderi
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty