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

[system test] Cannot create index on ITEM which has less than 25K documents

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Critical
    • 4.0.0
    • 4.0.0
    • secondary-index
    • Security Level: Public
    • 400-1990
      6 nodes, 2 kv+index+query
      10 buckets, 20 gsi indexes
      Buckets have data ranging from 15M to 100 items, see attached screenshot for indiv bucket data spread.
    • Untriaged
    • Unknown

    Description

      possibly related to "build index time out" bug reported yesterday.

      1. create 10 buckets, 20 gsi indexes
      2. drop index ITEM.IT_ID
      3. create index ITEM.IT_ID using gsi – times out.
      cbq> create index IT_ID on ITEM(I_ID) using gsi;
      {
      "requestID": "3ec11e1e-5a59-4b8b-8875-3a686d8365f5",
      "signature": null,
      "results": [
      ],
      "errors": [

      { "code": 5000, "msg": "GSI CreateIndex() - cause: Request Timeout" }

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

      { "elapsedTime": "30.905127433s", "executionTime": "30.904204522s", "resultCount": 0, "resultSize": 0, "errorCount": 1 }

      }

      I dont have logs yet, will assign this back to gsi team once I collect those.

      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