CODEWITHSUNDEEP
phpsymfonyaxiossingle-page-application
undefinedman
undefinedman

Reputation: 670

Double requests causing double inserts

We have a SPA app with big traffic and sometimes occasionally double rows are inserted in several parts of application.

For example user registration. Normally the validation mechanism will do the trick checking if email address already exists, however I was able to reproduce the problem by dispatching the same request twice using axios resulting doubled user in the database.

I initially thought that the second request should throw validation error but apparently it's too quick and checks user before the first request was able to store it.

So I put 500ms delay between those requests and yes it worked, the second request thrown a validation error.

My question is, what are the techniques to prevent double inserts IF TWO REQUESTS ARE ALREADY DISPATCHED IN THE SAME FRACTION OF A SECOND?

Of course we have blocked submit form button (since the beginning) after making first request, yet people somehow manages to dispatch requests twice.

Upvotes: 0

Views: 161

Answers (1)

T Paone
T Paone

Reputation: 483

One option I've utilized in the past is database locking. I'm a bit rusty on this, but in your case:

  1. Request WRITE LOCK for the table
  2. Run SELECT on table to find user.
  3. Run INSERT on table.
  4. Release WRITE LOCK.

This post on DB locking should give you a better idea of what locks apply what affect. Note: some database systems may implement locks differently.

Edit: I should also note that there will be additional performance issues using database locks.

Upvotes: 2

Related Questions