Max connect timeout reached while reaching hostgroup

Polyglot Projects ProxySQL
1

Is there a way to reset the user and clear the error?

All users tested received the same error.
Restarted proxysql and other users cleared, but recordings_del still had error.

ERROR 9001 (HY000): Max connect timeout reached while reaching hostgroup 30 after 10135ms

Select * from stats_mysql_errors ;
+-----------+----------------+------+----------------+----------------+--------------------+-------+------------+------------+------------+-----------------------------------------------------------------------+
| hostgroup | hostname       | port | username       | client_address | schemaname         | errno | count_star | first_seen | last_seen  | last_error                                                            |
+-----------+----------------+------+----------------+----------------+--------------------+-------+------------+------------+------------+-----------------------------------------------------------------------+
| 30        | db4            | 6033 | recordings_del | 127.0.0.1      | information_schema | 9001  | 2          | 1602867997 | 1602867997 | Max connect timeout reached while reaching hostgroup 30 after 10175ms |
+-----------+----------------+------+----------------+----------------+--------------------+-------+------------+------------+------------+-----------------------------------------------------------------------+

---
mysql> Select * from mysql_servers ;
+--------------+---------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname| port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+---------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10           | db1-aws | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | db2-aws | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 30           | db4     | 6033 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |

mysql> Select * from runtime_mysql_servers ;
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10           | db1-aws  | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 30           | db4      | 6033 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | db2      | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
1 Like
2

Delete, and re-add the user from mysql_users. Delete, and re-add the host from mysql_servers. Be sure to load to run after delete and after insert.

1 Like