[MDEV-32781] galera_bf_lock_wait test failed Created: 2023-11-11  Updated: 2023-12-12  Resolved: 2023-12-05

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.4.31, 10.5.22
Fix Version/s: 10.4.33, 10.5.24, 10.6.17, 10.11.7, 11.0.5, 11.1.4, 11.2.3

Type: Bug Priority: Critical
Reporter: Julius Goryavsky Assignee: Julius Goryavsky
Resolution: Fixed Votes: 1
Labels: None

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

 Description   

galera.galera_bf_lock_wait test failed with

mysqltest: At line 65: command "grep 'BF lock wait long' $MYSQLTEST_VARDIR/log/mysqld.*.err" succeeded - should have failed with errno 1...

More complete log:

galera.galera_bf_lock_wait 'innodb'      [ fail ]
        Test ended at 2023-11-10 21:24:54
 
CURRENT_TEST: galera.galera_bf_lock_wait
mysqltest: At line 65: command "grep 'BF lock wait long' $MYSQLTEST_VARDIR/log/mysqld.*.err" succeeded - should have failed with errno 1...
 
The result from queries just before the failure was:
< snip >
update t1 set b=connection_id() where a=1;
commit;
SET current_num = current_num + 1;
END WHILE;
END|
connection node_2;
connect node_1_p1, 127.0.0.1, root, , test, $NODE_MYPORT_1;
SET SESSION wsrep_sync_wait=0;
call p1(1000);
connect node_1_p2, 127.0.0.1, root, , test, $NODE_MYPORT_1;
SET SESSION wsrep_sync_wait=0;
call p1(1000);
connect node_2_p1, 127.0.0.1, root, , test, $NODE_MYPORT_2;
SET SESSION wsrep_sync_wait=0;
call p1(1000);
connect node_2_p2, 127.0.0.1, root, , test, $NODE_MYPORT_2;
SET SESSION wsrep_sync_wait=0;
call p1(1000);
connection node_1;
checking error log for 'BF lock wait long' message for 10 times every 10 seconds ...



 Comments   
Comment by Daniele Sciascia [ 2023-11-20 ]

A pull request has been submitted and is ready for review.

Comment by Julius Goryavsky [ 2023-12-05 ]

The fix has been added to the main branch: https://github.com/MariaDB/server/commit/5c4c1844bf8b60dcee9fdeacd4a39705d40a4515

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