[MDEV-17060] Test failure on galera.galera_var_slave_threads Created: 2018-08-24  Updated: 2018-09-09  Resolved: 2018-09-09

Status: Closed
Project: MariaDB Server
Component/s: Galera
Fix Version/s: 10.1.36, 10.2.18, 10.3.10

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

Issue Links:
Blocks
blocks MDEV-13549 Galera 3 test failures Closed

 Description    

galera.galera_var_slave_threads 'innodb' w3 [ fail ]
 
        Test ended at 2018-08-24 01:33:13
 
 
 
CURRENT_TEST: galera.galera_var_slave_threads
 
--- /usr/share/mysql-test/suite/galera/r/galera_var_slave_threads.result	2018-08-24 00:47:16.000000000 +0000
 
+++ /dev/shm/var/3/log/galera_var_slave_threads.reject	2018-08-24 01:33:13.213826500 +0000
 
@@ -20,6 +20,80 @@
 
 connection node_1;
 
 INSERT INTO t1 VALUES (1);
 
 connection node_2;
 
+Timeout in wait_condition.inc for SELECT COUNT(*) = @@wsrep_slave_threads + 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND (STATE IS NULL OR STATE NOT LIKE 'InnoDB%');
 
+Id	User	Host	db	Command	Time	State	Info	Progress
 
+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
 
+124	system user		NULL	Sleep	55	WSREP aborter idle	NULL	0.000
 
+125	system user		NULL	Sleep	30	Committed 640	NULL	0.000
 
+164	root	localhost:41185	test	Query	0	Init	show full processlist	0.000
 
+165	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+167	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+166	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+168	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+227	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+226	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+170	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+171	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+172	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+173	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+174	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+176	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+177	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+178	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+179	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+175	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+180	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+181	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+182	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+183	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+184	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+185	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+186	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+187	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+188	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+189	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+190	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+191	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+192	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+193	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+194	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+196	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+195	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+197	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+198	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+199	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+200	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+201	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+203	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+202	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+205	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+204	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+206	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+208	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+210	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+209	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+207	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+211	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+212	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+213	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+218	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+215	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+214	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+216	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+219	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+217	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+220	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+221	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+222	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+223	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+225	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+224	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+169	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+228	system user		NULL	Sleep	30	NULL	NULL	0.000
 
 SET GLOBAL wsrep_slave_threads = 1;
 
 connection node_1;
 
 INSERT INTO t2 VALUES (DEFAULT);
 
@@ -90,6 +164,17 @@
 
 SELECT COUNT(*) FROM t2;
 
 COUNT(*)
 
 64
 
+Timeout in wait_condition.inc for SELECT COUNT(*) = @@wsrep_slave_threads + 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND (STATE IS NULL OR STATE NOT LIKE 'InnoDB%')
 
+Id	User	Host	db	Command	Time	State	Info	Progress
 
+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
 
+124	system user		NULL	Sleep	85	WSREP aborter idle	NULL	0.000
 
+164	root	localhost:41185	test	Query	0	Init	show full processlist	0.000
 
+225	system user		NULL	Sleep	30	Committed 704	NULL	0.000
 
+228	system user		NULL	Sleep	60	NULL	NULL	0.000
 
 SELECT COUNT(*) FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND STATE LIKE '%wsrep aborter%';
 
 COUNT(*)
 
 1
 
@@ -103,6 +188,20 @@
 
 CREATE TABLE t1 (i INT AUTO_INCREMENT PRIMARY KEY) ENGINE=INNODB;
 
 connection node_2;
 
 SET GLOBAL wsrep_slave_threads = 4;
 
+Timeout in wait_condition.inc for SELECT COUNT(*) = @@wsrep_slave_threads + 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND (STATE IS NULL OR STATE NOT LIKE 'InnoDB%')
 
+Id	User	Host	db	Command	Time	State	Info	Progress
 
+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
 
+124	system user		NULL	Sleep	116	WSREP aborter idle	NULL	0.000
 
+164	root	localhost:41185	test	Query	0	Init	show full processlist	0.000
 
+225	system user		NULL	Sleep	60	Committed 704	NULL	0.000
 
+228	system user		NULL	Sleep	30	Committed 707	NULL	0.000
 
+229	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+230	system user		NULL	Sleep	30	NULL	NULL	0.000
 
+231	system user		NULL	Sleep	30	NULL	NULL	0.000
 
 SET GLOBAL wsrep_slave_threads = 1;
 
 connection node_1;
 
 INSERT INTO t1 VALUES (DEFAULT);
 
@@ -112,6 +211,17 @@
 
 connection node_2;
 
 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'test/t%';
 
 NAME
 
+Timeout in wait_condition.inc for SELECT COUNT(*) = 2 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND (STATE IS NULL OR STATE NOT LIKE 'InnoDB%')
 
+Id	User	Host	db	Command	Time	State	Info	Progress
 
+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
 
+124	system user		NULL	Sleep	146	WSREP aborter idle	NULL	0.000
 
+164	root	localhost:41185	test	Query	0	Init	show full processlist	0.000
 
+230	system user		NULL	Sleep	30	Committed 711	NULL	0.000
 
+231	system user		NULL	Sleep	60	NULL	NULL	0.000
 
 SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND STATE LIKE '%wsrep aborter%';
 
 COUNT(*) = 1
 
 1
 
 
 
mysqltest: Result length mismatch


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