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

Default index storage mode not set

    XMLWordPrintable

Details

    Description

       

      Build: 7.0.0-5219

      Scenario:**

      • 9 node cluster with KV, index+n1ql, FTS services
      • Couchbase bucket (replica=1)
      • Load initial documents into the bucket
      • Try creating PRIMARY_INDEX on the default collection using REST API

      Observation:

      Seeing "Please Set Indexer Storage Mode Before Create Index" error in response and UI also shows no mode selected as default

      Rest response:

      POST http://172.23.104.136:8093/query?scan_consistency=not_bounded&statement=CREATE+PRIMARY+INDEX+%60TLSwXIxUNjX7LDAWfU-31-382000__default__default_196%60+ON+%60TLSwXIxUNjX7LDAWfU-31-382000%60.%60_default%60.%60_default%60+USING+GSI+WITH+%7B%22num_replica%22%3A+1%7D body:  headers: {'Authorization': 'Basic QWRtaW5pc3RyYXRvcjpwYXNzd29yZA==\n'} error: 500 reason: unknown {
      "requestID": "f7c804d5-3536-44cc-b95e-c98733ac7ff6",
      "signature": null,
      "results": [
      ],
      "errors": [{"code":5000,"msg":"GSI CreatePrimaryIndex() - cause: Please Set Indexer Storage Mode Before Create Index\n"}],
      "status": "errors",
      "metrics": {"elapsedTime": "10.025343778s","executionTime": "10.025279581s","resultCount": 0,"resultSize": 0,"serviceLoad": 6,"errorCount": 1}
      } auth: Administrator:password

      Reproducible: Very rarely.  I have seen similar issue in very old build once (Around Sep2020 time frame)

       

      Attachments

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

        Activity

          How did you install the cluster? Via install scripts or manually? 

          keshav Keshav Murthy added a comment - How did you install the cluster? Via install scripts or manually? 

          Keshav Murthy Using testrunner new_install.py script

          ashwin.govindarajulu Ashwin Govindarajulu added a comment - Keshav Murthy Using testrunner new_install.py script
          jliang John Liang added a comment -

          This option needs to be set by user manually. We does not automatically set it.

          jliang John Liang added a comment - This option needs to be set by user manually. We does not automatically set it.

          Fixed the test accordingly to set the storage mode.

          Closing the ticket.

          ashwin.govindarajulu Ashwin Govindarajulu added a comment - Fixed the test accordingly to set the storage mode. Closing the ticket.

          People

            ashwin.govindarajulu Ashwin Govindarajulu
            ashwin.govindarajulu Ashwin Govindarajulu
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty