[MDEV-23617] galera_sr.galera_sr_rollback_retry MTR failed: 1213: Deadlock found when trying to get lock Created: 2020-08-28  Updated: 2020-10-06  Resolved: 2020-09-14

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.4.15
Fix Version/s: 10.4.16, 10.5.7, 10.6.0

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

kvm-deb-stretch-x86



 Description   

galera_sr.galera_sr_rollback_retry failed on BB 10.4: "1213: Deadlock found when trying to get lock".
It seems to be a sporadic issue.

stdio.log:

10.4.15 2000d05c2ed85563e35c4548d9518249ddf403df

galera_sr.galera_sr_rollback_retry 'innodb' w2 [ fail ]
        Test ended at 2020-08-25 01:56:06
 
CURRENT_TEST: galera_sr.galera_sr_rollback_retry
mysqltest: In included file "./include/have_wsrep_enabled.inc": 
included from ./include/galera_init.inc at line 15:
included from ./include/galera_cluster.inc at line 11:
included from /usr/share/mysql/mysql-test/suite/galera_sr/t/galera_sr_rollback_retry.test at line 2:
At line 6: query 'if (`SELECT COUNT(*)=0 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME = 'wsrep_on' AND VARIABLE_VALUE='ON'`)
{' failed: 1213: Deadlock found when trying to get lock; try restarting transaction
 
 - skipping '/dev/shm/var/2/log/galera_sr.galera_sr_rollback_retry-innodb/'
 
Retrying test galera_sr.galera_sr_rollback_retry, attempt(2/3)...


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