[MDEV-18176] Galera test failure on galera.galera_gtid_slave_sst_rsync Created: 2019-01-09  Updated: 2019-01-15  Resolved: 2019-01-15

Status: Closed
Project: MariaDB Server
Component/s: Galera SST
Affects Version/s: 10.2, 10.3, 10.4
Fix Version/s: 10.4.2, 10.1.38, 10.2.22, 10.3.13

Type: Bug Priority: Major
Reporter: Jan Lindström (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None


 Description   

jan@jan-laptop-asus:~/mysql/10.2-galera/mysql-test$ ./mtr galera_gtid_slave_sst_rsync --repeat=10
Logging: ./mtr  galera_gtid_slave_sst_rsync --repeat=10
vardir: /home/jan/mysql/10.2-galera/mysql-test/var
Checking leftover processes...
 - found old pid 4519 in 'mysqld.1.pid', killing it...
   process did not exist!
 - found old pid 4522 in 'mysqld.2.pid', killing it...
   process did not exist!
 - found old pid 4535 in 'mysqld.3.pid', killing it...
   process did not exist!
Removing old var directory...
Creating var directory '/home/jan/mysql/10.2-galera/mysql-test/var'...
Checking supported features...
MariaDB Version 10.2.22-MariaDB-debug
 - SSL connections supported
 - binaries are debug compiled
Collecting tests...
Installing system database...
 
==============================================================================
 
TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------
 
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
galera.galera_gtid_slave_sst_rsync 'innodb' [ pass ]  23433
galera.galera_gtid_slave_sst_rsync 'innodb' [ fail ]
        Test ended at 2019-01-09 08:45:53
 
CURRENT_TEST: galera.galera_gtid_slave_sst_rsync
mysqltest: At line 39: query 'INSERT INTO t2 VALUES(4,44)' failed: 1146: Table 'test.t2' doesn't exist
 
The result from queries just before the failure was:
< snip >
#Connection 2
connection node_2;
START SLAVE;
#Connection 1
connection node_1;
CREATE TABLE t2 (f1 INTEGER PRIMARY KEY, f2 int unique) ENGINE=InnoDB;
INSERT INTO t2 VALUES(1,11);
INSERT INTO t2 VALUES(2,22);
INSERT INTO t2 VALUES(3,33);
SELECT @@global.gtid_binlog_state;
@@global.gtid_binlog_state
1-1-4
include/save_master_gtid.inc
#Connection 2
connection node_2;
include/sync_with_master_gtid.inc
SELECT @@global.gtid_binlog_state;
@@global.gtid_binlog_state
 
INSERT INTO t2 VALUES(4,44);
 
More results from queries before failure can be found in /home/jan/mysql/10.2-galera/mysql-test/var/log/galera_gtid_slave_sst_rsync.log
 
 - saving '/home/jan/mysql/10.2-galera/mysql-test/var/log/galera.galera_gtid_slave_sst_rsync-innodb/' to '/home/jan/mysql/10.2-galera/mysql-test/var/log/galera.galera_gtid_slave_sst_rsync-innodb/'
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 23.433 of 42 seconds executing testcases
 
Failure: Failed 1/2 tests, 50.00% were successful.
 
Failing test(s): galera.galera_gtid_slave_sst_rsync


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