Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.4.9
-
None
-
OS: CentOS Linux release 7.6.1810 (Core).
Description
It sporadically fails only on local suite runs.
MariaDB Version 10.4.9-MariaDB-debug: Repository: MariaDB/server; branch 10.4; Revision 9afbb1069ab4178741b76adefacd3f6a0ed51369; debug built from sources.
Galera lib 26.4.3(r4535): Repository: MariaDB/galera; branch mariadb-4.x; Revision 752664dc3c7065d8e0c73ac99d0028a5f84eb250; debug built from sources.
Run:
./mtr --suite galera --testcase-timeout=90 --force --big-test --max-test-fail=0 --timer --timestamp --timediff
|
stdout.log:
query 'COMMIT' failed: 1213: Deadlock found when trying to get lock; try restarting transaction
191029 2:02:21 +21.842 galera.galera_sst_mysqldump_with_key 'debug,innodb' [ fail ]
|
Test ended at 2019-10-29 02:02:21
|
|
CURRENT_TEST: galera.galera_sst_mysqldump_with_key
|
mysqltest: In included file "./suite/galera/include/galera_st_shutdown_slave.inc":
|
included from /home/stepan/mariadb/10.4/github/mysql-test/suite/galera/t/galera_sst_mysqldump_with_key.test at line 26:
|
At line 22: query 'COMMIT' failed: 1213: Deadlock found when trying to get lock; try restarting transaction
|
|
The result from queries just before the failure was:
|
< snip >
|
Performing State Transfer on a server that has been shut down cleanly and restarted
|
connection node_1;
|
CREATE TABLE t1 (f1 CHAR(255)) ENGINE=InnoDB;
|
SET AUTOCOMMIT=OFF;
|
START TRANSACTION;
|
INSERT INTO t1 VALUES ('node1_committed_before');
|
INSERT INTO t1 VALUES ('node1_committed_before');
|
INSERT INTO t1 VALUES ('node1_committed_before');
|
INSERT INTO t1 VALUES ('node1_committed_before');
|
INSERT INTO t1 VALUES ('node1_committed_before');
|
COMMIT;
|
connection node_2;
|
SET AUTOCOMMIT=OFF;
|
START TRANSACTION;
|
INSERT INTO t1 VALUES ('node2_committed_before');
|
INSERT INTO t1 VALUES ('node2_committed_before');
|
INSERT INTO t1 VALUES ('node2_committed_before');
|
INSERT INTO t1 VALUES ('node2_committed_before');
|
INSERT INTO t1 VALUES ('node2_committed_before');
|
COMMIT;
|