-
Type: Improvement
-
Resolution: Unresolved
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
Storage Execution
-
(copied to CRM)
Motivation
Debugging issues with index builds is a reoccurring pain point (see SERVER-74973, SERVER-76336, ...)
Current Diagnostic Options
- logs - not useful for long, ongoing index builds if the persisted rollover
- curOp() to get active index information - the output isn't easily parsable.
- coll.getIndexes()
- Until
SERVER-76336is viable, one problem node requires finding all the active index builds, and explicitly changing the commit quorum for each in-progress index. - Since the curOp() information is difficult to parse, one could try to use getIndexes(). However, the output doesn't indicate if the build is in progress, and calling setIndexCommitQuorum() on an already built index yields
- Until
MongoServerError[IndexNotFound]: Cannot find an index build on collection '<db>.<collName>' with the provided index names
- config.system.indexBuilds - useful to see which nodes have voted, but "a typical admin account COEs use doesn't have the __system privilege to read that collection"
Request
Either the addition of a new command or straight forward way to filter the status of active indexes.
"It would be nice to have a diagnostic command like getIndexBuildStatus which at the very least, shows content from config.system.indexBuilds.
It would be helpful if the command can report additional metadata such as:
- The index creation time
- Local status
- If it has been resumed
- If there are any more index creation requests that are pending and what the requested quorum values are
It would be great if the output could also overlap with the indexBuilds and indexBulkBuilds section of serverStatus."
- is related to
-
SERVER-74973 Track start and end datetimes of index builds and surface them in collection validation error results
- Backlog
- related to
-
SERVER-74973 Track start and end datetimes of index builds and surface them in collection validation error results
- Backlog
-
SERVER-88323 Show all index builds not completed as active operations in currentOp
- Backlog
-
SERVER-76336 Make the default index build commit quorum configurable
- Closed