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

Unable to add index to index server on 4.5 node in mixed 4.1 and 4.5 cluster

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Critical
    • None
    • 4.5.0
    • secondary-index
    • None

    Description

      When upgrading the cluster, if you add a 4.5 node to an existing 4.1 cluster, you can not create an index on the 4.5 node. This means that a rolling upgrade would mean downtime for N1QL requests.

      When you try to create an index on the 4.5 node, you receive the following error:
      [
      {
      "code": 5000,
      "msg": "GSI CreateIndex() - cause: Please Set Indexer Storage Mode Before Create Index",
      "query_from_user": "CREATE INDEX productName_inasdex3 ON default(productName, ProductID) \n WHERE type=\"product\" USING GSI WITH

      {\"nodes\":\"10.4.2.130:8091\"}

      ;"
      }
      ]
      If you try to set the "Indexer Storage Mode" from the GUI you get an "Found unsupported key storageMode " error.

      I was able to graceful failover, upgrade, and re-add the node as a way of preserving the indexes.

      Steps to reproduce:

      1.) have a 4.1.0 cluster with indexes
      2.) add a 4.5.0 node with index, data, and query service.
      3.) try to create a new index on the 4.5.0 node "CREATE INDEX productName_index1 ON bucket_name(productName, ProductID)
      WHERE type="product" USING GSI WITH

      {"nodes":"node1:8091"}

      ;"

      STEP 3 FAILS

      Attachments

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

        Activity

          People

            james.mauss James Mauss (Inactive)
            james.mauss James Mauss (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            11 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty