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

Create Index Fails for multiple GSI Indexes

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Minor
    • 4.0.0
    • 4.0.0
    • secondary-index
    • Security Level: Public
    • Build 1767
    • Untriaged
    • Unknown

    Description

      Trying to create multiple indexes on travel-sample dataset using GSI does not work.
      [1] Install 1767
      [2] Install Travel-Sample Dataset from UI
      [3] Run the following create index statements:

      CREATE PRIMARY INDEX on `travel-sample` USING gsi;
      CREATE INDEX def_faa ON `travel-sample`(faa) USING gsi;
      CREATE INDEX def_icao ON `travel-sample`(icao) USING gsi;
      CREATE INDEX def_city ON `travel-sample`(city) USING gsi;
      CREATE INDEX def_airportname ON `travel-sample`(airportname) USING gsi;
      CREATE INDEX def_type ON `travel-sample`(type) USING gsi;
      CREATE INDEX def_sourceairport ON `travel-sample`(sourceairport) USING gsi;

      Error: [Error: Query error 5000: GSI CreateIndex() - cause: Fails to create index. Cannot find available node for new index] code: 5000

      When Querying CBQ to check for index status after 15 minutes:

      select * from system:indexes;
      {
      "requestID": "2819464a-c740-4268-843c-cb4db8941568",
      "signature":

      { "*": "*" }

      ,
      "results": [
      {
      "indexes":

      { "datastore_id": "http://127.0.0.1:8091", "id": "17f4d44ba5735b1f", "index_key": [ "`sourceairport`" ], "keyspace_id": "travel-sample", "name": "def_sourceairport", "namespace_id": "default", "state": "online", "using": "gsi" }

      },
      {
      "indexes":

      { "datastore_id": "http://127.0.0.1:8091", "id": "69a7127098164219", "index_key": [], "keyspace_id": "travel-sample", "name": "#primary", "namespace_id": "default", "state": "online", "using": "gsi" }

      }
      ],
      "errors": [

      { "code": 12014, "msg": "error: Build Already In Progress. Bucket travel-sample. Index def_airportname([`airportname`]). Index state: pending" }

      ,

      { "code": 12014, "msg": "error: Build Already In Progress. Bucket travel-sample. Index def_type([`type`]). Index state: pending" }

      ,

      { "code": 12014, "msg": "error: Build Already In Progress. Bucket travel-sample. Index def_faa([`faa`]). Index state: pending" }

      ,

      { "code": 12014, "msg": "error: Build Already In Progress. Bucket travel-sample. Index def_icao([`icao`]). Index state: pending" }

      ,

      { "code": 12014, "msg": "error: Build Already In Progress. Bucket travel-sample. Index def_city([`city`]). Index state: pending" }

      ],
      "status": "errors",
      "metrics":

      { "elapsedTime": "338.7706ms", "executionTime": "338.5972ms", "resultCount": 2, "resultSize": 814, "errorCount": 5 }

      }

      Attachments

        Issue Links

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

          Activity

            People

              tgreenstein Todd Greenstein [X] (Inactive)
              tgreenstein Todd Greenstein [X] (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty