Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Not a Bug
-
10.5, 10.8
Description
The following:
INSERT INTO t VALUES (1); |
CREATE TABLE parent (a INT KEY,b INT); |
CREATE TABLE t (a INT KEY,FOREIGN KEY(a) REFERENCES parent (a) ON DELETE CASCADE) COLLATE=BIG5_nopad_bin; |
SET GLOBAL innodb_status_output=1; |
SELECT SLEEP (1); |
When replayed using the C connector produces the following:
10.8.1 0c5d1342ae6b5ab3256848be7a83e5c3b1f21566 (Debug) |
MariaDB [(none)]> show processlist;
|
+----+------+-----------+------+---------+------+------------+------------------+----------+
|
| Id | User | Host | db | Command | Time | State | Info | Progress |
|
+----+------+-----------+------+---------+------+------------+------------------+----------+
|
| 7 | root | localhost | test | Query | 0 | User sleep | SELECT SLEEP (1) | 0.000 |
|
| 8 | root | localhost | NULL | Query | 0 | starting | show processlist | 0.000 |
|
+----+------+-----------+------+---------+------+------------+------------------+----------+
|
2 rows in set (0.000 sec)
|
i.e. the sleep hangs, seemingly perpetually, and always with 0 time (using single threaded replay). Killing the query (KILL 7;) reports "OK" but the state remains unchanged.