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

[system-test] Indexing stuck at 91%

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 4.0.0
    • 4.0.0
    • secondary-index
    • Security Level: Public

    Description

      Build


      4.0.0-3310 (today's build)

      Found during system test with XDCR and tpcc.

      Steps


      1. bucket ram quota: 12.5 GB, indexer ram quota: 256MB, 8 node cluster, 2 index nodes, 3 query nodes, all nodes have data services enabled.
      2. Create 9 tpcc buckets of total size 11gb
      3. Create secondary indexes on all buckets, one at a time.

       
      > create index ST_W_ID_I_ID1 on STOCK(S_W_ID, S_I_ID) using gsi WITH {"defer_build":true}
      {u'status': u'success', u'metrics': {u'elapsedTime': u'7.787801397s', u'executionTime': u'7.787623778s', u'resultSize': 0, u'resultCount': 0}, u'results': [], u'requestID': u'f8b55bc0-051a-42a5-8fc9-60b830b5ebe8', u'signature': None}
       
      > build index on STOCK(ST_W_ID_I_ID1) using gsi
      {u'status': u'success', u'metrics': {u'elapsedTime': u'5.179445542s', u'executionTime': u'5.179250004s', u'resultSize': 0, u'resultCount': 0}, u'results': [], u'requestID': u'd7702364-b80b-4e02-b36e-82299a595ce3', u'signature': None}
       
      Index ST_W_ID_I_ID1 is stuck on .63 at 91% for 30 mins now with 448K keys remaining.
      

      Attaching logs from .63. 4 other indexes have been built successfully on the same node.

      Live cluster: http://172.23.105.54:8091/index.html#sec=indexes

      Attachments

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

        Activity

          People

            apiravi Aruna Piravi (Inactive)
            apiravi Aruna Piravi (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