连接上了mycat,sql不是每次都能成功
来源:2-6 快速体验MyCat
hehehei
2020-04-13 03:15:49
客户端报错 [2020-04-13 03:00:15] [08S01][1184] #HY000
服务的错误日志:
2020-04-12 15:06:08.201 WARN [$_NIOREACTOR-0-RW] (io.mycat.backend.mysql.nio.handler.SingleNodeHandler.execute(SingleNodeHandler.java:207)) - ServerConnection [id=1, schema=user, host=192.168.2.102, user=root,txIsolation=3, autocommit=true, schema=user, executeSql=SHOW WARNINGS]SHOW WARNINGS, route={
1 -> dn1{SHOW WARNINGS}
}
java.lang.NullPointerException
at io.mycat.backend.mysql.nio.handler.SingleNodeHandler.execute(SingleNodeHandler.java:203) ~[Mycat-server-1.6.7.4-release.jar:?]
at io.mycat.server.NonBlockingSession.execute(NonBlockingSession.java:148) ~[Mycat-server-1.6.7.4-release.jar:?]
at io.mycat.server.ServerConnection.routeEndExecuteSQL(ServerConnection.java:314) ~[Mycat-server-1.6.7.4-release.jar:?]
at io.mycat.server.ServerConnection.execute(ServerConnection.java:241) ~[Mycat-server-1.6.7.4-release.jar:?]
at io.mycat.server.handler.ShowHandler.handle(ShowHandler.java:60) ~[Mycat-server-1.6.7.4-release.jar:?]
at io.mycat.server.ServerQueryHandler.query(ServerQueryHandler.java:92) ~[Mycat-server-1.6.7.4-release.jar:?]
at io.mycat.net.FrontendConnection.query(FrontendConnection.java:376) ~[Mycat-server-1.6.7.4-release.jar:?]
at io.mycat.net.FrontendConnection.query(FrontendConnection.java:396) ~[Mycat-server-1.6.7.4-release.jar:?]
at io.mycat.net.handler.FrontendCommandHandler.handle(FrontendCommandHandler.java:76) ~[Mycat-server-1.6.7.4-release.jar:?]
at io.mycat.net.FrontendConnection.rawHandle(FrontendConnection.java:570) ~[Mycat-server-1.6.7.4-release.jar:?]
at io.mycat.net.FrontendConnection.handle(FrontendConnection.java:552) ~[Mycat-server-1.6.7.4-release.jar:?]
at io.mycat.net.AbstractConnection.onReadData(AbstractConnection.java:327) ~[Mycat-server-1.6.7.4-release.jar:?]
at io.mycat.net.NIOSocketWR.asynRead(NIOSocketWR.java:216) ~[Mycat-server-1.6.7.4-release.jar:?]
at io.mycat.net.AbstractConnection.asynRead(AbstractConnection.java:279) ~[Mycat-server-1.6.7.4-release.jar:?]
at io.mycat.net.NIOReactor$RW.run(NIOReactor.java:113) ~[Mycat-server-1.6.7.4-release.jar:?]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_242]
2020-04-12 15:06:08.201 ERROR [$_NIOREACTOR-0-RW] (io.mycat.net.FrontendConnection.writeErrMessage(FrontendConnection.java:210)) - ServerConnection [id=1, schema=user, host=192.168.2.102, user=root,txIsolation=3, autocommit=true, schema=user, executeSql=SHOW WARNINGS]nulljava.lang.Thread .getStackTrace1559
io.mycat.net.FrontendConnection .getStack224
io.mycat.net.FrontendConnection .writeErrMessage210
io.mycat.backend.mysql.nio.handler.SingleNodeHandler .connectionError263
io.mycat.backend.mysql.nio.handler.SingleNodeHandler .execute209
io.mycat.server.NonBlockingSession .execute148
io.mycat.server.ServerConnection .routeEndExecuteSQL314
io.mycat.server.ServerConnection .execute241
io.mycat.server.handler.ShowHandler .handle60
io.mycat.server.ServerQueryHandler .query92
io.mycat.net.FrontendConnection .query376
io.mycat.net.FrontendConnection .query396
io.mycat.net.handler.FrontendCommandHandler .handle76
io.mycat.net.FrontendConnection .rawHandle570
io.mycat.net.FrontendConnection .handle552
io.mycat.net.AbstractConnection .onReadData327
io.mycat.net.NIOSocketWR .asynRead216
io.mycat.net.AbstractConnection .asynRead279
io.mycat.net.NIOReactor$RW .run113
java.lang.Thread .run748
write errorMsg:{} error
1回答
coding_zhang
2020-04-13
检查一下你的配置吧,datanode,datahost等。确保每一个mysql实例都能连接正确。
mysql的密码要用mysql_native_password加密。
相似问题