Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Do
-
1.1.7, 1.2.3
-
None
-
MCS on 1UM-1PM/ CentOS7
Description
Killed queries are not removed from the processlist
MariaDB [(none)]> show processlist ;
|
+-----+-------------+-----------------------+------------+---------+------+--------------------------+------------------------------------------------------------------------------------------------------+----------+
|
| Id | User | Host | db | Command | Time | State | Info | Progress |
|
+-----+-------------+-----------------------+------------+---------+------+--------------------------+------------------------------------------------------------------------------------------------------+----------+
|
| 2 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
|
| 1 | system user | | NULL | Daemon | NULL | InnoDB purge coordinator | NULL | 0.000 |
|
| 3 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
|
| 4 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
|
| 5 | system user | | NULL | Daemon | NULL | InnoDB shutdown handler | NULL | 0.000 |
|
| 676 | root | localhost | NULL | Query | 0 | init | show processlist | 0.000 |
|
| 679 | root | localhost | tpcds_1000 | Killed | 5545 | executing | create temporary table infinidb_vtable.$vtable_679 engine = aria as WITH frequent_ss_items AS ( | 0.000 |
|
| 682 | root | localhost | tpcds_1000 | Killed | 5509 | executing | create temporary table infinidb_vtable.$vtable_682 engine = aria as WITH frequent_ss_items AS ( | 0.000 |
|
| 685 | root | localhost | tpcds_1000 | Killed | 5483 | executing | create temporary table infinidb_vtable.$vtable_685 engine = aria as WITH frequent_ss_items AS ( | 0.000 |
|
| 688 | root | localhost | tpcds_1000 | Killed | 5468 | executing | create temporary table infinidb_vtable.$vtable_688 engine = aria as WITH frequent_ss_items AS ( | 0.000 |
|
| 691 | root | localhost | tpcds_1000 | Killed | 5461 | executing | create temporary table infinidb_vtable.$vtable_691 engine = aria as WITH frequent_ss_items AS ( | 0.000 |
|
| 694 | root | localhost | tpcds_1000 | Killed | 5453 | executing | create temporary table infinidb_vtable.$vtable_694 engine = aria as WITH frequent_ss_items AS ( | 0.000 |
|
| 697 | root | localhost | tpcds_1000 | Killed | 5206 | executing | create temporary table infinidb_vtable.$vtable_697 engine = aria as WITH frequent_ss_items AS ( | 0.000 |
|
| 700 | root | localhost | tpcds_1000 | Killed | 5143 | executing | create temporary table infinidb_vtable.$vtable_700 engine = aria as WITH frequent_ss_items AS ( | 0.000 |
|
| 703 | root | localhost | tpcds_1000 | Killed | 5010 | executing | create temporary table infinidb_vtable.$vtable_703 engine = aria as WITH frequent_ss_items AS ( | 0.000 |
|
| 704 | root | localhost | tpcds_1000 | Killed | 4921 | executing | create temporary table infinidb_vtable.$vtable_704 engine = aria as WITH frequent_ss_items AS ( | 0.000 |
|
| 707 | root | localhost | tpcds_1000 | Killed | 4354 | executing | create temporary table infinidb_vtable.$vtable_707 engine = aria as WITH frequent_ss_items AS ( | 0.000 |
|
cd_purchase_ | 0.000 |8.107.244:65290 | tpcds_1000 | Query | 252 | Sending data | select
|
+-----+-------------+-----------------------+------------+---------+------+--------------------------+------------------------------------------------------------------------------------------------------+----------+
|
18 rows in set (0.00 sec)
|
|
now with killed query id on v1.2.3 ; in addition it appears that the client side hangs on
attached trace of ExeMgr
MariaDB [(none)]> show processlist ;
|
+-----+-------------+-----------+--------------------+---------+------+--------------------------+------------------------------------------------------------------------------------------------------+----------+
|
| Id | User | Host | db | Command | Time | State | Info | Progress |
|
+-----+-------------+-----------+--------------------+---------+------+--------------------------+------------------------------------------------------------------------------------------------------+----------+
|
| 1 | system user | | NULL | Daemon | NULL | InnoDB purge coordinator | NULL | 0.000 |
|
| 2 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
|
| 4 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
|
| 3 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
|
| 5 | system user | | NULL | Daemon | NULL | InnoDB shutdown handler | NULL | 0.000 |
|
| 197 | root | localhost | information_schema | Sleep | 4599 | | NULL | 0.000 |
|
| 198 | root | localhost | NULL | Query | 0 | Init | show processlist | 0.000 |
|
| 246 | root | um1:43888 | tpcds_1 | Query | 134 | Sending data | with v1 as( select i_category, i_brand, s_store_name, s_company_name, d_year, d_moy | 0.000 |
|
+-----+-------------+-----------+--------------------+---------+------+--------------------------+------------------------------------------------------------------------------------------------------+----------+
|
8 rows in set (0.000 sec)
|
|
|
MariaDB [(none)]> select QUERY_ID from information_schema.processlist where id=246 into @a ;
|
Query OK, 1 row affected (0.002 sec)
|
|
|
MariaDB [(none)]> kill QUERY ID @a ;
|
Query OK, 0 rows affected (0.000 sec)
|
MariaDB [(none)]> show processlist ;
|
+-----+-------------+-----------+--------------------+---------+------+--------------------------+------------------------------------------------------------------------------------------------------+----------+
|
| Id | User | Host | db | Command | Time | State | Info | Progress |
|
+-----+-------------+-----------+--------------------+---------+------+--------------------------+------------------------------------------------------------------------------------------------------+----------+
|
| 1 | system user | | NULL | Daemon | NULL | InnoDB purge coordinator | NULL | 0.000 |
|
| 2 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
|
| 4 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
|
| 3 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
|
| 5 | system user | | NULL | Daemon | NULL | InnoDB shutdown handler | NULL | 0.000 |
|
| 197 | root | localhost | information_schema | Sleep | 5576 | | NULL | 0.000 |
|
| 246 | root | um1:43888 | tpcds_1 | Killed | 1111 | Sending data | with v1 as( select i_category, i_brand, s_store_name, s_company_name, d_year, d_moy | 0.000 |
|
| 248 | root | localhost | NULL | Query | 0 | Init | show processlist | 0.000 |
|
+-----+-------------+-----------+--------------------+---------+------+--------------------------+------------------------------------------------------------------------------------------------------+----------+
|
8 rows in set (0.000 sec)
|
|
|
|