Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
-
None
Description
The recently added by MDEV-30010 test turns out to be unstable.
It hangs
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
|
|
when is preceded by another test like above.