[MDEV-32651] Lost Debug_sync signal in rpl_sql_thd_start_errno_cleared - Jira

XML

Word

Printable

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.4(EOL), 10.5(EOL), 10.6, 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL)
Fix Version/s: 10.4.33, 10.5.24, 10.6.17, 10.11.7, 11.0.5, 11.1.4
Component/s: Replication, Tests, MTR
Labels:
None

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).

is caused by

MDEV-31177 SHOW SLAVE STATUS Last_SQL_Errno Race Condition on Errored Slave Restart

relates to

MDEV-27850 MTR tests can hang due to DEBUG_SYNC race condition

Estimated:

Not Specified

Remaining:

Logged:

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