[SERVER-44980] wrong update result with upsert:true - MongoDB Jira

XML

Word

Printable

JSON

mongo1886:PRIMARY> db

lpc

mongo1886:PRIMARY> db.lpc.find()

{ "_id" : ObjectId("5de9c501959eef478c3a21d7"), "xid" : 1 }

{ "_id" : ObjectId("5de9c503959eef478c3a21d8"), "xid" : 2 }

{ "_id" : ObjectId("5de9c56a959eef478c3a21da"), "xid" : 3, "xxxx" : 11}

mongo1886:PRIMARY> db.lpc.getIndexes()

                "v" : 2,

                "key" : {

                        "_id" : 1

},

                "name" : "_id_",

                "ns" : "lpc.lpc"

},

                "v" : 2,

                "key" : {

                        "xid" : "hashed"

},

                "name" : "xid_hashed",

                "ns" : "lpc.lpc"

},

                "v" : 2,

                "key" : {

                        "xid" : -1

},

                "name" : "xid_-1",

                "ns" : "lpc.lpc"

mongo1886:PRIMARY>

then i use a python script with 20 threads to update the {"xid" : 3}. at last i get the write.

mongo1886:PRIMARY> db.lpc.find()

{ "_id" : ObjectId("5de9c501959eef478c3a21d7"), "xid" : 1 }

{ "_id" : ObjectId("5de9c503959eef478c3a21d8"), "xid" : 2 }

{ "_id" : ObjectId("5de9c56a959eef478c3a21da"), "xid" : 3, "xxxx" : 11, "tmp_test_data" : NumberLong("46211725577525978") }

{ "_id" : ObjectId("5dea0b087cf278ae08d1ba91"), "xid" : 3, "tmp_test_data" : NumberLong("30455178109802127") }

i couldn't get the in other mongod . but in this mongod .it's a really truth.

is related to

SERVER-14322 Retry on predicate unique index violations of update + upsert -> insert when possible

SERVER-37124 Retry full upsert path when duplicate key exception matches exact query predicate