Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0(EOL), 10.1(EOL), 10.2(EOL)
-
None
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
|
Attachments
Issue Links
- blocks
-
MDEV-7069 Fix buildbot failures in main server trees
-
- Stalled
-
Activity
also on 10.3 http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-quantal-amd64/builds/7636/steps/test/logs/stdio
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!
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;
|
|
Recent occurrence on 10.2:
http://buildbot.askmonty.org/buildbot/builders/kvm-deb-stretch-x86/builds/603/steps/mtr/logs/stdio