galera.MW-336 'innodb'                   w2 [ fail ]

        Test ended at 2020-02-05 09:58:15

CURRENT_TEST: galera.MW-336

--- /usr/share/mysql/mysql-test/suite/galera/r/MW-336.result	2020-02-05 07:41:16.000000000 -0500

+++ /dev/shm/var/2/log/MW-336.reject	2020-02-05 09:58:15.531334676 -0500

@@ -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	37	wsrep aborter idle	NULL	0.000

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

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

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

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

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

+15	root	localhost	test	Sleep	32		NULL	0.000

+16	root	localhost:54312	test	Query	0	Init	show processlist	0.000

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

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

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

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

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

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

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

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

+25	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

+26	system user		NULL	Sleep	30	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

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

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

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

+31	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	67	wsrep aborter idle	NULL	0.000

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

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

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

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

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

+15	root	localhost	test	Sleep	63		NULL	0.000

+16	root	localhost:54312	test	Query	0	Init	show processlist	0.000

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

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

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

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

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

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

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

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

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

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

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

 connection node_2;

 INSERT INTO t1 VALUES (11);

 INSERT INTO t1 VALUES (12);

mysqltest: Result length mismatch

 - saving '/dev/shm/var/2/log/galera.MW-336-innodb/' to '/dev/shm/var/log/galera.MW-336-innodb/'

Retrying test galera.MW-336, attempt(2/3)...