Byeongcheol-Kim commented on issue #24122: URL: https://github.com/apache/shardingsphere/issues/24122#issuecomment-1432456273
I found a related issue. If it's a connection has no executing statement, it will show up in show processlist, but not be deleted with kill . Proxy 5.2.1 version. ``` mysql> SHOW PROCESSLIST; +----------------------------------+----------------+---------------+---------+---------+-------+-------+------+ | Id | User | Host | db | Command | Time | State | Info | +----------------------------------+----------------+---------------+---------+---------+-------+-------+------+ | 89caef357374e2b3424656ff66bbcdce | order | ************* | order | Sleep | 41105 | | | | de3959f21dfda272124773a0f1da1c2a | order | ************* | order | Sleep | 38999 | | | | 8ba3301cfe24a6ccfe33e31dd747775f | order | ************* | order | Sleep | 38988 | | | | 3f698bd7e74a7f202ff15045feb39b0d | order | ************* | order | Sleep | 38985 | | | | 29b36a2030b0a032d9ad40356e27946b | order | ************* | order | Sleep | 907 | | | | f198390c7b5dc960909eed33bfb8d89a | order | ************* | order | Sleep | 40789 | | | | 2c67ed1e33a618581c9d5d98620327c9 | order | ************* | order | Sleep | 40789 | | | | d8a6f28e4696e96af8e257fe8bf34b19 | order | ************* | order | Sleep | 38994 | | | | ff37cf2217643c13c7948807369919e8 | order | ************* | order | Sleep | 38988 | | | | c1ef33c37d64b8e9848b5273da793630 | order | ************* | order | Sleep | 38999 | | | | d2f6b6d1ded73b9d1129e21bf744943b | order | ************* | order | Sleep | 38988 | | | | 9eee71c95906f5e5e1856a2828911b36 | order | ************* | order | Sleep | 38988 | | | | 8299fdf04c2b899def20a2e0abaa6b48 | order | ************* | order | Sleep | 40789 | | | +----------------------------------+----------------+---------------+---------+---------+-------+-------+------+ 13 rows in set (0.06 sec) mysql> KILL 89caef357374e2b3424656ff66bbcdce; Query OK, 0 rows affected (0.02 sec) mysql> KILL 89caef357374e2b3424656ff66bbcdce; Query OK, 0 rows affected (0.02 sec) mysql> SHOW PROCESSLIST; +----------------------------------+----------------+---------------+---------+---------+-------+-------+------+ | Id | User | Host | db | Command | Time | State | Info | +----------------------------------+----------------+---------------+---------+---------+-------+-------+------+ | 89caef357374e2b3424656ff66bbcdce | order | ************* | order | Sleep | 41388 | | | | de3959f21dfda272124773a0f1da1c2a | order | ************* | order | Sleep | 39282 | | | | 8ba3301cfe24a6ccfe33e31dd747775f | order | ************* | order | Sleep | 39271 | | | | 3f698bd7e74a7f202ff15045feb39b0d | order | ************* | order | Sleep | 39268 | | | | 29b36a2030b0a032d9ad40356e27946b | order | ************* | order | Sleep | 1190 | | | | f198390c7b5dc960909eed33bfb8d89a | order | ************* | order | Sleep | 41072 | | | | 2c67ed1e33a618581c9d5d98620327c9 | order | ************* | order | Sleep | 41072 | | | | d8a6f28e4696e96af8e257fe8bf34b19 | order | ************* | order | Sleep | 39277 | | | | ff37cf2217643c13c7948807369919e8 | order | ************* | order | Sleep | 39271 | | | | c1ef33c37d64b8e9848b5273da793630 | order | ************* | order | Sleep | 39282 | | | | d2f6b6d1ded73b9d1129e21bf744943b | order | ************* | order | Sleep | 39271 | | | | 9eee71c95906f5e5e1856a2828911b36 | order | ************* | order | Sleep | 39271 | | | | 8299fdf04c2b899def20a2e0abaa6b48 | order | ************* | order | Sleep | 41072 | | | +----------------------------------+----------------+---------------+---------+---------+-------+-------+------+ ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
