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

create index with Node-node1 does not display 'node' information on the Index definition on getIndexStatus or UI

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Unresolved
    • Major
    • feature-backlog
    • 4.5.1
    • secondary-index
    • None
    • 451-2844

    Description

      I create an index on a specific node using

      create index temp_idx2 on 
      cdr(field2)  WITH {"node": "10.1.0.136"}
      

      The index is created on desired node as expected.

      However the Index definition via UI and getIndexStatus shows missing definition for 'With Nodes'

      curl -u Administrator:password http://10.1.0.136:9102/getIndexStatus | jq '.'
          {
            "defnId": 12699237869175919000,
            "name": "temp_idx2",
            "bucket": "cdr",
            "secExprs": [
              "`field2`"
            ],
            "indexType": "forestdb",
            "status": "Ready",
            "definition": "CREATE INDEX `temp_idx2` ON `cdr`(`field2`)",
            "hosts": [
              "127.0.0.1:8091"
            ],
            "completion": 100
          }
      

      attached screenshot.

      • This is not useful - when customers need to take a backup of their Indexes and want to recreate indexes on the exact nodes( say after adding removing nodes etc)

      The node information is lost, so currently customers are manually saving this information.

      Attachments

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

        Activity

          People

            jeelan.poola Jeelan Poola
            ketaki Ketaki Gangal (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty