I am running MySql v8.0 with InnoDB. I have a simple transaction that has a SELECT (not a SELECT ... FOR UPDATE) followed by an INSERT. I'm getting frequent deadlocks when many DB inserts are happening simultaneously. All inserts use…
From inside a procedure I need to separate 4k records of one big table to process it each one in a separate cursor. UPDATE queue SET `status` = 'enqueued', `hash` = new_hash -- prev generated hash WHERE `status` = 'new'…
We have a long standing problem with a certain deadlock in our DB. The conflicting queries are almost always these two: UPDATE db.tbl SET pid = 68111 WHERE pid IS NULL AND processed IS NULL AND `time` <= now() LIMIT…
I have migrated a dockerized NextCloud installation to a new server but I am receiving error messages “Internal server error”: Nextcloud version: 25.0.3 Operating system and version: Ubuntu 22.04 I have checked the output of Nextcloud log in Admin >…
In an attempt to overcome deadlocks on the combat server, I reached a dead end. There are 2 tables: First: create table table_1 ( id int auto_increment primary key, data1 text null, data2 text null ); Second: create table table_2…