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

Indexing appears to index fewer (10% items), but the getIndexStatus and UI shows it as "ready" and 100 percent complete

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 4.0.0
    • 4.0.0
    • secondary-index
    • Security Level: Public
    • 400-3125
      2 Nodes

      1 node : kv query, index
      1 node : KV only

      9 tpcc buckets + 1 default bucket
      12 gsi indexes

      Bucket under consideration - Default and its gsi indexes.
    • Untriaged
    • Unknown

    Description

      I recently saw this issue, where
      1. The indexes shows they are 100 % ready and built.
      2. the getIndexStauts matches above ( 100% complete)
      3. The index stats on the main console shows however a very small percentage of items are actually indexed. ( 13k out of 330k) – this is super odd.
      4. select * from system:indexes - shows all gsi indexes to be online.
      5. The "default:flight_direction:num_docs_queued": 330168, shows all items in the queue.

      Attached screenshots

      Attaching logs.

      I ve not observed this in the past and it may be a one-off instance.

      Attachments

        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