Hi, we've been getting duplicate orders with the same original cart code and same guid. In the logs, there are actually multiple place order requests on the same cart. We already put a constraint on the Front-end that disables the Place Order button once the user clicks on it, but we are still getting these duplicate orders. We notice that when we have a problem with database usage, high traffic, the website can be unresponsive and it will take a while to load a page, then we got these duplicate orders. Both orders are placed a couple seconds or milliseconds apart.
What could explain this? Is it because of network retries? How could we prevent this from happening again?
I did some research. An option is we could add an attribute to Cart model to indicate that the cart is being processed. But for multi-node service, will it work? If the first request read the cart and set it is being processed, will the second one see that value is updated?
We tried to put a unique constraint on the guid on Order model, but it affects the performance, so we have to remove it.
How about distributed lock?
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.