[SERVER-45899] createIndex in foreground blocked *all* databases Created: 31/Jan/20 Updated: 20/Mar/20 Resolved: 18/Feb/20 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Index Maintenance, Replication, Sharding, Stability |
| Affects Version/s: | 3.6.13 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Kay Agahd | Assignee: | Carl Champain (Inactive) |
| Resolution: | Incomplete | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Attachments: |
|
||||||||
| Issue Links: |
|
||||||||
| Operating System: | ALL | ||||||||
| Participants: | |||||||||
| Description |
|
We've created on our cluster an index in the foreground which blocked not only the database on which the index was being built but it blocked also all other databases during the whole index build. Here are the related logs from the primary during index build:
You see that the index was built from 17:09:25 to 17:16:18. It might be a coincidence but one of the 6 routers even crashed during the index build:
The other 5 routers survived. I can provide you the mongod and mongos logs. |
| Comments |
| Comment by Carl Champain (Inactive) [ 18/Feb/20 ] | |||||||
|
Apologies for the delayed response. Kind regards, | |||||||
| Comment by Carl Champain (Inactive) [ 07/Feb/20 ] | |||||||
|
Yes, the upload succeeded. Thank you! | |||||||
| Comment by Kay Agahd [ 07/Feb/20 ] | |||||||
|
Anyone? | |||||||
| Comment by Kay Agahd [ 05/Feb/20 ] | |||||||
|
Hi carl.champain, I've uploaded the router and configserver logs again and also the diagnostic data. Did the upload succeed this time? | |||||||
| Comment by Carl Champain (Inactive) [ 04/Feb/20 ] | |||||||
|
Sorry, I misspoke in my previous comment: I can open sharedSystem01.primary.log.mongo-hotel01-01.db00.pro07.eu.idealo.com.gz. | |||||||
| Comment by Carl Champain (Inactive) [ 04/Feb/20 ] | |||||||
|
Can you also please archive (tar or zip) the $dbpath/diagnostic.data directory (the contents are described here) and upload them? Thanks, | |||||||
| Comment by Kay Agahd [ 02/Feb/20 ] | |||||||
|
Hi carl.champain, I've uploaded router, configserver and mongod log files but I doubt that the upload succeeded because the upload was quite fast terminated. However no error message was thrown.
The lines I replaced in the curl statement are:
Is this correct?
What's the correct way to use the curl statement? | |||||||
| Comment by Carl Champain (Inactive) [ 31/Jan/20 ] | |||||||
|
Thank you for the report. Kind regards, |