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

[EXPLAIN] explain create index fails if the index exists

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 7.1.0
    • 5.5.0
    • query
    • 5.5.0-1911
    • Untriaged
    • Yes

    Description

      If you create an index on a bucket, I created an index on an empty bucket

      create index idx2 on default(fake)

      When I run an explain on this I get this output:

      explain create index idx2 on default(fake)

      [
      {
      "code": 4300,
      "msg": "The index idx2 already exists.",
      "query_from_user": "explain create index idx2 on default(fake)"
      }
      ]

       

      But the explain should not retry the index creation isn't that correct? The logs are attatched, the bucket is empty, no indexes in the beginning. I found this bug due to a test that loads a full bucket, creates an index on that bucket, then runs an explain on that index creation. You can run 

      ./testrunner -i VMs.ini -p doc-per-day=6,gsi_type=memory_optimized,nodes_init=2,primary_indx_type=GSI,use_rest=False -t tuqquery.tuq_index.QueriesViewsTests.test_intersect_scan,index_field=join_mo;join_day,test_to_run=test_comparition_equal_not_equal

      to reproduce exactly, however the above empty bucket scenario seems to fail as well. 

       

      Attachments

        Issue Links

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

          Activity

            People

              ajay.bhullar Ajay Bhullar
              ajay.bhullar Ajay Bhullar
              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