Error
GenericJDBCException: ERROR: deadlock detected
What the error means
A deadlock occurred between database operations.
Typically:
two processes or users are simultaneously working with related records
each of them holds some of the so-called locks (blocking changes from another source)
while at the same time waiting for a lock held by the other process
👉 The database evaluates the situation as a deadlock and terminates one of the operations with an error.
Resolution
retry the operation
ensure that the same record is not being edited by multiple users at the same time
for bulk operations, limit the concurrency of multiple actions on the same data