Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2.2, 10.3.0, 10.1.32
-
MariaDB installed using repo on your site to Ubuntu 16.04.
Description
MariaDB gets the following deadlock error:
localhost-dir: sql_create.c:837-5 Fill File table Query failed: INSERT INTO File
(FileIndex, JobId, PathId, FilenameId, LStat, MD5, DeltaSeq) SELECT
batch.FileIndex, batch.JobId, Path.PathId, Filename.FilenameId,batch.LStat,
batch.MD5, batch.DeltaSeq FROM batch JOIN Path ON (batch.Path = Path.Path) JOIN
Filename ON (batch.Name = Filename.Name): ERR=Deadlock found when trying to get
lock;
When running the Bacula 9.0.1 regression script named: three-pool-virtual-test
This does not occur on any version of MySQL, nor the Ubuntu version 10.0 of MariaDB. The code has been stable for many years.
I am running all instances of MariaDB and MySQL out of the box. I have changed no parameters.
This appears to be a false deadlock detection. Note, it is 100% reproducible.
Attachments
Issue Links
- is duplicated by
-
MDEV-16067 Invalid deadlock detection
- Closed
-
MDEV-16709 InnoDB: Error: trx already had an AUTO-INC lock
- Closed
- relates to
-
MDEV-17561 Deadlocks happen often when updating different rows
- Closed
-
MDEV-11080 InnoDB: Failing assertion: table->n_waiting_or_granted_auto_inc_locks > 0
- Closed