The 2019-09-07 14:22:56. 474 INFO [$_NIOConnector] (IO) mycat. Sqlengine. SQLJob. ConnectionError (125) SQLJob. Java:) - can 't get the connection for SQL
The 2019-09-07 14:22:56. ERROR 474 [$_NIOConnector] (IO) mycat. Backend. Heartbeat. MySQLHeartbeat. NextDector (215) MySQLHeartbeat. Java:) - set the ERROR
The 2019-09-07 14:22:56. 474 INFO [$_NIOConnector] (IO. Mycat. Backend. The datasource. PhysicalDatasource $1 $1. ConnectionError (PhysicalDatasource. Java:
The 2019-09-07 14:23:03. 466 INFO/Timer1 (. IO. Mycat. Backend datasource. PhysicalDatasource. GetConnection (540) PhysicalDatasource. Java:) - no ild
The 2019-09-07 14:23:03. 466 INFO/Timer1 (. IO. Mycat. Backend datasource. PhysicalDatasource. GetConnection (540) PhysicalDatasource. Java:) - no ild
The 2019-09-07 14:23:06. ERROR 474 [$_NIOConnector] (io.mycat.net.NIOConnector.finishConnect (155) NIOConnector. Java:) - ERROR:
Java.net.NoRouteToHostException: No route to host
At sun. Nio. Ch. SocketChannelImpl. CheckConne
At sun. Nio. Ch. SocketChannelImpl. FinishConnect (SocketChannelImpl. Java: 717) ~ [? : 1.8.0 comes with _211]
At io.mycat.net.NIOConnector.finishConnect NIOConnector. Java: (165) ~ [Mycat - server - 1.6.6.1 - the jar:?]
At io.mycat.net.NIOConnector.finishConnect NIOConnector. Java: (143) ~ [Mycat - server - 1.6.6.1 - the jar:?]
At io.mycat.net.NIOConnector.run NIOConnector. Java: (98) ~ [Mycat - server - 1.6.6.1 - the jar:?]
After starting with mycat port, through the mysql command can also connect mycat and can access the database, is open mycat constantly put the error log
CodePudding user response:
I also met this problem before, and finally found that because of changed the user's password, but did not change inside mycat schema. The XML configuration,Your days are:
The 2019-09-07 14:22:56. 474 INFO [$_NIOConnector] (io.mycat.net.AbstractConnection.close (520) AbstractConnection. Java:) - the close connection, reas [id=0, lastTime=1567837373465, user=discuz, schema=discuz, old shema=discuz, doesn=false, fromSlaveDB=false, threadId=0, charset=utf8, t=mysql2, port=3306, statusSync=null, writeQueue=0, modifiedSQLExecuted=false]
You can check this user's connection information is right,