mysql sharding stack overflow_我测试sharding时提示出错如上，不过我是给id加过索引呀。...

最新推荐文章于 2022-07-05 16:32:40 发布

Alan王愛倫

最新推荐文章于 2022-07-05 16:32:40 发布

阅读量109

点赞数

文章标签： mysql sharding stack overflow

本文链接：https://blog.csdn.net/weixin_42299198/article/details/114759595

版权

该楼层疑似违规已被系统折叠隐藏此楼查看此楼

odm finding:

am a newbie of mongodb,here is a simple case but got an error:

I want to use _id field (generated and indexed automatically) as a sharding key in mongodb, but got this error.

{"proposedKey" : { "_id" : "hashed"},"curIndexes" : [ { "v" : 1, "key" : { "_id" : 1 }, "name" : "_id_", "ns" : "jackfruit.scenicspots" }, { "v" : 1, "key" : { "geoLocation" : "2dsphere" }, "name" : "geoLocation_2dsphere", "ns" : "jackfruit.scenicspots", "2dsphereIndexVersion" : 2 }],"ok" : 0,"errmsg" : "please create an index that starts with the shard key before sharding."

}

the error message showed that I already have an Index named _id_ on key _id, why the error still occur?

0down voteaccepted I found an answer from manual.MongoDB does not support creating new unique indexes in sharded collections and will not allow you to shard collections with unique indexes on fields other than the _id field.And here is a solution:fromEnforce Unique Keys for Sharded Collections

http://stackoverflow.com/questions/31158499/can-not-use-indexed-key-id-as-a-sharding-key-in-mongodb