[MDEV-18426] Most of the mtr tests in the galera_3nodes suite fail Created: 2019-01-30  Updated: 2019-07-17  Resolved: 2019-01-31

Status: Closed
Project: MariaDB Server
Component/s: Galera
Fix Version/s: 10.4.3, 10.2.23, 10.3.13, 10.1.39

Type: Task Priority: Major
Reporter: Julius Goryavsky Assignee: Julius Goryavsky
Resolution: Fixed Votes: 0
Labels: None


 Description   

Most of the mtr tests in the galera_3nodes suite fail for a variety of reasons with a variety of errors. Some tests simply need to add the missing "connection" lines to the result files, but many of them fail due to substantial errors that require reworking test files. For example:

galera_3nodes.galera_garbd 'innodb'      [ fail ]
        Test ended at 2019-01-29 13:06:57
 
CURRENT_TEST: galera_3nodes.galera_garbd
mysqltest: At line 35: exec of 'pkill --oldest --full garbd.*@OPT.port' failed, error: 15, status: 0, errno: 11
Output from before failure:
Killing garbd ...

or:

galera_3nodes.galera_evs_suspect_timeout 'innodb' [ fail ]  timeout after 900 seconds
        Test ended at 2019-01-29 13:24:53
 
Test case timeout after 900 seconds
 
== /home/panda/mariadb_work/build/mysql-test/var/log/galera_evs_suspect_timeout.log == 
connection node_3;
Suspending node ...
connection node_1;
SET SESSION wsrep_sync_wait = 0;
SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
VARIABLE_VALUE = 2
1
CREATE TABLE t1 (f1 INTEGER);
INSERT INTO t1 VALUES (1);
connection node_2;
SET SESSION wsrep_sync_wait = 0;
SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
VARIABLE_VALUE = 2
1
SET SESSION wsrep_sync_wait = DEFAULT;
SELECT COUNT(*) = 1 FROM t1;
COUNT(*) = 1
1
DROP TABLE t1;
connection node_3;

or (only under debug build of the galera library):

galera_3nodes.galera_ist_gcache_rollover 'innodb' [ fail ]
        Test ended at 2019-01-29 17:43:16
 
CURRENT_TEST: galera_3nodes.galera_ist_gcache_rollover
mysqltest: In included file "./suite/galera/include/galera_unload_provider.inc": 
included from /home/panda/mariadb_work/mysql-test/suite/galera_3nodes/t/galera_ist_gcache_rollover.test at line 35:
At line 7: query 'SET GLOBAL wsrep_provider = 'none'' failed: 2013: Lost connection to MySQL server during query
 
The result from queries just before the failure was:
connection node_1;
connection node_2;
connection node_3;
CREATE TABLE t1 (f1 INTEGER PRIMARY KEY);
INSERT INTO t1 VALUES (01), (02), (03), (04), (05);
connection node_2;
Unloading wsrep provider ...
SET GLOBAL wsrep_provider = 'none';
connection node_3;
Unloading wsrep provider ...
SET GLOBAL wsrep_provider = 'none';


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