Details
-
Bug
-
Status: Stalled (View Workflow)
-
Critical
-
Resolution: Unresolved
-
10.6.4, 10.3.38, 10.6.12
-
None
Description
One of our customers migrated from MySQL to MariaDB 10.6.4 and their INSERT-SELECT query having many case/when/if conditions running forever.
Locally on the empty tables, can reproduce this situation, queries are getting stuck with "Init" and "Closing tables" state.
MariaDB [(none)]> show processlist;
|
+------+-----------------+-----------+------+---------+-------+------------------------+------------------------------------------------------------------------------------------------------+----------+
|
| Id | User | Host | db | Command | Time | State | Info | Progress |
|
+------+-----------------+-----------+------+---------+-------+------------------------+------------------------------------------------------------------------------------------------------+----------+
|
.....
|
| 255 | root | localhost | mcc | Query | 9511 | closing tables | insert into mcc.testoutplanreport_p1
|
(
|
select period,plant_code,rawline,finishedgood,status,w1status | 0.000 |
|
| 288 | root | localhost | NULL | Query | 8881 | init | select period,plant_code,rawline,finishedgood,status,w1status,DELQ,DEL_DSI,DELO
|
,WW1P1,WW1P1_DSI,WW1 | 0.000 |
|
.....
|
