OPERATIONAL DEFECT DATABASE
...
...
I was able to insert a document with combined shard key value > 512 by using findAndModify with query for that shard key value and then upsert:true and update which sets those fields again. The check for shard key > 512 seems to get bypassed.
craig.homa commented on Tue, 15 Sep 2020 15:50:01 +0000: Closing as this problem has gone away due to the restriction being removed in 4.4. Ref: SERVER-42368 for more detail on how this was fixed. asya commented on Tue, 11 Feb 2020 19:20:31 +0000: Turns out this isn't an issue anymore for 4.4 as there is a different way to limit the size of the result from splitVector. This ticket should be just about what to do in 4.2 (and 4.0). sheeri.cabral commented on Thu, 30 Jan 2020 14:25:13 +0000: Is this something query can fix by throwing an error? kateryna.kamenieva
sh.shardCollection("test.foo", {shardkey:1}); db.foo.insert({shardkey:"012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890"}) /* errors correctly */ db.foo.update({shardkey:"012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890"},{$set:{shardkey:"012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890"}},{upsert:true}) /* errors correctly */ db.foo.findAndModify({query: {shardkey:"012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890"}, update: {$set:{shardkey:"012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890"}}, upsert:true}) /* succeeds */ Object.bsonsize(db.foo.findOne({},{_id:0})) 521 :(
Click on a version to see all relevant bugs
MongoDB Integration
Learn more about where this data comes from
Bug Scrub Advisor
Streamline upgrades with automated vendor bug scrubs
BugZero Enterprise
Wish you caught this bug sooner? Get proactive today.
