Proxysql: ERROR 9001 (HY000) at line 1: Max connect timeout reached while reaching hostgroup 0 after 10000ms

[raghavendrablu]

Server version: 5.5.30

`select * from mysql_servers;
+--------------+---------------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+---------------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 0 | 172.16.36.165 | 3306 | ONLINE | 1 | 0 | 1000 | 0 | 0 | 0 | |
+--------------+---------------+------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+

select * from mysql_users;
+----------+--------------+--------+---------+-------------------+----------------+---------------+------------------------+--------------+---------+----------+-----------------+
| username | password | active | use_ssl | default_hostgroup | default_schema | schema_locked | transaction_persistent | fast_forward | backend | frontend | max_connections |
+----------+--------------+--------+---------+-------------------+----------------+---------------+------------------------+--------------+---------+----------+-----------------+
| proxysql | proxysql@123 | 1 | 0 | 0 | NULL | 0 | 1 | 0 | 1 | 1 | 10000 |
| sandbox | sandbox | 1 | 0 | 0 | NULL | 0 | 1 | 0 | 1 | 1 | 10000 |
+----------+--------------+--------+---------+-------------------+----------------+---------------+------------------------+--------------+---------+----------+-----------------+

`
when we trying to connect we are getting below errors
mysql -u sandbox -psandbox -h 127.0.0.1 -P 6033 -e "select @@hostname"
ERROR 9001 (HY000) at line 1: Max connect timeout reached while reaching hostgroup 0 after 10000ms

Thank you!

[pondix]

This is not a bug, but rather a configuration issue. Please go through one of the how-to / blog articles on configuring a new proxysql instance or check the forums for similar issues or start a new thread for community help.

• Check select * from runtime_mysql_servers, it is highly likely you haven't configured your monitor user as described in the WIKI section on monitoring.
• Otherwise check /var/lib/proxysql/proxysql.log to see what is causing the error.

[BestChinchilla]

I write a comment just in case to avoid stupid mistakes

Run in admin prompt next queries:

SELECT username, default_hostgroup FROM mysql_users;
SELECT hostgroup_id, hostname FROM mysql_servers;

If _default_hostgroup_ and _hostgroup_id_ parameters of management user and endpoint MySQL are different then correct it