Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MySQL Router WARNING: Timeout reached trying to connect to MySQL Server HOSTNAME:3306: Connection ti

User_FBYFRJul 12 2018 — edited Jul 12 2018

Hello people

  I have an environment with InnoDB Cluster with 05 knots.

Recently, one of my servers stopped connecting to my database and triggered the message:

 

SQLSTATE [HY000] [1129] Many connection errors of 127.0.0.1

 

After restarting the mysql router for this environment, the service was reconnected to the databases.

  However, while parsing the MySQL Router Log for a while, I noticed the following message occurring several times:

 

2018-07-12 15:57:05 routing WARNING [7fccbb7fe700] Timeout reached attempting to connect to MySQL server HOSTNAME: 3306: Connection timed out

2018-07-12 15:57:14 routing INFO [7fccbb7fe700] [routing: mysqlclusterprd_default_ro] fd = 53 Previous authentication socket failed 127.0.0.1: client authentication has expired

 

I could not find anything that is causing this problem.

can you help me?

 

MySQL version: 5.7.22

Version of the MySQL Router: 8.0.11

This post has been answered by handat on Jul 12 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 9 2018
Added on Jul 12 2018
2 comments
685 views