rpl.rpl_gtid_crash fails sporadically in BB with Timeout wait for SQL thread to catch up with IO thread

rpl.rpl_gtid_crash 'innodb,row'          w4 [ fail ]

        Test ended at 2022-03-08 06:14:34

CURRENT_TEST: rpl.rpl_gtid_crash

mysqltest: At line 367: Timeout wait for SQL thread to catch up with IO thread

The result from queries just before the failure was:

< snip >

call mtr.add_suppression("Unexpected change of master binlog file name in the middle of GTID");

set sql_log_bin= 1;

connection server_1;

SET GLOBAL debug_dbug="+d,inject_error_writing_xid";

BEGIN;

INSERT INTO t1 VALUES (11);

COMMIT;

ERROR HY000: Error writing file 'master-bin' (errno: 28 "No space left on device")

SET GLOBAL debug_dbug="+d,crash_dispatch_command_before";

COMMIT;

Got one of the listed errors

SELECT @@GLOBAL.server_id;

@@GLOBAL.server_id

3

SELECT * from t1 WHERE a > 10 ORDER BY a;

a

gtid_check

Binlog pos ok

# Wait 30 seconds for SQL thread to catch up with IO thread

connection server_2;

rpl.rpl_gtid_crash 'innodb,row'          w4 [ fail ]

        Test ended at 2022-11-07 19:05:14

CURRENT_TEST: rpl.rpl_gtid_crash

mysqltest: At line 464: Timeout wait for SQL thread to catch up with IO thread

The result from queries just before the failure was:

< snip >

BEGIN;

INSERT INTO t1 VALUES (21);

COMMIT;

ERROR HY000: Error writing file 'master-bin' (errno: 28 "No space left on device")

SET GLOBAL debug_dbug="+d,crash_dispatch_command_before";

COMMIT;

Got one of the listed errors

SELECT @@GLOBAL.server_id;

@@GLOBAL.server_id

1

SELECT * from t1 WHERE a > 10 ORDER BY a;

a

13

14

gtid_check

Binlog pos ok

gtid_check

Current pos ok

# Wait 30 seconds for SQL thread to catch up with IO thread

connection server_2;