Details
Description
MariaDB Server: 10.4.3-MariaDB-debug built from sources, branch=10.4, commit: 2a791c53ad93c8bc1441dd227000234bd49c4990.
Galera4 lib 26.4.0(r4477): debug built from sources, commit: 9bd47835d0fcdcf2f041da39dbe5b98ff738ff10.
Run:
./mtr --suite galera --force --big-test --max-test-fail=0 --parallel=auto
|
stdout.log:
galera.galera_toi_truncate 'innodb' w2 [ fail ]
|
|
|
mysqltest: At line 45: query 'reap' succeeded - should have failed with errno 1213...
|
|
|
The result from queries just before the failure was:
|
connection node_2;
|
connection node_1;
|
connection node_1;
|
CREATE TABLE ten (f1 INTEGER) ENGINE=InnoDB;
|
INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
|
CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
|
connection node_2;
|
SET SESSION wsrep_retry_autocommit = 0;
|
INSERT INTO t1(f1) SELECT 1 FROM ten as a1, ten AS a2;
|
set debug_sync='ha_commit_trans_after_prepare WAIT_FOR go';
|
INSERT INTO t1 (f1) SELECT 1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4, ten AS a5, ten AS a6;;
|
connection node_1;
|
TRUNCATE TABLE t1;;
|
connection node_1;
|
connection node_2;
|
See also attached galera.galera_toi_truncate-innodb.zip
.
Note: This test has failed only on suite running, but on standalone running it has passed.
Attachments
Issue Links
- relates to
-
MDEV-18111 Galera 4: run galera test suite
-
- Closed
-
Activity
Reopened since it failed on Jenkins, 10.3 ES, but it not failed on BB.
|
10.3.22-6 dddb4468aefb02789f978c303b26f557991f9678, debug build, ubuntu-1804 |
galera.galera_toi_truncate 'innodb' w8 [ fail ]
|
Test ended at 2020-04-08 15:05:51
|
|
|
CURRENT_TEST: galera.galera_toi_truncate
|
mysqltest: At line 45: query 'reap' succeeded - should have failed with errno 1213...
|
|
|
The result from queries just before the failure was:
|
connection node_1;
|
CREATE TABLE ten (f1 INTEGER) ENGINE=InnoDB;
|
INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
|
CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
|
connection node_2;
|
SET SESSION wsrep_retry_autocommit = 0;
|
INSERT INTO t1(f1) SELECT 1 FROM ten as a1, ten AS a2;
|
set debug_sync='ha_commit_trans_after_prepare WAIT_FOR go';
|
INSERT INTO t1 (f1) SELECT 1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4, ten AS a5, ten AS a6;;
|
connection node_1;
|
TRUNCATE TABLE t1;;
|
connection node_1;
|
connection node_2;
|
Fixed, https://github.com/MariaDB/server/commit/df1846aeea7f821aec8d15d7cdcae25d2ca3cc8a and https://github.com/MariaDB/server/commit/de5e1711182a3c71223bf9a9dfd170eadbc375e4
On my machines it's not reproduced, but it was reproduced on buildbot on 12.03.2019: http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos74-amd64-debug/builds/1646/steps/mtr/logs/stdio