[#MCOL-2189] Killed queries are not removed from the processlist

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)

[MCOL-2189] Killed queries are not removed from the processlist Created: 2019-02-22 Updated: 2023-03-06 Resolved: 2023-03-06
Status:	Closed
Project:	MariaDB ColumnStore
Component/s:	ExeMgr
Affects Version/s:	1.1.7, 1.2.3
Fix Version/s:	Icebox

[MCOL-2189] Killed queries are not removed from the processlist Created: 2019-02-22 Updated: 2023-03-06 Resolved: 2023-03-06