Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
Cheshire-Cat
-
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
- is a backport of
-
MB-47802 UI shows 104k mutations remaining when creating indexes on empty bucket
-
- Closed
-
Activity
Field | Original Value | New Value |
---|---|---|
Description |
When we CREATE indexes with defer build true, on a bucket with 1 scope and 100 collections, /stats API on one of thee indexer nodes returns this :
{noformat} "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, {noformat} which is also causing the UI to display - 104k mutations pending !Screen Shot 2021-05-18 at 11.17.42 AM.png|width=1764,height=228! !Screen Shot 2021-05-18 at 11.19.38 AM.png|width=505,height=119! 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] |
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 :
{noformat}"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, {noformat} which is also causing the UI to display - 104k mutations pending !Screen Shot 2021-05-18 at 11.17.42 AM.png|width=1764,height=228! !Screen Shot 2021-05-18 at 11.19.38 AM.png|width=505,height=119! 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] |
Assignee | Jeelan Poola [ jeelan.poola ] | Varun Velamuri [ varun.velamuri ] |
Assignee | Varun Velamuri [ varun.velamuri ] | Prajwal Kiran Kumar [ prajwal.kirankumar ] |
Resolution | Not a Bug [ 10200 ] | |
Status | Open [ 1 ] | Resolved [ 5 ] |
Assignee | Prajwal Kiran Kumar [ prajwal.kirankumar ] | Varun Velamuri [ varun.velamuri ] |
Resolution | Not a Bug [ 10200 ] | |
Status | Resolved [ 5 ] | Reopened [ 4 ] |
Fix Version/s | CheshireCat.Next [ 16908 ] | |
Fix Version/s | Cheshire-Cat [ 15915 ] |
Fix Version/s | 7.0.1 [ 17104 ] | |
Fix Version/s | CheshireCat.Next [ 16908 ] |
Link | This issue blocks MB-46308 [ MB-46308 ] |
Labels | performance | approved-for-7.0.1 performance |
Comment | [ [~jeelan.poola], [~mihir.kamdar], As discussed during GSI scrum, we are keeping this ticket to 7.0.1 as the change is minimum and user visible. Adding "approved-for-7.0.1" label to this. ] |
Summary | :9102/stats api shows num_docs_pending : 104448 when creating indexes on empty bucket | [BP to 7.0.1] :9102/stats api shows num_docs_pending : 104448 when creating indexes on empty bucket |
Summary | [BP to 7.0.1] :9102/stats api shows num_docs_pending : 104448 when creating indexes on empty bucket |
[BP 7.0.1 |
Resolution | Fixed [ 1 ] | |
Status | Reopened [ 4 ] | Resolved [ 5 ] |
Fix Version/s | 7.0.2 [ 18012 ] |
Fix Version/s | 7.0.1 [ 17104 ] |
Labels | approved-for-7.0.1 performance | approved-for-7.0.2 performance |
Assignee | Varun Velamuri [ varun.velamuri ] | Vikas Chaudhary [ vikas.chaudhary ] |
Attachment | Screenshot 2021-09-15 at 8.40.32 PM.png [ 159676 ] |
Status | Resolved [ 5 ] | Closed [ 6 ] |
Prajwal Kiran Kumar, This is an expected behaviour as creation of collections and scopes increment seqnos for every vbucket. The num_docs_pending stat is based on the high seqnos of the bucket. Closing this issue as Not-a-bug