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

[System Test]cannot create index because an index with the same name already exists

    XMLWordPrintable

Details

    • Untriaged
    • 1
    • Unknown

    Description

      Build: 7.0.0-4476
      Test: -test tests/fts/cheshire-cat/test_fts_clusterops_cheshire_cat_coll_crud.yml -scope tests/fts/cheshire-cat/scope_fts_cheshire_cat.yml
      Test Cycle: 1

      In the test,

      • there are 5 buckets, out of which 20 static fts indexes are created on collections of 3 buckets. Mutations are going on these collections
      • For the collections on other 2 buckets, we create and drop indexes and no mutations are going on these collections.

      Cluster config:
      fts : 5 ===== > [172.23.107.2:8091 172.23.107.3:8091 172.23.107.5:8091 172.23.97.216:8091 172.23.97.217:8091]
      kv : 4 ===== > [172.23.97.215:8091 172.23.97.232:8091 172.23.97.235:8091 172.23.97.237:8091]
      n1ql : 2 ===== > [172.23.97.227:8091 172.23.97.236:8091]

      Seeing below error messages for some of "create index" which says index name already exists. But test script creates unique name and deletes the index as soon as it creates. Also in the logs we do not see any index creation of same name.

      172.23.97.216 : fts
      /opt/couchbase/var/lib/couchbase/logs/fts.log:2021-02-19T09:49:36.895-08:00 [ERRO] rest: error code: 400, msg: rest_create_index: error creating index: bucket_bucket4_idx_semno-Overall-price-public_likes, err: manager_api: cannot create index because an index with the same name already exists: bucket_bucket4_idx_semno-Overall-price-public_likes -- rest.ShowErrorBody() at rest.go:63
      /opt/couchbase/var/lib/couchbase/logs/fts.log.1.gz:2021-02-19T08:59:08.646-08:00 [ERRO] rest: error code: 400, msg: rest_create_index: error creating index: bucket_bucket4_idx_uwkdp-public_likes-Overall, err: manager_api: cannot create index because an index with the same name already exists: bucket_bucket4_idx_uwkdp-public_likes-Overall -- rest.ShowErrorBody() at rest.go:63
      /opt/couchbase/var/lib/couchbase/logs/fts.log.1.gz:2021-02-19T09:15:35.570-08:00 [ERRO] rest: error code: 400, msg: rest_create_index: error creating index: bucket_bucket5_idx_mvmqs-Overall-type, err: manager_api: cannot create index because an index with the same name already exists: bucket_bucket5_idx_mvmqs-Overall-type -- rest.ShowErrorBody() at rest.go:63
      

      At the same time as above, test was doing rebalance out of a kv node, which was taking a longtime:

      [2021-02-18T11:32:59-08:00, sequoiatools/couchbase-cli:7.0:e5b3a7] rebalance -c 172.23.97.215:8091 --server-remove 172.23.97.232 -u Administrator -p password
      

      Logs:
      url : https://cb-jira.s3.us-east-2.amazonaws.com/logs/systestmon-1613758874/collectinfo-2021-02-19T182119-ns_1%40172.23.107.2.zip
      url : https://cb-jira.s3.us-east-2.amazonaws.com/logs/systestmon-1613758874/collectinfo-2021-02-19T182119-ns_1%40172.23.107.3.zip
      url : https://cb-jira.s3.us-east-2.amazonaws.com/logs/systestmon-1613758874/collectinfo-2021-02-19T182119-ns_1%40172.23.107.4.zip
      url : https://cb-jira.s3.us-east-2.amazonaws.com/logs/systestmon-1613758874/collectinfo-2021-02-19T182119-ns_1%40172.23.107.5.zip
      url : https://cb-jira.s3.us-east-2.amazonaws.com/logs/systestmon-1613758874/collectinfo-2021-02-19T182119-ns_1%40172.23.97.215.zip
      url : https://cb-jira.s3.us-east-2.amazonaws.com/logs/systestmon-1613758874/collectinfo-2021-02-19T182119-ns_1%40172.23.97.216.zip
      url : https://cb-jira.s3.us-east-2.amazonaws.com/logs/systestmon-1613758874/collectinfo-2021-02-19T182119-ns_1%40172.23.97.217.zip
      url : https://cb-jira.s3.us-east-2.amazonaws.com/logs/systestmon-1613758874/collectinfo-2021-02-19T182119-ns_1%40172.23.97.227.zip
      url : https://cb-jira.s3.us-east-2.amazonaws.com/logs/systestmon-1613758874/collectinfo-2021-02-19T182119-ns_1%40172.23.97.232.zip
      url : https://cb-jira.s3.us-east-2.amazonaws.com/logs/systestmon-1613758874/collectinfo-2021-02-19T182119-ns_1%40172.23.97.235.zip
      url : https://cb-jira.s3.us-east-2.amazonaws.com/logs/systestmon-1613758874/collectinfo-2021-02-19T182119-ns_1%40172.23.97.236.zip
      url : https://cb-jira.s3.us-east-2.amazonaws.com/logs/systestmon-1613758874/collectinfo-2021-02-19T182119-ns_1%40172.23.97.237.zip

      Attachments

        Issue Links

          Activity

            People

              abhinav Abhi Dangeti
              girish.benakappa Girish Benakappa
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:

                PagerDuty