[MDEV-20943] Galera test failure on galera.galera_sst_mysqldump_with_key: query 'COMMIT' failed: 1213: Deadlock found when trying to get lock Created: 2019-11-01  Updated: 2020-05-18  Resolved: 2020-02-10

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

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

OS: CentOS Linux release 7.6.1810 (Core).


Attachments: Text File 191028_HDD_galera_suite_stdout.log     Zip Archive 191028_galera.galera_sst_mysqldump_with_key.zip    
Issue Links:
Relates

 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;

Other logs.



 Comments   
Comment by Stepan Patryshev (Inactive) [ 2019-11-22 ]

It is also failed on ES 10.4.

MariaDB Version 10.4.10-4-MariaDB-debug: repository MariaDBEnterprise; branch 10.4-enterprise; commit 25b895a61f020feba0342a36f688a7a99e97d9f8.

Galera lib 26.4.4(r4702) debug: repository es-galera; branch es-mariadb-4.x; commit 2a4742f4f9b713d61c99bfbe348d01804e35d698.

Comment by Stepan Patryshev (Inactive) [ 2019-12-23 ]

Decreased the priority since it's not failed on bb or Azure, but is failed sporadically on local runs (debug and non-debug).

Comment by Stepan Patryshev (Inactive) [ 2020-02-10 ]

Closing since it does not fail on CI.

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