[MDEV-24897] galera.galera_mdev_15611 MTR failed: Aborting on MDL BF-BF conflict Created: 2021-02-16  Updated: 2022-05-02  Resolved: 2022-05-02

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.4.18
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Stepan Patryshev (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Cannot Reproduce Votes: 0
Labels: None
Environment:

kvm-deb-bionic-aarch64


Attachments: Zip Archive 210126_galera_mdev_15611_104_CS.zip     HTML File 210126_stdio_104_CS.html    

 Description   

galera.galera_mdev_15611 failed on BB 10.4 CS: Aborting on MDL BF-BF conflict.
It seems to be a sporadic issue.

stdio.log:

10.4.18, 1398160a719394cff3e7e4ee214f51375e8825a1, kvm-deb-bionic-aarch64

galera.galera_mdev_15611 'innodb'        w1 [ fail ]  Found warnings/errors in server log file!
        Test ended at 2021-01-26 12:04:01
line
2021-01-26 12:03:34 12 [ERROR] Aborting
^ Found warnings in /dev/shm/var/1/log/mysqld.2.err
ok
 
 - saving '/dev/shm/var/1/log/galera.galera_mdev_15611-innodb/' to '/dev/shm/var/log/galera.galera_mdev_15611-innodb/'
 
Retrying test galera.galera_mdev_15611, attempt(2/3)...
 
worker[1] > Restart  - not started
worker[1] > Restart  - not started

mysqld.2.err.1:

10.4.18, 1398160a719394cff3e7e4ee214f51375e8825a1, kvm-deb-bionic-aarch64

2021-01-26 12:03:34 12 [Note] WSREP: MDL BF-BF conflict
schema:  test
request: (12 	seqno 5 	wsrep (high priority, exec, executing) cmd 0 161 	insert into t1 select 1fK`)
granted: (11 	seqno 4 	wsrep (toi, exec, executing) cmd 0 1 	CREATE TABLE t2 (
id int primary key ,
f_id int DEFAULT NULL, FOREIGN KEY(f_id)  REFERENCES t1 (id)
))
2021-01-26 12:03:34 12 [ERROR] Aborting 

Server logs.


Generated at Thu Feb 08 09:33:32 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.