Bug #100727 Timeout reached trying to connect to MySQL Server
Submitted: 3 Sep 2020 12:36 Modified: 3 Sep 2020 12:47
Reporter: Bo Yang Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Router Severity:S2 (Serious)
Version:8.0.21 OS:Any
Assigned to: CPU Architecture:Any

[3 Sep 2020 12:36] Bo Yang 
Description:
使用MySQL Router 8.0.20 连接MySQL Community Server 5.7.28 出现连接超时问题，跟踪日志信息如下：
2020-08-31 00:59:59 routing INFO [7f8fe50c3700] Too many connection errors from 10.1xx.1xx.x1
2020-08-31 01:00:01 routing WARNING [7f8fe50c3700] Timeout reached trying to connect to MySQL Server 10.1xx.1xx.6:3306: Connection timed out
2020-08-31 01:00:02 routing INFO [7f8fe50c3700] Too many connection errors from 10.1xx.1xx.x2
想知道是什么原因引起,另外一台MySQL Router服务器连接数据库在相同时间节点并未出现问题。

How to repeat:
偶发性发生。

Suggested fix:
建议部署两台MySQL Router之间检查心跳确认，要么同时转发，要么不转发连接到后端数据库服务器。
[3 Sep 2020 12:47] MySQL Verification Team 
No repeatable test case in English.