[MDEV-17060] Test failure on galera.galera_var_slave_threads - Jira

XML

Word

Printable

Details

Type: Task
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Fix Version/s: 10.1.36, 10.2.18, 10.3.10
Component/s: Galera
Labels:
None

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(*)

+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(*)

@@ -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

mysqltest: Result length mismatch

Attachments

Issue Links

blocks

MDEV-13549 Galera 3 test failures

Closed

Activity

People

Assignee:: Jan Lindström (Inactive)

Reporter:: Jan Lindström (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2018-08-24 08:54

Updated:: 2018-09-09 15:59

Resolved:: 2018-09-09 15:59

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.