Does cleanupOrphaned Command work on hash based sharding?

[Joe Waller]

Hi,

I have a collection that is using hash based sharding on the _id command. I have detected duplicate documents by connecting directly to the shards. Can I use cleanupOrphaned command to clean up the duplicates when i using hash bashed sharding? Does this command know to compute the hash of _id before it compares to the chunk ranges?

thanks,

Joe

[Joe Waller]

Hi folks,

Can someone from the mongodb team confirm that is ok to use this command on hash sharded collections?

[Samantha Ritter]

Hi Joe,

Yes, it should be fine to use the cleanupOrphaned command with hashed shard keys. This is a case that we test for, if you're curious you can see the test here: https://github.com/mongodb/mongo/blob/master/jstests/sharding/cleanup_orphaned_cmd_hashed.js

Thanks,
Sam