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

Pending indexes are not displayed on the UI

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Critical
    • 4.0.0
    • 4.0.0
    • ns_server, secondary-index
    • Security Level: Public
    • None
    • 400-2213
      bucket -default
      items 13M
      3 gsi indexes
    • Untriaged
    • Unknown

    Description

      create indexes - primary, SeqNum on default prior to loading data
      load 13M items
      create another index on Amount on default after the data is loaded

      The system:indexes shows presence of this index in pending state
      cbq> select * from system:indexes where keyspace_id="default";
      {
      "requestID": "c488f72e-45f8-47f8-b753-ca10d3900c63",
      "signature":

      { "*": "*" }

      ,
      "results": [
      {
      "indexes":

      { "datastore_id": "http://127.0.0.1:8091", "id": "f2e31e0f3021497e", "index_key": [ "(((((`AirItineraryPricingInfo`.`PTC_FareBreakdowns`).`PTC_FareBreakdown`).`PassengerFare`).`TotalFare`).`Amount`)" ], "keyspace_id": "default", "name": "amt", "namespace_id": "default", "state": "pending", "using": "gsi" }

      },
      {
      "indexes":

      { "datastore_id": "http://127.0.0.1:8091", "id": "ba277bd5832cc61", "index_key": [], "is_primary": true, "keyspace_id": "default", "name": "px_default", "namespace_id": "default", "state": "online", "using": "gsi" }

      },
      {
      "indexes":

      { "datastore_id": "http://127.0.0.1:8091", "id": "cc9643d53917d052", "index_key": [ "`SequenceNumber`" ], "keyspace_id": "default", "name": "seq_num", "namespace_id": "default", "state": "online", "using": "gsi" }

      }
      ],
      "status": "success",
      "metrics":

      { "elapsedTime": "1.466690496s", "executionTime": "1.466390323s", "resultCount": 3, "resultSize": 1348 }

      }

      The UI does not capture this as an index present and is possibly in "Building" or "created" state.

      Attached screenshot

      We should display indexes once defined on the bucket on the Indexes page - while it is still under "Building/Created" state?

      Logs

      https://s3.amazonaws.com/cb-customers/query/3/collectinfo-2015-05-26T180444-ns_1%4010.6.2.164.zip
      https://s3.amazonaws.com/cb-customers/query/3/collectinfo-2015-05-26T180444-ns_1%4010.6.2.167.zip
      https://s3.amazonaws.com/cb-customers/query/3/collectinfo-2015-05-26T180444-ns_1%4010.6.2.168.zip
      https://s3.amazonaws.com/cb-customers/query/3/collectinfo-2015-05-26T180444-ns_1%4010.6.2.194.zip
      https://s3.amazonaws.com/cb-customers/query/3/collectinfo-2015-05-26T180444-ns_1%4010.6.2.195.zip
      https://s3.amazonaws.com/bugdb/15145/10_232_4.tar

      The getIndexStatus shows the newly created index at completion of 83%

      { "defnId": 17501865627472710000, "name": "amt", "bucket": "default", "secExprs": [ "(((((`AirItineraryPricingInfo`.`PTC_FareBreakdowns`).`PTC_FareBreakdown`).`PassengerFare`).`TotalFare`).`Amount`)" ], "status": "Building", "definition": "CREATE INDEX amt ON default((((((`AirItineraryPricingInfo`.`PTC_FareBreakdowns`).`PTC_FareBreakdown`).`PassengerFare`).`TotalFare`).`Amount`)) USING GSI", "hosts": [ "10.6.2.164:8091" ], "completion": 83 }

      ]
      }

      Attachments

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

        Activity

          People

            Aliaksey Artamonau Aliaksey Artamonau (Inactive)
            ketaki Ketaki Gangal (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty