[MDEV-21524] galera.galera_mdl_race MTR failed: query 'reap' succeeded - should have failed with errno 1213 Created: 2020-01-17  Updated: 2023-04-11

Status: Stalled
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.4.12, 10.2
Fix Version/s: 10.4

Type: Bug Priority: Major
Reporter: Stepan Patryshev (Inactive) Assignee: Julius Goryavsky
Resolution: Unresolved Votes: 0
Labels: Test_disabled, test_disabled_ES
Environment:

kvm-rpm-centos74-amd64-debug


Issue Links:
Blocks
blocks MDEV-17728 Galera 4 test failures Open

 Description   

galera.galera_mdl_race failed on bb.

stdio.log:

10.4.12 983163209d026bfd979b4298053fcbdb373efa9d

galera.galera_mdl_race 'innodb'          w1 [ fail ]
        Test ended at 2020-01-08 18:05:01
 
CURRENT_TEST: galera.galera_mdl_race
mysqltest: At line 58: query 'reap' succeeded - should have failed with errno 1213...
 
The result from queries just before the failure was:
< snip >
connection node_1;
SET AUTOCOMMIT=ON;
START TRANSACTION;
UPDATE t1 SET f2 = 'b' WHERE f1 = 1;
connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
connection node_1a;
LOCK TABLE t2 WRITE;
connection node_1;
SET @@debug_dbug = "d,sync.wsrep_before_mdl_wait";
SELECT * FROM t2;;
connection node_1a;
SET @@debug_dbug = "d,sync.wsrep_after_BF_victim_lock";
connection node_2;
UPDATE t1 SET f2 = 'c' WHERE f1 = 1;
connection node_1a;
SET @@debug_dbug = "";
SET DEBUG_SYNC = "now SIGNAL signal.wsrep_before_mdl_wait";
SET DEBUG_SYNC = "now SIGNAL signal.wsrep_after_BF_victim_lock";
UNLOCK TABLES;
connection node_1;
 
More results from queries before failure can be found in /dev/shm/var/1/log/galera_mdl_race.log
 
 - skipping '/dev/shm/var/1/log/galera.galera_mdl_race-innodb/'
 
Retrying test galera.galera_mdl_race, attempt(2/3)...
 
galera.MDEV-6860 'innodb'                w2 [ skipped ]  Test requires wsrep_on=ON
worker[2] > Restart [mysqld.1 - pid: 9307, winpid: 9307] - using different config file
worker[2] > Restart [mysqld.2 - pid: 9309, winpid: 9309] - using different config file
worker[2] > Restart [mysqld.3 - pid: 9373, winpid: 9373] - using different config file
galera.galera_multi_database 'innodb'    w1 [ pass ]   2055
galera.galera_myisam_autocommit 'innodb' w1 [ pass ]   2050
galera.galera_mdl_race 'innodb'          w1 [ retry-pass ]   2095
 
Retrying test galera.galera_mdl_race, attempt(3/3)...
 
galera.galera_myisam_transactions 'innodb' w1 [ pass ]   2082
galera.galera_nopk_bit 'innodb'          w1 [ pass ]   2095
galera.galera_mdl_race 'innodb'          w1 [ retry-pass ]   2073


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