mirror of
https://github.com/MariaDB/server.git
synced 2025-02-22 13:23:07 +01:00
43745b7e17
Use suspend thread syncpoint instead of include/wait_condition.inc to
make sure DELETE created waiting lock before the next UPDATE begins
locking.
This is backport of commit 0fa4dd0747
from 10.6.
32 lines
746 B
Text
32 lines
746 B
Text
--source include/have_innodb.inc
|
|
--source include/count_sessions.inc
|
|
--source include/have_debug.inc
|
|
--source include/have_debug_sync.inc
|
|
|
|
CREATE TABLE t(a INT PRIMARY KEY) ENGINE=InnoDB;
|
|
INSERT INTO t VALUES (3);
|
|
|
|
BEGIN;
|
|
UPDATE t SET a = 2;
|
|
|
|
connect con1,localhost,root;
|
|
SET DEBUG_SYNC="lock_wait_start SIGNAL del_locked";
|
|
send DELETE FROM t;
|
|
|
|
connection default;
|
|
SET DEBUG_SYNC="now WAIT_FOR del_locked";
|
|
UPDATE t SET a = 1;
|
|
COMMIT;
|
|
|
|
connection con1;
|
|
error ER_LOCK_DEADLOCK;
|
|
reap;
|
|
disconnect con1;
|
|
|
|
connection default;
|
|
--echo # The above DELETE must delete all the rows in the table, so the
|
|
--echo # following SELECT must show 0 rows.
|
|
SELECT count(*) FROM t;
|
|
SET DEBUG_SYNC="reset";
|
|
DROP TABLE t;
|
|
--source include/wait_until_count_sessions.inc
|