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

          ashwin.govindarajulu Ashwin Govindarajulu created issue -
          keshav Keshav Murthy made changes -
          Field Original Value New Value
          Priority Major [ 3 ] Critical [ 2 ]
          keshav Keshav Murthy made changes -
          Assignee Jeelan Poola [ jeelan.poola ] Deepkaran Salooja [ deepkaran.salooja ]
          keshav Keshav Murthy made changes -
          Resolution User Error [ 10100 ]
          Status Open [ 1 ] Resolved [ 5 ]
          mihir.kamdar Mihir Kamdar (Inactive) made changes -
          Assignee Deepkaran Salooja [ deepkaran.salooja ] Ashwin Govindarajulu [ ashwin.govindarajulu ]
          ashwin.govindarajulu Ashwin Govindarajulu made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          lynn.straus Lynn Straus made changes -
          Fix Version/s 7.0.0 [ 17233 ]
          lynn.straus Lynn Straus made changes -
          Fix Version/s Cheshire-Cat [ 15915 ]

          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