Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
5.1.67, 5.2.14, 5.3.12, 5.5.39, 10.0.13
Description
--enable_connect_log
|
|
--connect (con1,localhost,root,,)
|
--let $con_id = `SELECT CONNECTION_ID()`
|
|
--echo #
|
--echo # This one returns the expected result
|
--echo #
|
SHOW PROCESSLIST;
|
|
--connection default
|
eval KILL QUERY $con_id;
|
|
--connection con1
|
--echo #
|
--echo # The one after KILL QUERY returns an empty result set (WRONG)
|
--echo #
|
SHOW PROCESSLIST;
|
--echo #
|
--echo # ... and the next one returns the expected result again
|
--echo #
|
SHOW PROCESSLIST;
|
While it is also reproducible on MySQL 5.1-5.6, I'm not filing it upstream, because it's apparently fixed in 5.7 (and hence it has little to no chance to be also fixed in 5.6).
Attachments
Issue Links
- causes
-
MDEV-33292 main.kill_processlist-6619 occasionally fails due to different SHOW PROCESSLIST output
- Closed