MongoDB update multiple documents

Question

Schema:

{
    name: String,
    available: Boolean,
    for: String
}

there are "a":

{
    name: "a",
    available: true,
    for: ["b", "c"]
}

and "b":

{
    name: "b",
    available: true,
    for: ["a", "b]
}

if I update a.available = false, I should update b.available = false at the same time. how could I update two documents and make sure there would not has other process/thread getting "b" between the time when updating "a" and "b".

Sean Reilly · Accepted Answer · 2012-05-09T15:21:32.363

5

MongoDB doesn't support atomic transactions. So if you need to make the first update "undo itself" if the second update fails, then you're out of luck.

However, in some limited cases, MongoDB does support isolated updates. The update isn't all or nothing, but MongoDB will guarantee that nobody else writes to the collection in the middle of your write.

A couple of major caveats:

The documents must all be in the same collection
The updates must all be specified in one query

Based on the example you've provided, your case might qualify.

Here is the documentation describing an isolated update.

Basically you'll want to issue the an update similar to the following to atomically set "available" to false when name is either "a" or "b":

db.blah.update({"name": {"$in": ["a", "b"]}, "$atomic": 1}, {"available": false});

edited May 09 '12 at 15:21

answered May 09 '12 at 15:11

Sean Reilly

21,526
4
48
62

how if I want to update different docs atomically with different value. update count = 1 if name=="a"; update count = 2 if name=="b". – Kevin May 09 '12 at 15:37
That's probably not possible. As I said, there are some significant limits to this functionality — MongoDB isn't really designed for that sort of thing. – Sean Reilly May 09 '12 at 15:40

score 3 · Answer 2 · edited May 23 '17 at 12:03

If you really need it, it may be possible to implement this logic on top of mongodb (in your application or better in a wrapper for the mongo driver).

You are asking for the isolation property. One way to achieve that is by using the MVCC pattern. This is really overkill but this is to give you an idea of what you could do if you really need both mongodb and some ACID properties.

A generic implementation of the MVCC pattern is described here. There is also a project on github for implementing this, but it is a java project.

You may also see this SO question and their answers. My present answer is just a summary of it.

MongoDB update multiple documents

2 Answers2