[MDEV-21483] Galera MTR tests failed: galera.MW-328A galera.MW-328B Created: 2019-12-19  Updated: 2020-06-22  Resolved: 2020-05-18

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.2, 10.3
Fix Version/s: 10.5.4, 10.2.33, 10.3.24, 10.4.14

Type: Bug Priority: Critical
Reporter: Timofey Turenko Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Attachments: File galera.mw328    
Issue Links:
Blocks

 Description   

galera.MW-328A galera.MW-328B failed in AZURE.

rhel6, rhel8, sles15,ubuntu16.04 - both

debian 8 and debian 9 - only galera.MW-328A

logs:

galera.MW-328A:

galera.MW-328A 'innodb' w2 [ fail ] timeout after 7200 seconds
Test ended at 2019-12-19 00:19:42

Test case timeout after 7200 seconds

== /var/tmp/mtr/2/log/MW-328A.log ==
CREATE TABLE t1 (f1 INTEGER AUTO_INCREMENT PRIMARY KEY, f2 CHAR(20) DEFAULT 'abc') ENGINE=InnoDB;
INSERT INTO t1 (f1) VALUES (1);
CREATE TABLE t2 (f1 CHAR(20)) ENGINE=InnoDB;
CREATE PROCEDURE proc_update ()
BEGIN
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
SET SESSION wsrep_sync_wait = 0;
WHILE 1 DO
UPDATE t1 SET f2 = LEFT(MD5(RAND()), 4);
END WHILE;
END|
connect node_1X, 127.0.0.1, root, , test, $NODE_MYPORT_1;
connection node_1X;
CALL proc_update();;
connection node_2;
SET SESSION wsrep_retry_autocommit = 0;

== /var/tmp/mtr/2/tmp/analyze-timeout-mysqld.2.err ==
mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/var/tmp/mtr/tmp/2/mysqld.2.sock' (111)

== /var/tmp/mtr/2/tmp/analyze-timeout-mysqld.1.err ==
mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/var/tmp/mtr/tmp/2/mysqld.1.sock' (111)

  • saving '/var/tmp/mtr/2/log/galera.MW-328A-innodb/' to '/var/tmp/mtr/log/galera.MW-328A-innodb/'
    ***Warnings generated in error logs during shutdown after running tests: galera.GAL-419 galera.MW-328A galera.MW-286

Attempting backtrace. You can use the following information to find out
Attempting backtrace. You can use the following information to find out

galera.MW-328B:

galera.MW-328B 'innodb' w1 [ fail ] timeout after 7200 seconds
Test ended at 2019-12-19 00:58:30

Test case timeout after 7200 seconds

== /var/tmp/mtr/1/log/MW-328B.log ==
CREATE TABLE t1 (f1 INTEGER AUTO_INCREMENT PRIMARY KEY, f2 CHAR(20) DEFAULT 'abc') ENGINE=InnoDB;
INSERT INTO t1 (f1) VALUES (1);
CREATE TABLE t2 (f1 CHAR(20)) ENGINE=InnoDB;
CREATE PROCEDURE proc_update ()
BEGIN
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
SET SESSION wsrep_sync_wait = 0;
WHILE 1 DO
UPDATE t1 SET f2 = LEFT(MD5(RAND()), 4);
END WHILE;
END|
connect node_1X, 127.0.0.1, root, , test, $NODE_MYPORT_1;
connection node_1X;
CALL proc_update();;
connection node_2;
SET SESSION wsrep_retry_autocommit = 0;

== /var/tmp/mtr/1/tmp/analyze-timeout-mysqld.2.err ==
mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/var/tmp/mtr/tmp/1/mysqld.2.sock' (111)

== /var/tmp/mtr/1/tmp/analyze-timeout-mysqld.1.err ==
mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/var/tmp/mtr/tmp/1/mysqld.1.sock' (111)

  • saving '/var/tmp/mtr/1/log/galera.MW-328B-innodb/' to '/var/tmp/mtr/log/galera.MW-328B-innodb/'
    ***Warnings generated in error logs during shutdown after running tests: galera.MW-328B

Attempting backtrace. You can use the following information to find out
Attempting backtrace. You can use the following information to find out



 Comments   
Comment by Julien Fritsch [ 2019-12-19 ]

tturenko remember to get the component Tests and to assign Stepan

Comment by Timofey Turenko [ 2019-12-19 ]

also happened with sles12 and 10.3

Comment by Timofey Turenko [ 2019-12-19 ]

+ 10.e Debian and Ubuntu

Comment by Timofey Turenko [ 2019-12-19 ]

longer log attached galera.mw328

Comment by Jan Lindström (Inactive) [ 2020-05-08 ]

I would need error logs from both nodes if these tests fail again.

Comment by Marko Mäkelä [ 2020-05-13 ]

The tests are now enabled in 10.2 and 10.3, but not 10.4, because on a merge, the tests galera.MW-328A galera.MW-328B would fail.
In 10.4, even after MDEV-22466 was fixed, the test galera.MW-328C is missing.

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