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

[system test] Drop index errors out with a "time out", but further drop index - shows no index is available.

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Blocker
    • 4.0.0
    • 4.0.0
    • secondary-index
    • Security Level: Public
    • None
    • 10 bucket, 20 gsi indexes
      6 nodes of which 2 are kv+index+query
    • Untriaged
    • Unknown

    Description

      1. create 10 buckets, create all but 1 index ( whcih always stays in"build" mode for some index-create errors"
      2. load 10M data on buckets, and 25K on ITEM.
      3. index ITEM.IT_ID which is never built, try to drop the index - error from cbq-client

      cbq> drop index ITEM.IT_ID using gsi;
      {
          "requestID": "99e53014-4d3e-4827-b1ef-1cc0a970d0a1",
          "signature": null,
          "results": [
          ],
          "errors": [
              {
                  "code": 5000,
                  "msg": "GSI Drop() - cause: Request Timeout"
              }
          ],
          "status": "errors",
          "metrics": {
              "elapsedTime": "30.135198336s",
              "executionTime": "30.133914893s",
              "resultCount": 0,
              "resultSize": 0,
              "errorCount": 1
          }
      }
       
      cbq> drop index ITEM.IT_ID using gsi;
      {
          "requestID": "722c1cf6-efa2-459c-afa1-b0d8b79abecc",
          "signature": null,
          "results": [
          ],
          "errors": [
              {
                  "code": 5000,
                  "msg": "GSI Drop() - cause: Index does not exist."
              }
          ],
          "status": "errors",
          "metrics": {
              "elapsedTime": "31.436272ms",
              "executionTime": "31.111571ms",
              "resultCount": 0,
              "resultSize": 0,
              "errorCount": 1
          }
      }
      
      

      on checking system:indexes and UI - the index is no longer around.

      Likely there is a disconnect between what the query-output is and the actual dropping of the gsi index?

      I dont have logs yet, will assing back to Dev once i collect and upload the logs.

      Attachments

        Issue Links

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

          Activity

            People

              deepkaran.salooja Deepkaran Salooja
              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