mysql-wsrep#198 test hangs

galera.mysql-wsrep#198                   w1 [ fail ]

        Test ended at 2025-06-03 00:34:51

CURRENT_TEST: galera.mysql-wsrep#198

mysqltest: At line 28: query 'INSERT INTO t2 VALUES (1)' failed: ER_LOCK_WAIT_TIMEOUT (1205): Lock wait timeout exceeded; try restarting transaction

The result from queries just before the failure was:

< snip >

LOCK TABLE t2 WRITE;

connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2;

connection node_2a;

OPTIMIZE TABLE t1,t2;;

connect node_2b, 127.0.0.1, root, , test, $NODE_MYPORT_2;

connection node_2b;

REPAIR TABLE t1,t2;;

connection node_2;

SET SESSION wsrep_sync_wait = 0;

Timeout in wait_condition.inc for SELECT COUNT(*) BETWEEN 1 AND 2 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE LIKE 'Waiting for table metadata lock%' OR STATE LIKE 'Waiting to execute in isolation%';

SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;

ID	USER	HOST	DB	COMMAND	TIME	STATE	INFO	TIME_MS	STAGE	MAX_STAGE	PROGRESS	MEMORY_USED	MAX_MEMORY_USED	EXAMINED_ROWS	QUERY_ID	INFO_BINARY	TID

13	root	localhost:52524	test	Sleep	30		NULL	30195.324	0	0	0.000	90624	91640	0	41	NULL	87065

12	root	localhost:52522	test	Sleep	30		NULL	30195.674	0	0	0.000	90624	92352	0	40	NULL	87064

11	root	localhost:52516	test	Query	0	Filling schema table	SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST	0.236	0	0	0.000	159024	293152	0	343	SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST	86809

1	system user		NULL	Sleep	35	wsrep aborter idle	NULL	35224.866	0	0	0.000	66856	66856	0	0	NULL	86431

2	system user		NULL	Sleep	30	After apply log event	NULL	30200.365	0	0	0.000	74208	83344	0	37	NULL	86432

Killing server ...

connection node_1;

INSERT INTO t2 VALUES (1);