binlog.binlog_xa_prepared_disconnect 'innodb,mix' [ pass ]   4497

connect  pause_purge,localhost,root;

START TRANSACTION WITH CONSISTENT SNAPSHOT;

connection default;

CREATE TABLE t_30010 (pk int PRIMARY KEY, sk INT UNIQUE) ENGINE=InnoDB;

INSERT INTO t_30010 VALUES (10, 100);

connect  con1,localhost,root;

BEGIN;

SELECT * FROM t_30010 WHERE sk = 100 FOR UPDATE;

pk	sk

10	100

connect  con2,localhost,root;

SET DEBUG_SYNC="lock_wait_suspend_thread_enter SIGNAL insert_wait_started";

INSERT INTO t_30010 VALUES (5, 100) # trx 1;

connect  con3,localhost,root;

SET TRANSACTION ISOLATION LEVEL READ COMMITTED;

SET DEBUG_SYNC="now WAIT_FOR insert_wait_started";

Warnings:

Warning	1639	debug sync point wait timed out

SET DEBUG_SYNC="lock_wait_suspend_thread_enter SIGNAL delete_started_waiting";

BEGIN;

UPDATE t_30010 SET sk = 200 WHERE sk = 100; # trx 2;

connection con1;

SET DEBUG_SYNC="now WAIT_FOR delete_started_waiting";

Warnings:

Warning	1639	debug sync point wait timed out

DELETE FROM t_30010 WHERE sk=100;

COMMIT;

disconnect con1;

connection con2;

binlog.innodb_rc_insert_before_delete 'innodb,mix' [ fail ]

        Test ended at 2023-01-28 16:51:56