2019-09-07 14:22:56.474 INFO [$_NIOConnector] (io.mycat.net.AbstractConnection.close(AbstractConnection.java:520)) - close connection,reas[id=0, lastTime=1567837373465, user=discuz, schema=discuz, old shema=discuz, borrowed=false, fromSlaveDB=false, threadId=0, charset=utf8, t=mysql2, port=3306, statusSync=null, writeQueue=0, modifiedSQLExecuted=false]
2019-09-07 14:22:56.474 INFO [$_NIOConnector] (io.mycat.sqlengine.SQLJob.connectionError(SQLJob.java:125)) - can't get connection for sql
2019-09-07 14:22:56.474 ERROR [$_NIOConnector] (io.mycat.backend.heartbeat.MySQLHeartbeat.nextDector(MySQLHeartbeat.java:215)) - set Error
2019-09-07 14:22:56.474 INFO [$_NIOConnector] (io.mycat.backend.datasource.PhysicalDatasource$1$1.connectionError(PhysicalDatasource.java:
2019-09-07 14:23:03.466 INFO [Timer1] (io.mycat.backend.datasource.PhysicalDatasource.getConnection(PhysicalDatasource.java:540)) - no ild
2019-09-07 14:23:03.466 INFO [Timer1] (io.mycat.backend.datasource.PhysicalDatasource.getConnection(PhysicalDatasource.java:540)) - no ild
2019-09-07 14:23:06.474 ERROR [$_NIOConnector] (io.mycat.net.NIOConnector.finishConnect(NIOConnector.java:155)) - 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_211]
at io.mycat.net.NIOConnector.finishConnect(NIOConnector.java:165) ~[Mycat-server-1.6.6.1-release.jar:?]
at io.mycat.net.NIOConnector.finishConnect(NIOConnector.java:143) ~[Mycat-server-1.6.6.1-release.jar:?]
at io.mycat.net.NIOConnector.run(NIOConnector.java:98) ~[Mycat-server-1.6.6.1-release.jar:?]
啟動以后有mycat埠，通過mysql命令也能連接mycat而且能訪問資料庫，就是打開mycat日志的時候不斷報上面的錯誤
uj5u.com熱心網友回復：
我之前也碰到這個問題，最后發現是因為修改了用戶密碼，但是沒改mycat里面schema.xml配置。你的日子里面有：
2019-09-07 14:22:56.474 INFO [$_NIOConnector] (io.mycat.net.AbstractConnection.close(AbstractConnection.java:520)) - close connection,reas[id=0, lastTime=1567837373465, user=discuz, schema=discuz, old shema=discuz, borrowed=false, fromSlaveDB=false, threadId=0, charset=utf8, t=mysql2, port=3306, statusSync=null, writeQueue=0, modifiedSQLExecuted=false]
可以檢查下這個用戶的連接資訊是不是對的。
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/46827.html
標籤：MySQL
上一篇：請問這是哪個語言寫的？