./mtr --suite galera --parallel=auto --testcase-timeout=90 --force --big-test --max-test-fail=0 --timer --timestamp --timediff

191029 14:16:10 +3.300 galera.galera_rsu_drop_pk 'innodb'       w4 [ fail ]

        Test ended at 2019-10-29 14:16:10

CURRENT_TEST: galera.galera_rsu_drop_pk

mysqltest: At line 34: query 'SELECT COUNT(*) = 300000 FROM t1' failed: 1205: Lock wait timeout exceeded; try restarting transaction

The result from queries just before the failure was:

< snip >

connection node_1;

connection node_1;

CREATE TABLE ten (f1 INTEGER);

INSERT INTO ten VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);

CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) Engine=InnoDB;

INSERT INTO t1 (f1) SELECT 000000 + (10000 * a1.f1) + (1000 * a2.f1) + (100 * a3.f1) + (10 * a4.f1) + a5.f1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4, ten AS a5;

INSERT INTO t1 (f1) SELECT 100000 + (10000 * a1.f1) + (1000 * a2.f1) + (100 * a3.f1) + (10 * a4.f1) + a5.f1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4, ten AS a5;;

connection node_2;

SET SESSION wsrep_OSU_method = "RSU";

ALTER TABLE t1 DROP PRIMARY KEY;

SET SESSION wsrep_OSU_method = "TOI";

INSERT INTO t1 (f1) SELECT 200000 + (10000 * a1.f1) + (1000 * a2.f1) + (100 * a3.f1) + (10 * a4.f1) + a5.f1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4, ten AS a5;

SELECT COUNT(*) = 300000 FROM t1;

COUNT(*) = 300000

1

SELECT MAX(f1) =  299999 FROM t1;

MAX(f1) =  299999

1

connection node_1;

SELECT COUNT(*) = 300000 FROM t1;