#concurrency

Idempotency Is a Race Until the Database Says Otherwise

Check-then-insert looks correct and isn't. The only reliable fix is to stop checking and let a constraint decide.