Details
-
Task
-
Resolution: Gone away
-
Minor - P4
-
None
-
None
-
None
-
(copied to CRM)
-
Empty show more show less
Description
Server returns a confusing message when recreating an index with the same options that already exists on the server:
Index with name: key_1_namespace_1_workflowLocale_1 already exists with different options
|
To reproduce:
1. Restore the attached bson file:
$ mongorestore --drop -h Cluster0-shard-0/cluster0-shard-00-00-07vah.mongodb.net:27017,cluster0-shard-00-01-07vah.mongodb.net:27017,cluster0-shard-00-02-07vah.mongodb.net:27017 --ssl --username angelamorgan --password xxxx --authenticationDatabase admin -d t /Users/angelamorgan/Downloads/00502901/b2c-experience-extra-light/b2c-experience/aposDocs.bson
|
2018-07-06T14:53:10.606+0100 checking for collection data in /Users/angelamorgan/Downloads/00502901/b2c-experience-extra-light/b2c-experience/aposDocs.bson
|
2018-07-06T14:53:10.632+0100 reading metadata for t.aposDocs from /Users/angelamorgan/Downloads/00502901/b2c-experience-extra-light/b2c-experience/aposDocs.metadata.json
|
2018-07-06T14:53:10.668+0100 restoring t.aposDocs from /Users/angelamorgan/Downloads/00502901/b2c-experience-extra-light/b2c-experience/aposDocs.bson
|
2018-07-06T14:53:13.257+0100 [###.....................] t.aposDocs 4.08MB/24.8MB (16.5%)
|
2018-07-06T14:53:16.261+0100 [####....................] t.aposDocs 5.02MB/24.8MB (20.3%)
|
2018-07-06T14:53:19.261+0100 [######..................] t.aposDocs 6.90MB/24.8MB (27.9%)
|
2018-07-06T14:53:22.256+0100 [#########...............] t.aposDocs 10.1MB/24.8MB (41.0%)
|
2018-07-06T14:53:25.261+0100 [###########.............] t.aposDocs 12.1MB/24.8MB (48.9%)
|
2018-07-06T14:53:28.257+0100 [############............] t.aposDocs 13.0MB/24.8MB (52.5%)
|
2018-07-06T14:53:31.261+0100 [#############...........] t.aposDocs 13.8MB/24.8MB (55.9%)
|
2018-07-06T14:53:34.258+0100 [##############..........] t.aposDocs 15.4MB/24.8MB (62.4%)
|
2018-07-06T14:53:37.256+0100 [##################......] t.aposDocs 19.5MB/24.8MB (78.7%)
|
2018-07-06T14:53:40.261+0100 [##################......] t.aposDocs 19.5MB/24.8MB (78.7%)
|
2018-07-06T14:53:43.257+0100 [####################....] t.aposDocs 21.1MB/24.8MB (85.3%)
|
2018-07-06T14:53:46.261+0100 [#####################...] t.aposDocs 21.9MB/24.8MB (88.5%)
|
2018-07-06T14:53:49.261+0100 [########################] t.aposDocs 24.8MB/24.8MB (100.0%)
|
2018-07-06T14:53:52.257+0100 [########################] t.aposDocs 24.8MB/24.8MB (100.0%)
|
2018-07-06T14:53:55.261+0100 [########################] t.aposDocs 24.8MB/24.8MB (100.0%)
|
2018-07-06T14:53:56.332+0100 [########################] t.aposDocs 24.8MB/24.8MB (100.0%)
|
2018-07-06T14:53:56.332+0100 restoring indexes for collection t.aposDocs from metadata
|
2018-07-06T14:53:58.424+0100 finished restoring t.aposDocs (25660 documents)
|
2018-07-06T14:53:58.424+0100 done
|
2. Run getIndexes() on the collection aposDocs:
{
|
"v" : 2,
|
"unique" : true,
|
"key" : {
|
"key" : 1,
|
"namespace" : 1,
|
"workflowLocale" : 1
|
},
|
"name" : "key_1_namespace_1_workflowLocale_1",
|
"partialFilterExpression" : {
|
"key" : {
|
"$exists" : true
|
},
|
"type" : "dgad-i18next"
|
},
|
"background" : false,
|
"ns" : "t.aposDocs"
|
}
|
3. Recreate the index key_1_namespace_1_workflowLocale_1 on the collection aposDocs:
|
```
|
MongoDB Enterprise Cluster0-shard-0:PRIMARY> db.aposDocs.createIndex({ key: 1, namespace: 1, workflowLocale: 1 }, { partialFilterExpression: { type: 'dgad-i18next', key: {$exists: true} }, unique: true, background: false })
|
{
|
"operationTime" : Timestamp(1530885953, 1),
|
"ok" : 0,
|
"errmsg" : "Index with name: key_1_namespace_1_workflowLocale_1 already exists with different options",
|
"code" : 85,
|
"codeName" : "IndexOptionsConflict"
|
}
|
Attachments
Issue Links
- is related to
-
NODE-1572 Inserting using `Map` assumes all keys are strings
-
- Closed
-
- related to
-
SERVER-36253 partialFilterExpression in partial indexes considers order of fields relevant
-
- Closed
-