[DOCS-10588] Warn about building an index with a unique constraint on a Replica Set Created: 27/Jul/17  Updated: 30/Oct/23  Resolved: 08/Aug/18

Status: Closed
Project: Documentation
Component/s: manual
Affects Version/s: None
Fix Version/s: Server_Docs_20231030

Type: Bug Priority: Critical - P2
Reporter: Eric Milkie Assignee: Kay Kim (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
is related to SERVER-30276 Secondary crashes after querying a un... Closed
Participants:
Days since reply: 5 years, 26 weeks, 6 days ago

 Description   

https://docs.mongodb.com/manual/tutorial/build-indexes-on-replica-sets/
If one follows the round-robin method for building an index with a unique constraint, it is possible to end up with different data on different nodes (see SERVER-30276). There are workarounds to avoid this situation:
1. Build the index normally using a foreground or background index build.
Or
2. Stop writes to the collection (or avoid inserting unique-constraint-violating data) during the round-robin index building.



 Comments   
Comment by Githook User [ 09/Aug/18 ]

Author:

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

Message: DOCS-10588: forgot to change to gerund from infinitive
Branch: v3.6
https://github.com/mongodb/docs/commit/cdbfe7c2f801c6a6e5e246ad0811e7833ef31701

Comment by Githook User [ 09/Aug/18 ]

Author:

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

Message: DOCS-10588: repeat rolling index build blurg in unique index page
Branch: v3.6
https://github.com/mongodb/docs/commit/4f5712df14ceb5cc6619b4591bbe6f1d89ca41b4

Comment by Kay Kim (Inactive) [ 08/Aug/18 ]

Added to the unique index page

Comment by Githook User [ 08/Aug/18 ]

Author:

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

Message: DOCS-10588: forgot to change to gerund from infinitive
Branch: v3.4
https://github.com/mongodb/docs/commit/36afb4bb2a7bb668e72ce1bbb7f95164aead4eaf

Comment by Githook User [ 08/Aug/18 ]

Author:

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

Message: DOCS-10588: repeat rolling index build blurg in unique index page
Branch: v3.4
https://github.com/mongodb/docs/commit/e8ecb4ce864e4b2bb5b1e71906c79cb5575b8dbd

Comment by Githook User [ 08/Aug/18 ]

Author:

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

Message: DOCS-10588: forgot to change to gerund from infinitive
Branch: master
https://github.com/mongodb/docs/commit/db26c3a4793bcb852db758f9c7e96160481e74b5

Comment by Githook User [ 08/Aug/18 ]

Author:

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

Message: DOCS-10588: repeat rolling index build blurg in unique index page
Branch: master
https://github.com/mongodb/docs/commit/1cb34ee4ecdbcf2e1eb59eba94ecf22fb3542b2a

Comment by Githook User [ 08/Nov/17 ]

Author:

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

Message: DOCS-10588: round-robin index build for unique indexes
Branch: v3.0
https://github.com/mongodb/docs/commit/d035bebbcaf2211a65c84faf2f6abdaa632bb262

Comment by Githook User [ 08/Nov/17 ]

Author:

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

Message: DOCS-10588: round-robin index build for unique indexes
Branch: v3.2
https://github.com/mongodb/docs/commit/a2bd31681df61991aa0bdbe123fabcefb68ff949

Comment by Githook User [ 08/Nov/17 ]

Author:

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

Message: DOCS-10588: round-robin index build for unique indexes
Branch: v3.4
https://github.com/mongodb/docs/commit/dfa4dbe011dd2b3fada25645d70da1ebead13d10

Comment by Githook User [ 08/Nov/17 ]

Author:

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

Message: DOCS-10588: round-robin index build for unique indexes
Branch: master
https://github.com/mongodb/docs/commit/c33ea4c754c2f313780f2eac9999788b875535ea

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