[DOCS-2742] Document how to cancel an index creation Created: 18/Feb/14  Updated: 06/Oct/14  Resolved: 06/Oct/14

Status: Closed
Project: Documentation
Component/s: manual
Affects Version/s: None
Fix Version/s: v1.3.12

Type: Improvement Priority: Major - P3
Reporter: Jason R. Coombs Assignee: Kay Kim (Inactive)
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
related to SERVER-14758 killOp on foreground index build does... Closed
is related to DOCS-3884 Add a note to the index build page me... Closed
Participants:
Days since reply: 9 years, 19 weeks, 2 days ago

 Description   

The documentation (http://docs.mongodb.org/manual/tutorial/manage-in-progress-indexing-operations/) currently describes cancellation of index creation very simply - use killOp(). However, if one has just created an index in the foreground on a large index, it could have taken down services. The panicked engineer is probably looking for a reliable way to cancel that operation. If there's a large list of ongoing operations, it may be difficult to quickly filter out the correct operation.

The documentation should provide a routine for filtering the current operations to help hone in on the index-creation operation.

I recently accomplished the filtering by looping over the docs and filtering on type != "query" and that returned a sufficiently small result that I was able to identify the relevant Op. I discovered later that the type of the index creation is a "insert", so it would have been even more precise to use that type, though in a system with a lot of inserts, even that wouldn't effectively downselect the currentOps.

I suggest developing a reliable recipe for identifying any index creation operation (or operations) and printing those and then to include that recipe in the aforementioned docs for managing indexes.



 Comments   
Comment by Githook User [ 06/Oct/14 ]

Author:

{u'username': u'kay-kim', u'name': u'kay', u'email': u'kay.kim@10gen.com'}

Message: DOCS-2742 kill index builds
Branch: master
https://github.com/mongodb/docs/commit/82aa02160726f926cb929266f59fd144533a0d12

Comment by Jason R. Coombs [ 01/Aug/14 ]

I should point out also that killOp doesn't actually work on foreground index builds (because the killOp is only queued and then honored when the index build is completed), so that should also be prominently displayed in the docs.

Generated at Thu Feb 08 07:44:08 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.