Details
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';
|