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

UI shows 104k mutations remaining when creating indexes on empty bucket

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • Cheshire-Cat
    • 7.1.0
    • secondary-index
    • 7.0.0-5171
    • Untriaged
    • 1
    • Unknown

    Description

      When we CREATE indexes with defer build true, on a bucket with 1 scope and 100 collections and 0 documents , /stats API on one of thee indexer nodes returns this :

      "bucket-1:scope-1:collection-14:index14-2:num_docs_indexed": 0,
      		 
      "bucket-1:scope-1:collection-14:index14-2:num_docs_pending": 104448, 
      "bucket-1:scope-1:collection-14:index14-2:num_docs_processed": 0, 
      "bucket-1:scope-1:collection-14:index14-2:num_docs_queued": 0, 
      "bucket-1:scope-1:collection-14:index14-2:num_flush_queued": 0,

      which is also causing the UI to display - 104k mutations pending

      This should ideally be 0 mutations pending (as we never loaded the bucket with any documents since the beginning of the test) 

      logs : 
      https://cb-jira.s3.us-east-2.amazonaws.com/logs/CLI/perf-create-ddl/collectinfo-2021-05-18T054915-ns_1%40cen-s705.perf.couchbase.com.zip
      https://cb-jira.s3.us-east-2.amazonaws.com/logs/CLI/perf-create-ddl/collectinfo-2021-05-18T054915-ns_1%40cen-s708.perf.couchbase.com.zip
      https://cb-jira.s3.us-east-2.amazonaws.com/logs/CLI/perf-create-ddl/collectinfo-2021-05-18T054915-ns_1%40cen-s709.perf.couchbase.com.zip
      https://cb-jira.s3.us-east-2.amazonaws.com/logs/CLI/perf-create-ddl/collectinfo-2021-05-18T054915-ns_1%40cen-s710.perf.couchbase.com.zip
      https://cb-jira.s3.us-east-2.amazonaws.com/logs/CLI/perf-create-ddl/collectinfo-2021-05-18T054915-ns_1%40cen-s712.perf.couchbase.com.zip
      https://cb-jira.s3.us-east-2.amazonaws.com/logs/CLI/perf-create-ddl/collectinfo-2021-05-18T054915-ns_1%40cen-s723.perf.couchbase.com.zip
       
       

      Attachments

        Issue Links

          backports to

          Bug - A problem which impairs or prevents the functions of the product. MB-46350 [BP 7.0.2 MB-47802]:UI shows 104k mutations remaining when creating indexes on empty bucket

          • Major - Major loss of function.
          • Closed
          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            Ascending order - Click to sort in descending order
            varun.velamuri Varun Velamuri created issue -
            varun.velamuri Varun Velamuri made changes -
            Field Original Value New Value
            Link This issue Clones MB-46350 [ MB-46350 ]
            varun.velamuri Varun Velamuri made changes -
            Fix Version/s Neo [ 17615 ]
            Fix Version/s 7.0.1 [ 17104 ]
            varun.velamuri Varun Velamuri made changes -
            Labels approved-for-7.0.1 performance performance
            wayne Wayne Siu made changes -
            Link This issue backports to MB-46350 [ MB-46350 ]
            wayne Wayne Siu made changes -
            Link This issue Clones MB-46350 [ MB-46350 ]
            build-team Couchbase Build Team added a comment -

            Build couchbase-server-7.1.0-1138 contains indexing commit 05ca5f4 with commit message:
            MB-47802 Do not populate numDocsPending for index in created state

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.1.0-1138 contains indexing commit 05ca5f4 with commit message: MB-47802 Do not populate numDocsPending for index in created state
            varun.velamuri Varun Velamuri made changes -
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Resolved [ 5 ]
            varun.velamuri Varun Velamuri made changes -
            Summary :9102/stats api shows num_docs_pending : 104448 when creating indexes on empty bucket UI shows 104k mutations remaining when creating indexes on empty bucket
            mihir.kamdar Mihir Kamdar (Inactive) made changes -
            Assignee Varun Velamuri [ varun.velamuri ] Hemant Rajput [ hemant.rajput ]
            hemant.rajput Hemant Rajput added a comment -

            Validated on 7.1.0-2026. 

             

            No mutation pending stats are shown for indexes.

            hemant.rajput Hemant Rajput added a comment - Validated on 7.1.0-2026.    No mutation pending stats are shown for indexes.
            hemant.rajput Hemant Rajput made changes -
            Status Resolved [ 5 ] Closed [ 6 ]

            People

              hemant.rajput Hemant Rajput
              varun.velamuri Varun Velamuri
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty