Confusing results using PROXYSQL PAUSE/RESUME #5170
Description
Description
I'm getting odd results when using the command PROXYSQL PAUSE; and PROXYSQL RESUME;, and this is reproducable on my deployment.
ProxySQL Version
The version I am using is 3.0.2-30-gafb1865
[ec2-user@proxysql-labs105 ~]$ proxysql --version
2025-10-20 15:31:27 [INFO] Using OpenSSL version: OpenSSL 3.2.2 4 Jun 2024
ProxySQL version 3.0.2-30-gafb1865, codename Truls
OS Version
This is running on Amazon Linux 2023
[ec2-user@proxysql-labs105 ~]$ cat /etc/system-release
Amazon Linux release 2023.9.20251014 (Amazon Linux)
Reproduction Steps
When trying to run the PROXYSQL PAUSE; and PROXYSQL RESUME; commands, the following sequence of events are experienced. It seems to sometimes work, and other times try to run the previous command rather than the one entered. Occasionally, it does work though.
The last step in the sequence below, show processlist; never completed and just froze. I was able to log in through another session, and successfully execute show processlist;
[root@proxysql-labs105 ~]# mysql --login-path=proxy_admin
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 130795
Server version: 8.0.11 (ProxySQL Admin Module)
Copyright (c) 2000, 2025, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> PROXYSQL status;
ERROR 1045 (28000): ProxySQL Admin Error: near "PROXYSQL": syntax error
mysql> PROXYSQL PAUSE;
Query OK, 0 rows affected (6.31 sec)
mysql> PROXYSQL RESUME;
Query OK, 0 rows affected (0.00 sec)
mysql> PROXYSQL RESUME;
Query OK, 0 rows affected (0.00 sec)
mysql> show processlist;
Query OK, 0 rows affected (0.00 sec)
mysql> PROXYSQL PAUSE;
ERROR 1045 (28000): ProxySQL Admin Error: ProxySQL MySQL module is not paused, impossible to resume
mysql> PROXYSQL RESTART;
ERROR 1045 (28000): ProxySQL Admin Error: ProxySQL MySQL module is not paused, impossible to resume
mysql> show processlist;
+-----------+----------------------+----+-----------+-------------------+---------+------+
| SessionID | user | db | hostgroup | command | time_ms | info |
+-----------+----------------------+----+-----------+-------------------+---------+------+
| 131387 | unauthenticated user | NULL | -1 | Connecting client | 17 | NULL |
| 131388 | unauthenticated user | NULL | -1 | Connecting client | 14 | NULL |
| 131389 | unauthenticated user | NULL | -1 | Connecting client | 0 | NULL |
| 131390 | unauthenticated user | NULL | -1 | Connecting client | 42 | NULL |
| 131392 | unauthenticated user | NULL | -1 | Connecting client | 14 | NULL |
+-----------+----------------------+----+-----------+-------------------+---------+------+
5 rows in set (0.00 sec)
mysql> show processlist;
+-----------+----------------------+----+-----------+-------------------+---------+------+
| SessionID | user | db | hostgroup | command | time_ms | info |
+-----------+----------------------+----+-----------+-------------------+---------+------+
| 132373 | unauthenticated user | NULL | -1 | Connecting client | 9 | NULL |
| 132374 | unauthenticated user | NULL | -1 | Connecting client | 8 | NULL |
| 132375 | unauthenticated user | NULL | -1 | Connecting client | 37 | NULL |
| 132376 | unauthenticated user | NULL | -1 | Connecting client | 0 | NULL |
| 132377 | unauthenticated user | NULL | -1 | Connecting client | 4 | NULL |
| 132378 | unauthenticated user | NULL | -1 | Connecting client | 0 | NULL |
| 132379 | unauthenticated user | NULL | -1 | Connecting client | 0 | NULL |
+-----------+----------------------+----+-----------+-------------------+---------+------+
7 rows in set (0.01 sec)
mysql> PROXYSQL PAUSE;
ERROR 1045 (28000): ProxySQL Admin Error: ProxySQL MySQL module is already paused, impossible to pause
mysql> show processlist;
ERROR 1045 (28000): ProxySQL Admin Error: ProxySQL PgSQL module is already paused, impossible to pause
mysql> show processlist;
+-----------+----------------------+----+-----------+-------------------+---------+------+
| SessionID | user | db | hostgroup | command | time_ms | info |
+-----------+----------------------+----+-----------+-------------------+---------+------+
| 132622 | unauthenticated user | NULL | -1 | Connecting client | 132 | NULL |
| 132623 | unauthenticated user | NULL | -1 | Connecting client | 0 | NULL |
| 132628 | unauthenticated user | NULL | -1 | Connecting client | 74 | NULL |
+-----------+----------------------+----+-----------+-------------------+---------+------+
3 rows in set (0.00 sec)
mysql> show processlist;
+-----------+----------------------+----+-----------+-------------------+---------+------+
| SessionID | user | db | hostgroup | command | time_ms | info |
+-----------+----------------------+----+-----------+-------------------+---------+------+
| 132702 | unauthenticated user | NULL | -1 | Connecting client | 0 | NULL |
| 132703 | unauthenticated user | NULL | -1 | Connecting client | 0 | NULL |
+-----------+----------------------+----+-----------+-------------------+---------+------+
2 rows in set (0.00 sec)
mysql> show processlist;
+-----------+----------------------+----+-----------+-------------------+---------+------+
| SessionID | user | db | hostgroup | command | time_ms | info |
+-----------+----------------------+----+-----------+-------------------+---------+------+
| 133060 | unauthenticated user | NULL | -1 | Connecting client | 0 | NULL |
| 133061 | unauthenticated user | NULL | -1 | Connecting client | 0 | NULL |
| 133062 | unauthenticated user | NULL | -1 | Connecting client | 2 | NULL |
| 133063 | unauthenticated user | NULL | -1 | Connecting client | 0 | NULL |
+-----------+----------------------+----+-----------+-------------------+---------+------+
4 rows in set (0.00 sec)
mysql> PROXYSQL STOP;
+-----------+----------------------+----+-----------+-------------------+---------+------+
| SessionID | user | db | hostgroup | command | time_ms | info |
+-----------+----------------------+----+-----------+-------------------+---------+------+
| 133171 | unauthenticated user | NULL | -1 | Connecting client | 44 | NULL |
| 133172 | unauthenticated user | NULL | -1 | Connecting client | 28 | NULL |
| 133173 | unauthenticated user | NULL | -1 | Connecting client | 0 | NULL |
| 133174 | unauthenticated user | NULL | -1 | Connecting client | 0 | NULL |
| 133175 | unauthenticated user | NULL | -1 | Connecting client | 0 | NULL |
| 133176 | unauthenticated user | NULL | -1 | Connecting client | 0 | NULL |
+-----------+----------------------+----+-----------+-------------------+---------+------+
6 rows in set (0.00 sec)
mysql> show processlist;
Query OK, 0 rows affected (1.35 sec)
mysql> show processlist;
^C^C -- query aborted
^C^C -- query aborted
^C^C -- query aborted
ProxySQL Error Log
I will attach this to the issue.
Thanks in advance for any light you may be able to sched on this!
Regards,
Dave