mirror of
https://github.com/MariaDB/server.git
synced 2025-07-20 02:08:15 +02:00

Some tests like main.ssl_timeout and main.wait_timeout may abort
connections. If main.aborted_clients follows such tests it may
observe unstable value of aborted_clients status variable.
FLUSH STATUS was issued to make aborted_clients value reproducible.
However after 775cba4d0f
FLUSH STATUS doesn't reset global status.
Fixed by using FLUSH GLOBAL STATUS.
Regression after "MDEV-33145 - Add FLUSH GLOBAL STATUS".
16 lines
461 B
Text
16 lines
461 B
Text
FLUSH GLOBAL STATUS;
|
|
connect con1,localhost,root,,;
|
|
disconnect con1;
|
|
connection default;
|
|
SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME='aborted_clients';
|
|
VARIABLE_VALUE
|
|
0
|
|
connect con2,localhost,root,,;
|
|
KILL CONNECTION_ID();
|
|
ERROR 70100: Connection was killed
|
|
disconnect con2;
|
|
connection default;
|
|
SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME='aborted_clients';
|
|
VARIABLE_VALUE
|
|
1
|
|
FLUSH STATUS;
|