Error: Detected a broken connection during ping

219 views
Skip to first unread message

SysAdmin EM

unread,
Aug 20, 2021, 1:22:42 PM8/20/21
to proxysql
Good morning, I hope to receive help since I can not solve the problem.

I am trying to connect from exim to proxysql but I am getting the following error:

ProxySQL Admin> SELECT hostgroup_id, hostname, port, status FROM mysql_servers;
+--------------+-------------+------+--------+
| hostgroup_id | hostname    | port | status |
+--------------+-------------+------+--------+
| 1            | 172.17.54.2 | 3306 | ONLINE |
+--------------+-------------+------+--------+
1 row in set (0,00 sec)

When I test the connection from the console I do not see errors. Some help please.

[root@c233a ~] # mysql -usqlmonitor -p9cCnX7NigY99 -h 127.0.0.1 -P6033 -e "SELECT @@hostname";              
mysql: [Warning] Using a password on the command line interface can be insecure.
+-------------------------+
| @@hostname              |
+-------------------------+
| mysqlfz04.linux.backend |
+-------------------------+

ProxySQL Admin> SELECT * FROM monitor.mysql_server_ping_log ORDER BY time_start_us DESC LIMIT 10;
+-------------+------+------------------+----------------------+------------+
| hostname    | port | time_start_us    | ping_success_time_us | ping_error |
+-------------+------+------------------+----------------------+------------+
| 172.17.54.2 | 3306 | 1629480008967131 | 322                  | NULL       |
| 172.17.54.2 | 3306 | 1629480006990121 | 509                  | NULL       |
| 172.17.54.2 | 3306 | 1629480004982443 | 516                  | NULL       |
| 172.17.54.2 | 3306 | 1629480002991257 | 521                  | NULL       |
| 172.17.54.2 | 3306 | 1629480000992403 | 514                  | NULL       |
| 172.17.54.2 | 3306 | 1629479998977638 | 450                  | NULL       |
| 172.17.54.2 | 3306 | 1629479997005232 | 421                  | NULL       |
| 172.17.54.2 | 3306 | 1629479994970232 | 651                  | NULL       |
| 172.17.54.2 | 3306 | 1629479992974443 | 224                  | NULL       |
| 172.17.54.2 | 3306 | 1629479990987309 | 404                  | NULL       |
+-------------+------+------------------+----------------------+------------+
10 rows in set (0,00 sec)


Regards,

SysAdmin EM

unread,
Aug 31, 2021, 7:05:12 AM8/31/21
to proxysql
2021-08-31 08:02:05 MySQL_Session.cpp:3957:handler_minus1_ClientLibraryError(): [ERROR] Detected a broken connection during query on (1,172.17.54.2,
3306,1588254197) , FD (Conn:42 , MyDS:42) : 2013, Lost connection to MySQL server during query
2021-08-31 08:02:05 MySQL_Session.cpp:3971:handler_minus1_ClientLibraryError(): [WARNING] Retrying query.
2021-08-31 08:03:58 MySQL_Session.cpp:1481:handler_again___status_PINGING_SERVER(): [ERROR] Detected a broken connection during ping on (1,172.17.54
.2,3306) , FD (Conn:43 , MyDS:43) : 2013, Lost connection to MySQL server during query

Any helps??
Reply all
Reply to author
Forward
0 new messages