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

          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