MongoDB - unique multikey index not working as expected

Question

I have a problem with multikey indexes in MongoDB.

I have a collection named users, whose documents look more or less like this:

{
  "_id": ObjectId(),
  "name": "John Smith",
  ...
  "votes": [
    {
      "type": "news",
      "votedObjectId": "123"
    },
    {
      "type": "blog",
      "votedObjectId": "124"
    },
    {
      "type": "news"
      "votedObjectId": "225"
    }
  ]
}

I want to create an index on votedObjectId and I want users to vote only once for each article.

I ensured a unique index (code is in node.js - mongoskin module):

`this.ensureIndex({'votes.votedObjectId': 1}, {unique: true}, ...)`

Then I tried voting twice for the same article, and it actually added the exact same vote twice.

How can I ensure that the array will not contain duplicate elements?

P.S.

I do all inserts with {safe: true}, and the duplicate values I get are not returned by an insert operation, but actually inserted in the collection.

Community · Accepted Answer · 2017-05-23 11:47:27Z

11

The {unique: true} only guarantees uniqueness across objects, it does NOT guarantee uniqueness of the array elements inside the array.

But check out the addToSet functionality of mongodb.

Also this very similar question here. How to ensure unique item in an array based on specific fields - mongoDB?

edited May 23, 2017 at 11:47

CommunityBot

11 silver badge

answered Nov 6, 2012 at 10:17

VladT

3702 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

lortabac Over a year ago

Thanks. Program-level uniqueness check + $addToSet instead of $push seems to be the best solution in my case.

CordiS · Accepted Answer · 2012-12-13 18:40:14Z

3

Try

this.ensureIndex({'votes.votedObjectId': 1, _id: 1}, {unique: true}, ...)

or process voting with

this.update( 
  { _id:... , 'votes.votedObjectId':{$ne:'...'} }, 
  { $push: { votes: '...' }}
)

Hopefully, theese statements might help you to sort it out.

edited Dec 13, 2012 at 18:40

answered Dec 13, 2012 at 18:25

CordiS

665 bronze badges

Collectives™ on Stack Overflow

MongoDB - unique multikey index not working as expected

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related