Details
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:42Test 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-286Attempting 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:30Test 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-328BAttempting backtrace. You can use the following information to find out
Attempting backtrace. You can use the following information to find out