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

cbindexplan fails when asked for recommendation for index placement when an equivalent index already present

    XMLWordPrintable

Details

    • Untriaged
    • No

    Description

      Build : 5.0.0-2759

      There are 3 indexer nodes in a cluster, with one node (nodeA) already having an equivalent index If cbindexplan is used to generate recommendation on where to place an index with 1 replica, it fails with the following output on console.

      [root@node1-cb450-testing-centos6 bin]# /opt/couchbase/bin//cbindexplan -command=plan -indexes='/opt/couchbase/bin//index.json' -cluster='10.111.151.101:8091' -username='Administrator' -password='password' -output='plan.json'
      2017-05-03T06:25:36.709+00:00 [Fatal] MetakvGet: Failed to fetch /indexing/ddl/commandToken/delete/556476377991134230 from metakv: Get /_metakv/indexing/ddl/commandToken/delete/556476377991134230: missing port in address
      2017-05-03T06:25:36.709+00:00 [Error] Planner::getIndexLayout: Error for converting index metadata to index usage for node 10.111.151.101:8091. Error = Get /_metakv/indexing/ddl/commandToken/delete/556476377991134230: missing port in address
      2017-05-03T06:25:36.709+00:00 [Fatal] Unable to read index layout from cluster 10.111.151.101:8091. err = Get /_metakv/indexing/ddl/commandToken/delete/556476377991134230: missing port in address

      Index.json
      [root@node1-cb450-testing-centos6 bin]# cat index.json
      [

      {"ScanRate": 0, "ArrKeySize": 0, "isArrayIndex": false, "bucket": "default", "SecKeySize": 200, "ArrSize": 0, "replica": 2, "secExprs": ["age"], "MutationRate": 0, "isPrimary": false, "numDoc": 1000, "DocKeySize": 200, "name": "default_idx"}

      ]

      Steps to reproduce:
      1. Have a cluster with 3 indexer nodes
      2. Create a default bucket
      3. Create an index on this bucket on field 'age' on nodeA
      4. Use the index.json file as mentioned above and run cbindexplan to generate a placement recommendation of an index on field age with 1 replica.

      cbindexplan fails to generate a recommendation.

      Attachments

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

        Activity

          People

            jliang John Liang
            mihir.kamdar Mihir Kamdar (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty