You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
We have millions of queries on this DB per day, but about once per day, we get a deadlock error with a query where we're not using locks. The query:
UPDATE some_table SET last_run_timestamp = NOW() WHERE id=? AND (last_run_timestamp IS NULLOR last_run_timestamp < NOW() - INTERVAL 3 MINUTE AND last_run_timestamp = ?)
The error: Deadlock found when trying to get lock; try restarting transaction
Our code uses no manually created transactions, but we're getting a transaction error, which leads me to believe the library is creating one on our behalf, and doing so incorrectly.
The text was updated successfully, but these errors were encountered:
We have millions of queries on this DB per day, but about once per day, we get a deadlock error with a query where we're not using locks. The query:
The error: Deadlock found when trying to get lock; try restarting transaction
Our code uses no manually created transactions, but we're getting a transaction error, which leads me to believe the library is creating one on our behalf, and doing so incorrectly.
By default, autocommit mode is enabled in MySQL and each SQL statement forms a single transaction on its own.
It's normal to experience occasional deadlocks when you have multiple connections performing lots of updates targeting a single table. Your code should be written to detect these deadlock errors when they occur and re-run the statement.
We have millions of queries on this DB per day, but about once per day, we get a deadlock error with a query where we're not using locks. The query:
The error:
Deadlock found when trying to get lock; try restarting transaction
Our code uses no manually created transactions, but we're getting a transaction error, which leads me to believe the library is creating one on our behalf, and doing so incorrectly.
The text was updated successfully, but these errors were encountered: