From 3f619478f796eddbba6e39502fe941b285dd97b1 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 20:00:34 +0200 Subject: Adding upstream version 1:10.11.6. Signed-off-by: Daniel Baumann --- mysql-test/main/bug39022.result | 38 ++++++++++++++++++++++++++++++++++++++ 1 file changed, 38 insertions(+) create mode 100644 mysql-test/main/bug39022.result (limited to 'mysql-test/main/bug39022.result') diff --git a/mysql-test/main/bug39022.result b/mysql-test/main/bug39022.result new file mode 100644 index 00000000..5667c36a --- /dev/null +++ b/mysql-test/main/bug39022.result @@ -0,0 +1,38 @@ +# +# Bug #39022: Mysql randomly crashing in lock_sec_rec_cons_read_sees +# +call mtr.add_suppression("Deadlock found when trying to get lock; try restarting transaction"); +CREATE TABLE t1(a TINYINT NOT NULL,b TINYINT,PRIMARY KEY(b)) ENGINE=innodb; +CREATE TABLE t2(d TINYINT NOT NULL,UNIQUE KEY(d)) ENGINE=innodb; +INSERT INTO t1 VALUES (13,0),(8,1),(9,2),(6,3), +(11,5),(11,6),(7,7),(7,8),(4,9),(6,10),(3,11),(11,12), +(12,13),(7,14); +INSERT INTO t2 VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9),(10), +(11),(12),(13),(14); +connect thread1, localhost, root,,; +connect thread2, localhost, root,,; +connection thread1; +START TRANSACTION; +connection thread2; +REPLACE INTO t2 VALUES (-17); +SELECT d FROM t2,t1 WHERE d=(SELECT MAX(a) FROM t1 WHERE t1.a > t2.d) LOCK IN SHARE MODE; +d +connection thread1; +REPLACE INTO t1(a,b) VALUES (67,20); +connection thread2; +COMMIT; +START TRANSACTION; +REPLACE INTO t1(a,b) VALUES (65,-50); +REPLACE INTO t2 VALUES (-91); +SELECT d FROM t2,t1 WHERE d=(SELECT MAX(a) FROM t1 WHERE t1.a > t2.d) LOCK IN SHARE MODE; +connection thread1; +# should not crash +SELECT d FROM t2,t1 WHERE d=(SELECT MAX(a) FROM t1 WHERE t1.a > t2.d) LOCK IN SHARE MODE; +Got one of the listed errors +connection thread2; +d +disconnect thread2; +connection thread1; +disconnect thread1; +connection default; +DROP TABLE t1,t2; -- cgit v1.2.3