[MDEV-16052] galera mtr galera_certification_double_failure fails with deadlock Created: 2018-04-27  Updated: 2018-09-11  Resolved: 2018-09-11

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.3.6
Fix Version/s: 10.2.18, 10.3.10

Type: Bug Priority: Major
Reporter: Zdravelina Sokolovska (Inactive) Assignee: Zdravelina Sokolovska (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

CentOS 7.4.



 Description   

galera mtr galera_certification_double_failure from galera_3nodes test suite fails with deadlock

checked on mariadb-10.3.6-76-g461de7e MariaDB Version 10.3.7-MariaDB

$ ./mysql-test-run.pl galera_3nodes.galera_certification_double_failure
Logging: /home/qa-user1/rr/server/mysql-test/mysql-test-run.pl  galera_3nodes.galera_certification_double_failure
vardir: /home/qa-user1/rr/build-mariadb/mysql-test/var
Checking leftover processes...
 - found old pid 29375 in 'mysqld.1.pid', killing it...
   process did not exist!
 - found old pid 29379 in 'mysqld.3.pid', killing it...
   process did not exist!
 - found old pid 29377 in 'mysqld.2.pid', killing it...
   process did not exist!
Removing old var directory...
Creating var directory '/home/qa-user1/rr/build-mariadb/mysql-test/var'...
Checking supported features...
MariaDB Version 10.3.7-MariaDB
 - SSL connections supported
Collecting tests...
Installing system database...
 
==============================================================================
 
TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------
 
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
galera_3nodes.galera_certification_double_failure 'innodb' [ fail ]
        Test ended at 2018-04-27 19:54:34
 
CURRENT_TEST: galera_3nodes.galera_certification_double_failure
--- /home/qa-user1/rr/server/mysql-test/suite/galera_3nodes/r/galera_certification_double_failure.result        2018-04-23 18:14:30.322304529 +0300
+++ /home/qa-user1/rr/server/mysql-test/suite/galera_3nodes/r/galera_certification_double_failure.reject        2018-04-27 19:54:34.321952693 +0300
@@ -11,6 +11,6 @@
 INSERT INTO t2 VALUES (1);
 connection node_1;
 COMMIT;
-ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
+ERROR 40001: Deadlock: wsrep aborted transaction
 DROP TABLE t1;
 DROP TABLE t2;
 
mysqltest: Result length mismatch
 

galera_3nodes.galera_certification_double_failure 'innodb' [ fail ]
        Test ended at 2018-04-27 19:37:43
 
CURRENT_TEST: galera_3nodes.galera_certification_double_failure
--- /home/qa-user1/rr/server/mysql-test/suite/galera_3nodes/r/galera_certification_double_failure.result        2018-04-23 18:14:30.322304529 +0300
+++ /home/qa-user1/rr/server/mysql-test/suite/galera_3nodes/r/galera_certification_double_failure.reject        2018-04-27 19:37:43.343732874 +0300
@@ -11,6 +11,6 @@
 INSERT INTO t2 VALUES (1);
 connection node_1;
 COMMIT;
-ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
+ERROR 40001: Deadlock: wsrep aborted transaction
 DROP TABLE t1;
 DROP TABLE t2;
 
mysqltest: Result length mismatch



 Comments   
Comment by Mario Karuza (Inactive) [ 2018-08-31 ]

Commit 5e0b13d1734942d860416ed1b51f7dd75760e020 changed reporting from my_error to my_message. Test record was not changed.

Generated at Thu Feb 08 08:26:00 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.