Details
-
Bug
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
N/A
-
Not for Release Notes
-
Q4/2025 Server Maintenance
Description
CREATE GLOBAL TEMPORARY TABLE t (c INT) ON COMMIT PRESERVE ROWS; |
INSERT t VALUES (1); |
CREATE OR REPLACE TABLE t (c INT); |
Leads to a thread hang:
MDEV-35915 ES 11.8.3-1 267fc98bf48033db5cf8b3bbffd9d3aea4e9ea8e (Debug, Clang) Build 31/07/2025 |
11.8.3-dbg>SHOW PROCESSLIST;
|
+----+------+-----------+------+---------+------+----------+-----------------------------------+----------+
|
| Id | User | Host | db | Command | Time | State | Info | Progress |
|
+----+------+-----------+------+---------+------+----------+-----------------------------------+----------+
|
| 4 | root | localhost | test | Query | 631 | | CREATE OR REPLACE TABLE t (c INT) | 0.000 |
|
| 6 | root | localhost | test | Query | 0 | starting | SHOW PROCESSLIST | 0.000 |
|
+----+------+-----------+------+---------+------+----------+-----------------------------------+----------+
|
2 rows in set (0.000 sec)
|
Present on ES 11.8 dbg/opt and CS 12.0 dbg/opt in the MDEV-35915 patch v1.
Note: this will also make mariadb-admin shutdown hang significantly (CTRL+c will not work, needs kill -9).
Attachments
Issue Links
- is caused by
-
MDEV-35915 Implement Global temporary tables
-
- In Testing
-
- is duplicated by
-
MDEV-37382 SIGSEGV and UBSAN null-pointer-use in wait_while_table_is_used on CoR GTT
-
- Closed
-
- relates to
-
MDEV-37594 Thread hang on TRUNCATE GTT after server_id change
-
- In Testing
-