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

[System Test] Index building stuck for 1 index

    XMLWordPrintable

Details

    • Untriaged
    • 1
    • Unknown
    • KV-Engine Sprint 2021 August

    Description

      Build : 7.0.0-5295
      Test : -test tests/integration/cheshirecat/test_cheshirecat_kv_gsi_coll_xdcr_backup_sgw_fts_itemct_txns_eventing_cbas_scale3.yml -scope tests/integration/cheshirecat/scope_cheshirecat_with_backup.yml
      Scale : 3
      Iteration : 6th
      Day : 8th

      When the indexes are re-created at the start of the 8th iteration, one index got stuck in Building state. Due to this, two other indexes on the same scope and collection got into error state when trying to build.

      Index stuck in building state :

            {
               "bucket" : "bucket5",
               "collection" : "coll_3",
               "completion" : 100,
               "definition" : "CREATE INDEX `idx2_o5Hth5` ON `bucket5`.`scope_0`.`coll_3`(`free_breakfast`,`type`,`free_parking`,array_count(`public_likes`),`price`,`country`) PARTITION BY hash((meta().`id`)) WITH {  \"nodes\":[ \"172.23.106.188:8091\",\"172.23.121.117:8091\",\"172.23.96.252:8091\",\"172.23.96.253:8091\" ], \"num_replica\":1, \"num_partition\":2 }",
               "defnId" : 14032252590150848051,
               "hosts" : [
                  "172.23.121.117:8091",
                  "172.23.96.252:8091"
               ],
               "indexName" : "idx2_o5Hth5",
               "indexType" : "plasma",
               "instId" : 11315343072811123945,
               "lastScanTime" : "NA",
               "name" : "idx2_o5Hth5",
               "numPartition" : 2,
               "numReplica" : 1,
               "partitionMap" : {
                  "172.23.121.117:8091" : [
                     2
                  ],
                  "172.23.96.252:8091" : [
                     1
                  ]
               },
               "partitioned" : true,
               "progress" : 100,
               "replicaId" : 0,
               "scheduled" : false,
               "scope" : "scope_0",
               "secExprs" : [
                  "`free_breakfast`",
                  "`type`",
                  "`free_parking`",
                  "array_count(`public_likes`)",
                  "`price`",
                  "`country`"
               ],
               "stale" : false,
               "status" : "Building"
            }

      Indexes that are in error state : idx1_Nh3xoJ , idx3_saIot - both on `bucket5`.`scope_0`.`coll_3`.

      Logs being uploaded to Supportal at : http://supportal.couchbase.com/snapshot/1b96429d4bde80c3c1af6d16a3d7f935::0

      Index nodes : 172.23.104.70, 172.23.106.188, 172.23.121.117, 172.23.96.252, 172.23.96.253, 172.23.99.21

      Attachments

        Issue Links

          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:
              9 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                PagerDuty