Ping timeout during ping on host : port

[cehau37]

Hi,

We are receiving many ping timeout errors in our proxysql instance.

2019-09-18 10:33:01 MySQL_Session.cpp:1401:handler_again___status_PINGING_SERVER(): [ERROR] Ping timeout during ping on 172.16.0.245 , 3306
2019-09-18 10:33:27 MySQL_Session.cpp:1401:handler_again___status_PINGING_SERVER(): [ERROR] Ping timeout during ping on 172.16.0.51 , 3306
2019-09-18 10:33:28 MySQL_Session.cpp:1401:handler_again___status_PINGING_SERVER(): [ERROR] Ping timeout during ping on 172.16.0.51 , 3306
2019-09-18 10:33:37 MySQL_Session.cpp:1401:handler_again___status_PINGING_SERVER(): [ERROR] Ping timeout during ping on 172.16.0.51 , 3306
2019-09-18 10:35:17 MySQL_Session.cpp:1401:handler_again___status_PINGING_SERVER(): [ERROR] Ping timeout during ping on 172.16.0.45 , 3306
2019-09-18 10:35:17 MySQL_Session.cpp:1401:handler_again___status_PINGING_SERVER(): [ERROR] Ping timeout during ping on 172.16.0.45 , 3306
2019-09-18 10:35:37 MySQL_Session.cpp:1401:handler_again___status_PINGING_SERVER(): [ERROR] Ping timeout during ping on 172.16.0.51 , 3306
2019-09-18 10:35:37 MySQL_Session.cpp:1401:handler_again___status_PINGING_SERVER(): [ERROR] Ping timeout during ping on 172.16.0.51 , 3306

But checking the monitor, everything seems to be fine.

SELECT * FROM monitor.mysql_server_ping_log;
+--------------+------+------------------+----------------------+------------+
| hostname | port | time_start_us | ping_success_time_us | ping_error |
+--------------+------+------------------+----------------------+------------+
| 172.16.0.51 | 3306 | 1568778510521090 | 223 | NULL |
| 172.16.0.45 | 3306 | 1568778510539319 | 259 | NULL |
| 172.16.0.245 | 3306 | 1568778510557519 | 185 | NULL |
| 172.16.0.45 | 3306 | 1568778710521157 | 376 | NULL |
| 172.16.0.51 | 3306 | 1568778710534358 | 272 | NULL |
| 172.16.0.245 | 3306 | 1568778710547593 | 265 | NULL |
| 172.16.0.51 | 3306 | 1568778910521270 | 254 | NULL |
| 172.16.0.245 | 3306 | 1568778910539741 | 171 | NULL |
| 172.16.0.45 | 3306 | 1568778910558259 | 222 | NULL |
| 172.16.0.45 | 3306 | 1568779110521400 | 253 | NULL |
| 172.16.0.51 | 3306 | 1568779110538135 | 306 | NULL |
| 172.16.0.245 | 3306 | 1568779110554495 | 244 | NULL |
+--------------+------+------------------+----------------------+------------+

Not sure what is going on here...

OS: CentOS 7
ProxySQL: 2.0.6

[renecannao]

Can you share the whole error log?

We will also add a patch to be more verbose

[cehau37]

Hi @renecannao ,

Can you share the whole error log? --> do you mean the whole error log file?

[cehau37]

2019-09-21 08:27:37 MySQL_Session.cpp:1401:handler_again___status_PINGING_SERVER(): [ERROR] Ping timeout during ping on 172.16.0.51 , 3306
2019-09-21 08:27:37 MySQL_Session.cpp:1401:handler_again___status_PINGING_SERVER(): [ERROR] Ping timeout during ping on 172.16.0.51 , 3306
2019-09-21 08:30:11 MySQL_Session.cpp:1401:handler_again___status_PINGING_SERVER(): [ERROR] Ping timeout during ping on 172.16.0.51 , 3306
2019-09-21 08:31:58 MySQL_Session.cpp:1401:handler_again___status_PINGING_SERVER(): [ERROR] Ping timeout during ping on 172.16.0.51 , 3306
2019-09-21 08:32:53 MySQL_Session.cpp:1401:handler_again___status_PINGING_SERVER(): [ERROR] Ping timeout during ping on 172.16.0.51 , 3306
2019-09-21 08:32:53 MySQL_Session.cpp:1401:handler_again___status_PINGING_SERVER(): [ERROR] Ping timeout during ping on 172.16.0.51 , 3306
2019-09-21 08:40:11 MySQL_Session.cpp:1401:handler_again___status_PINGING_SERVER(): [ERROR] Ping timeout during ping on 172.16.0.51 , 3306
2019-09-21 08:40:32 MySQL_Session.cpp:1401:handler_again___status_PINGING_SERVER(): [ERROR] Ping timeout during ping on 172.16.0.51 , 3306
2019-09-21 08:44:21 MySQL_Session.cpp:1401:handler_again___status_PINGING_SERVER(): [ERROR] Ping timeout during ping on 172.16.0.51 , 3306
2019-09-21 08:46:51 MySQL_Session.cpp:1401:handler_again___status_PINGING_SERVER(): [ERROR] Ping timeout during ping on 172.16.0.51 , 3306
2019-09-21 08:47:47 MySQL_Session.cpp:1401:handler_again___status_PINGING_SERVER(): [ERROR] Ping timeout during ping on 172.16.0.51 , 3306
2019-09-21 08:56:21 MySQL_Session.cpp:1401:handler_again___status_PINGING_SERVER(): [ERROR] Ping timeout during ping on 172.16.0.51 , 3306
2019-09-21 09:02:46 MySQL_Thread.cpp:3621:process_data_on_data_stream(): [WARNING] Detected broken idle connection on 172.16.0.51:3306
2019-09-21 09:02:46 MySQL_Thread.cpp:3621:process_data_on_data_stream(): [WARNING] Detected broken idle connection on 172.16.0.51:3306
2019-09-21 09:03:35 MySQL_Session.cpp:1401:handler_again___status_PINGING_SERVER(): [ERROR] Ping timeout during ping on 172.16.0.51 , 3306
2019-09-21 09:03:41 MySQL_Session.cpp:1401:handler_again___status_PINGING_SERVER(): [ERROR] Ping timeout during ping on 172.16.0.51 , 3306
2019-09-21 09:03:45 MySQL_Session.cpp:1401:handler_again___status_PINGING_SERVER(): [ERROR] Ping timeout during ping on 172.16.0.51 , 3306
2019-09-21 09:04:37 MySQL_Session.cpp:1401:handler_again___status_PINGING_SERVER(): [ERROR] Ping timeout during ping on 172.16.0.51 , 3306

[KangShanR]

正在 Ping github.com [192.30.253.112] 具有 32 字节的数据:
请求超时。
请求超时。
请求超时。
请求超时。

192.30.253.112 的 Ping 统计信息:
数据包: 已发送 = 4，已接收 = 0，丢失 = 4 (100% 丢失)，