[MDEV-18838] galera.galera_toi_truncate: Test failure: mysqltest: query 'reap' succeeded - should have failed with errno 1213 Created: 2019-03-06  Updated: 2020-12-21  Resolved: 2020-07-14

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

Type: Bug Priority: Critical
Reporter: Stepan Patryshev (Inactive) Assignee: Julius Goryavsky
Resolution: Fixed Votes: 0
Labels: galera, galera_4
Environment:

OS: CentOS Linux release 7.6.1810 (Core).


Attachments: Text File 190306_galera_stdout_laptop.log     Zip Archive 200408_galera.galera_toi_truncate_10.3e.zip     Text File 200408_galera_toi_truncate_stdout_10.3e.log     Zip Archive galera.galera_toi_truncate-innodb.zip    
Issue Links:
Relates
relates to MDEV-18111 Galera 4: run galera test suite Closed

 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.



 Comments   
Comment by Stepan Patryshev (Inactive) [ 2019-03-28 ]

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

Comment by Stepan Patryshev (Inactive) [ 2019-03-28 ]

Closing it since now it's not reproduced.

Comment by Stepan Patryshev (Inactive) [ 2020-04-15 ]

Reopened since it failed on Jenkins, 10.3 ES, but it not failed on BB.

stdio.log:

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;

Server logs.

Comment by Julius Goryavsky [ 2020-07-14 ]

Fixed, https://github.com/MariaDB/server/commit/df1846aeea7f821aec8d15d7cdcae25d2ca3cc8a and https://github.com/MariaDB/server/commit/de5e1711182a3c71223bf9a9dfd170eadbc375e4

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