How to not pick the same object twice while making queries concurrently?

Question

I'm working on a delivery service where I'm processing 8 orders at the same time concurrently, for each of these orders, I must get a unique consignment number that is saved on the database. But since the operations are concurrent, they are all picking up the same object/consignment number.

const query = new Parse.Query("Consign") query.doesNotExist("order") query.equalTo("staging", staging) query.exists("number") query.limit(1) await query.find().then(function (result) { if (result.length > 0) { order.set("consign_no", result[0].get("number")) result[0].set("order", order) } else { //failed } }).catch((err)=>{ console.log(err); })

How do I make this query in such a way that it picks up unique objects even when ran concurrently?

I'm not an expert but maybe you find inspiration on stackoverflow.com/questions/32728670/mutex-with-mongodb (that leads you to stackoverflow.com/questions/9274777/mongodb-as-a-queue-service ) Good luck! — malarres
– malarres, Commented May 20, 2021 at 13:29

D. SM · Accepted Answer · 2021-05-20 13:22:20Z

Based on an answer given here by someone else:

Create a counter collection
Insert one document into it with {value:1}
Whenever you need a value, use find-and-modify to $inc this document and return the new value

This should work (subject to Is it possible to update the same document on concurrent findAndModify operations in Mongo?) for giving you distinct values, note that in your documents the values may end up not being consecutive if you insert a value which you retrieved later first.

Collectives™ on Stack Overflow

How to not pick the same object twice while making queries concurrently?

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related