[MDEV-32651] Lost Debug_sync signal in rpl_sql_thd_start_errno_cleared Created: 2023-11-01  Updated: 2023-11-13  Resolved: 2023-11-01

Status: Closed
Project: MariaDB Server
Component/s: Replication, Tests
Affects Version/s: 10.4, 10.5, 10.6, 10.10, 10.11, 11.0, 11.1
Fix Version/s: 10.4.33, 10.5.24, 10.6.17, 10.11.7, 11.0.5, 11.1.4

Type: Bug Priority: Major
Reporter: Brandon Nesterenko Assignee: Brandon Nesterenko
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
is caused by MDEV-31177 SHOW SLAVE STATUS Last_SQL_Errno Race... Closed
Relates
relates to MDEV-27850 MTR tests can hang due to DEBUG_SYNC ... Stalled

 Description   

The test rpl.rpl_sql_thd_start_errno_cleared can lose a debug_sync signal, as there is a RESET immediately following a SIGNAL:

set debug_sync= "now signal sql_thread_continue";
 
 
 
set @@global.debug_dbug= @saved_dbug;
 
set debug_sync= "RESET";

When the signal is lost, the sql_thread is stuck in a WAIT_FOR clause until it times out, resulting in long test times (albeit still successful).



 Comments   
Comment by Brandon Nesterenko [ 2023-11-01 ]

Pushed into 10.4 as c341743e83c

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