mirror of
https://github.com/MariaDB/server.git
synced 2025-11-04 12:56:14 +01:00
43 lines
1.4 KiB
Text
43 lines
1.4 KiB
Text
#
|
|
# MDEV-6619 SHOW PROCESSLIST returns empty result set after KILL QUERY
|
|
#
|
|
--source include/not_embedded.inc
|
|
--source include/have_debug_sync.inc
|
|
|
|
--disable_ps_protocol
|
|
# Ensure no lingering connections from an earlier test run, which can very
|
|
# rarely still be visible in SHOW PROCESSLIST here.
|
|
--let $wait_condition= SELECT COUNT(*) = 1 from information_schema.processlist
|
|
--source include/wait_condition.inc
|
|
|
|
--connect (con1,localhost,root,,)
|
|
--let $con_id = `SELECT CONNECTION_ID()`
|
|
|
|
let $wait_condition=select command = 'sleep' from information_schema.processlist where id != $con_id;
|
|
source include/wait_condition.inc;
|
|
|
|
--replace_result Execute Query
|
|
--replace_column 1 # 3 # 6 # 7 #
|
|
SHOW PROCESSLIST;
|
|
SET DEBUG_SYNC='before_execute_sql_command SIGNAL ready WAIT_FOR go';
|
|
send SHOW PROCESSLIST;
|
|
--connection default
|
|
# We must wait for the SHOW PROCESSLIST query to have started before sending
|
|
# the kill. Otherwise, the KILL may be lost since it is reset at the start of
|
|
# query execution.
|
|
SET DEBUG_SYNC='now WAIT_FOR ready';
|
|
--replace_result $con_id con_id
|
|
eval KILL QUERY $con_id;
|
|
SET DEBUG_SYNC='now SIGNAL go';
|
|
--connection con1
|
|
--error ER_QUERY_INTERRUPTED
|
|
reap;
|
|
SET DEBUG_SYNC='reset';
|
|
|
|
# Wait until default connection has reset query string
|
|
let $wait_condition=select command = 'sleep' from information_schema.processlist where id != $con_id;
|
|
--source include/wait_condition.inc
|
|
|
|
--replace_result Execute Query
|
|
--replace_column 1 # 3 # 6 # 7 #
|
|
SHOW PROCESSLIST;
|