Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.4.9
-
None
-
OS: CentOS Linux release 7.6.1810 (Core).
Description
It sporadically failed only on a local suite run with --parallel=auto.
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 --parallel=auto --testcase-timeout=90 --force --big-test --max-test-fail=0 --timer --timestamp --timediff
|
stdout.log:
query 'SELECT COUNT = 300000 FROM t1' failed: 1205: Lock wait timeout exceeded
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;
|
Attachments
Issue Links
- relates to
-
MDEV-21532 galera.galera_rsu_drop_pk MTR failed: Result content mismatch
- Closed