[MDEV-33138] Galera test case MW-336 unstable Created: 2023-12-29  Updated: 2024-02-06  Resolved: 2024-01-30

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.4
Fix Version/s: 11.3.2, 10.4.34, 10.5.25, 10.6.18, 10.11.8, 11.0.6, 11.1.5, 11.2.4

Type: Bug Priority: Major
Reporter: Jan Lindström Assignee: Julius Goryavsky
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
blocks MDEV-30172 Galera test case cleanup Stalled

 Description   

galera.MW-336 'innodb'                   w3 [ fail ]
10:45:11         Test ended at 2023-12-29 09:45:11
10:45:11 
10:45:11 CURRENT_TEST: galera.MW-336
10:45:11 --- /var/lib/jenkins/workspace/mariadb-10.4-pr-review-release-MTR/mysql-test/suite/galera/r/MW-336.result	2023-12-29 09:32:44.000000000 +0100
10:45:11 +++ /var/lib/jenkins/workspace/mariadb-10.4-pr-review-release-MTR/mysql-test/suite/galera/r/MW-336.reject	2023-12-29 09:45:01.090396650 +0100
10:45:11 @@ -74,9 +74,24 @@
10:45:11  INSERT INTO t1 VALUES (30);
10:45:11  connection node_1;
10:45:11  # Wait until slave threads back to 1
10:45:11 +Timeout in wait_condition.inc for SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count';
10:45:11 +SELECT COUNT(*), 1 as EXPECTED_VALUE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND STATE = 'wsrep applier idle'; show processlist;
10:45:11 +COUNT(*)	EXPECTED_VALUE
10:45:11 +1	1
10:45:11 +Id	User	Host	db	Command	Time	State	Info	Progress
10:45:11 +1	system user		NULL	Sleep	36	wsrep aborter idle	NULL	0.000
10:45:11 +3	system user		NULL	Daemon	NULL	InnoDB purge coordinator	NULL	0.000
10:45:11 +4	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
10:45:11 +5	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
10:45:11 +6	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
10:45:11 +7	system user		NULL	Daemon	NULL	InnoDB shutdown handler	NULL	0.000
10:45:11 +15	root	localhost	test	Sleep	32		NULL	0.000
10:45:11 +16	root	localhost:42512	test	Query	0	Init	show processlist	0.000
10:45:11 +44	system user		NULL	Sleep	30	wsrep applier committed	NULL	0.000
10:45:11 +45	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000
10:45:11  SELECT VARIABLE_VALUE AS EXPECT_1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count';
10:45:11  EXPECT_1
10:45:11 -1
10:45:11 +2
10:45:11  SELECT COUNT(*) FROM t1;
10:45:11  COUNT(*)
10:45:11  30



 Comments   
Comment by Jan Lindström [ 2024-01-05 ]

https://github.com/MariaDB/server/pull/2982

Comment by Julius Goryavsky [ 2024-01-30 ]

Fix merged with head revision: https://github.com/MariaDB/server/commit/49fa5f6b5f573b25d7712859ca404d086f4f5223

Generated at Thu Feb 08 10:36:40 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.