./mtr --suite galera --force --big-test --max-test-fail=0 --parallel=auto --timer --timestamp --timediff

191026 15:29:56 +2.024 galera.MW-336 'innodb'                   w4 [ fail ]

        Test ended at 2019-10-26 15:29:56

CURRENT_TEST: galera.MW-336

--- /home/stepan/mariadb/10.4/git/mysql-test/suite/galera/r/MW-336.result	2019-10-13 09:12:21.392670633 +0300

+++ /home/stepan/mariadb/10.4/git/mysql-test/suite/galera/r/MW-336.reject	2019-10-26 15:29:55.931500577 +0300

@@ -12,6 +12,40 @@

 # Set slave threads to 10 step 2

 SET GLOBAL wsrep_slave_threads = 20;

 # Set slave threads to 20

+Timeout in wait_condition.inc for SELECT VARIABLE_VALUE = 20 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count';

+SELECT COUNT(*), 20 as EXPECTED_VALUE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND STATE = 'wsrep applier idle'; show processlist;

+COUNT(*)	EXPECTED_VALUE

+21	20

+Id	User	Host	db	Command	Time	State	Info	Progress

+1	system user		NULL	Sleep	38	wsrep aborter idle	NULL	0.000

+3	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000

+4	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000

+5	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000

+6	system user		NULL	Daemon	NULL	InnoDB purge coordinator	NULL	0.000

+7	system user		NULL	Daemon	NULL	InnoDB shutdown handler	NULL	0.000

+16	root	localhost	test	Sleep	33		NULL	0.000

+17	root	localhost:51250	test	Query	0	Init	show processlist	0.000

+18	system user		NULL	Sleep	31	wsrep applier idle	NULL	0.000

+19	system user		NULL	Sleep	31	wsrep applier idle	NULL	0.000

+20	system user		NULL	Sleep	31	wsrep applier idle	NULL	0.000

+21	system user		NULL	Sleep	31	wsrep applier idle	NULL	0.000

+22	system user		NULL	Sleep	31	wsrep applier idle	NULL	0.000

+23	system user		NULL	Sleep	31	wsrep applier idle	NULL	0.000

+24	system user		NULL	Sleep	31	wsrep applier idle	NULL	0.000

+25	system user		NULL	Sleep	31	wsrep applier idle	NULL	0.000

+26	system user		NULL	Sleep	31	wsrep applier idle	NULL	0.000

+27	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000

+28	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000

+29	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000

+30	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000

+31	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000

+32	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000

+33	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000

+34	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000

+35	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000

+36	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000

+37	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000

+38	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000

 SET GLOBAL wsrep_slave_threads = 1;

 connection node_2;

 INSERT INTO t1 VALUES (1);

@@ -30,6 +64,30 @@

 COUNT(*)

 11

 # Set slave threads to 10 step 3

+Timeout in wait_condition.inc for SELECT VARIABLE_VALUE = 10 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count';

+SELECT COUNT(*), 10 as EXPECTED_VALUE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND STATE = 'wsrep applier idle'; show processlist;

+COUNT(*)	EXPECTED_VALUE

+11	10

+Id	User	Host	db	Command	Time	State	Info	Progress

+1	system user		NULL	Sleep	70	wsrep aborter idle	NULL	0.000

+3	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000

+4	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000

+5	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000

+6	system user		NULL	Daemon	NULL	InnoDB purge coordinator	NULL	0.000

+7	system user		NULL	Daemon	NULL	InnoDB shutdown handler	NULL	0.000

+16	root	localhost	test	Sleep	64		NULL	0.000

+17	root	localhost:51250	test	Query	0	Init	show processlist	0.000

+28	system user		NULL	Sleep	62	wsrep applier idle	NULL	0.000

+29	system user		NULL	Sleep	62	wsrep applier idle	NULL	0.000

+30	system user		NULL	Sleep	62	wsrep applier idle	NULL	0.000

+31	system user		NULL	Sleep	62	wsrep applier idle	NULL	0.000

+32	system user		NULL	Sleep	62	wsrep applier idle	NULL	0.000

+33	system user		NULL	Sleep	62	wsrep applier idle	NULL	0.000

+34	system user		NULL	Sleep	62	wsrep applier idle	NULL	0.000

+35	system user		NULL	Sleep	62	wsrep applier idle	NULL	0.000

+36	system user		NULL	Sleep	62	wsrep applier idle	NULL	0.000

+37	system user		NULL	Sleep	62	wsrep applier idle	NULL	0.000

+38	system user		NULL	Sleep	62	wsrep applier idle	NULL	0.000

 connection node_2;

 INSERT INTO t1 VALUES (11);

 INSERT INTO t1 VALUES (12);

mysqltest: Result length mismatch