[MDEV-10514] rpl.rpl_slave_grp_exec fails sporadically in buildbot with deadlock Created: 2016-08-07  Updated: 2021-01-15  Resolved: 2021-01-15

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.0, 10.1, 10.2
Fix Version/s: 10.2.35

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Alice Sherepa
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
blocks MDEV-7069 Fix buildbot failures in main server ... Stalled

 Description   

Happened ~12 times over the last 4 months on 10.0, 10.1, 10.2, different builders
http://buildbot.askmonty.org/buildbot/builders/kvm-deb-wily-amd64/builds/686/steps/test_5/logs/stdio

rpl.rpl_slave_grp_exec 'stmt,xtradb'     w1 [ fail ]
        Test ended at 2016-08-05 05:03:52
 
CURRENT_TEST: rpl.rpl_slave_grp_exec
mysqltest: At line 149: query 'RENAME TABLE t3 TO t3_bak' failed: 1213: Deadlock found when trying to get lock; try restarting transaction
 
The result from queries just before the failure was:
< snip >
SELECT * FROM t1 ORDER BY a;
a	b
SELECT * FROM t2 ORDER BY a;
a	b
include/stop_slave_io.inc
RENAME TABLE t3_bak TO t3;
include/start_slave.inc
connection master;
TRUNCATE t1;
TRUNCATE t2;
TRUNCATE t3;
connection slave;
 
*** Test transactional group w/ PK ***
connection master;
ALTER TABLE t1 ENGINE=InnoDB;
ALTER TABLE t2 ENGINE=InnoDB;
ALTER TABLE t3 ENGINE=InnoDB;
connection slave;
RENAME TABLE t3 TO t3_bak;
 
More results from queries before failure can be found in /dev/shm/var/1/log/rpl_slave_grp_exec.log
 
 - saving '/dev/shm/var/1/log/rpl.rpl_slave_grp_exec-stmt,xtradb/' to '/dev/shm/var/log/rpl.rpl_slave_grp_exec-stmt,xtradb/'
 
Retrying test rpl.rpl_slave_grp_exec, attempt(2/3)...
 
worker[1] > Restart  - not started
worker[1] > Restart  - not started
***Warnings generated in error logs during shutdown after running tests: rpl.rpl_slave_grp_exec
 
2016-08-05  5:03:52 140166176916224 [Warning] Slave: Table 'test.t3' doesn't exist Error_code: 1146
2016-08-05  5:03:52 140166176916224 [Warning] Slave: Table 'test.t3' doesn't exist Error_code: 1146



 Comments   
Comment by Elena Stepanova [ 2017-05-08 ]

Recent occurrence on 10.2:
http://buildbot.askmonty.org/buildbot/builders/kvm-deb-stretch-x86/builds/603/steps/mtr/logs/stdio

Comment by Alice Sherepa [ 2017-10-10 ]

also on 10.3 http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-quantal-amd64/builds/7636/steps/test/logs/stdio

Comment by Michael Widenius [ 2019-08-31 ]

Recent occurrence in buildbot:
http://buildbot.askmonty.org/buildbot/builders/kvm-deb-xenial-x86/builds/12872/steps/mtr/logs/stdio
I have disabled the test in 10.2 until this is fixed!

Comment by Alice Sherepa [ 2020-10-22 ]

http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-centos5-amd64/builds/14593

rpl.rpl_slave_grp_exec 'innodb,mix'      w2 [ fail ]
        Test ended at 2020-10-20 13:53:58
 
CURRENT_TEST: rpl.rpl_slave_grp_exec
mysqltest: At line 106: query 'RENAME TABLE t3 TO t3_bak' failed: 1213: Deadlock found when trying to get lock; try restarting transaction
 
The result from queries just before the failure was:
< snip >
1	AA_for_row_or_XX_for_stmt_mixed
SELECT * FROM t2 ORDER BY a;
a	b
1	AA_for_row_or_YY_for_stmt_mixed
include/stop_slave_io.inc
RENAME TABLE t3_bak TO t3;
include/start_slave.inc
connection master;
TRUNCATE t1;
TRUNCATE t2;
TRUNCATE t3;
connection slave;
 
*** Test non-transactional group w/ PK ***
connection master;
ALTER TABLE t1 ADD PRIMARY KEY (a);
ALTER TABLE t2 ADD PRIMARY KEY (a);
ALTER TABLE t3 ADD PRIMARY KEY (a);
connection slave;
RENAME TABLE t3 TO t3_bak;

Comment by Alice Sherepa [ 2021-01-15 ]

fixed by 4a97e25aec94d2e3a9 + 17cf27f5b61aa

Generated at Thu Feb 08 07:42:48 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.