# Max connect timeout reached while reaching hostgroup

**URL:** <https://forums.percona.com/t/max-connect-timeout-reached-while-reaching-hostgroup/8860>\
**Category:** ProxySQL\
**Created:** [January 19, 2021, 7:23pm UTC](https://forums.percona.com/t/max-connect-timeout-reached-while-reaching-hostgroup/8860 "2021-01-19T19:23:11Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![star2star\_lewis](https://avatars.discourse-cdn.com/v4/letter/s/c0e974/32.png) [@star2star\_lewis](https://forums.percona.com/u/star2star_lewis)\
**Post date:** [January 19, 2021, 7:23pm UTC](https://forums.percona.com/t/max-connect-timeout-reached-while-reaching-hostgroup/8860/1 "2021-01-19T19:23:11Z")

</div>

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.

```auto
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 | |

```

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [January 19, 2021, 10:43pm UTC](https://forums.percona.com/t/max-connect-timeout-reached-while-reaching-hostgroup/8860/2 "2021-01-19T22:43:57Z")

</div>

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.