连接上了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加密。

0
hoding_zhang
回复
hehehei
h 每个客户端连接的加密方式也不一样,像navicat用的就是老的加密方式。
h020-04-13
共2条回复

Java架构师-技术专家

千万级电商项目从0到100全过程,覆盖Java程序员不同成长阶段的核心问题与解决方案

2672 学习 · 5839 问题

查看课程