Mycat1.6 间歇性的报错

274 阅读1分钟

 

2020-04-14 09:01:14.389 ERROR [$_NIOREACTOR-0-RW] (io.mycat.backend.mysql.nio.MySQLConnectionHandler.handleFieldEofPacket(MySQLConnectionHandler.java:197)) - receive FieldEofPacket but no handler
2020-04-14 09:01:14.389  INFO [$_NIOREACTOR-0-RW] (io.mycat.net.AbstractConnection.close(AbstractConnection.java:520)) - close connection,reason:no handler ,MySQLConnection@1740927055 [id=57, 
2020-04-14 09:01:16.764  WARN [$_NIOREACTOR-3-RW] (io.mycat.net.NIOSocketWR.doNextWriteCheck(NIOSocketWR.java:64)) - caught err:
java.io.IOException: Broken pipe
        at sun.nio.ch.FileDispatcherImpl.write0(Native Method) ~[?:1.8.0_242]
        at sun.nio.ch.SocketDispatcher.write(SocketDispatcher.java:47) ~[?:1.8.0_242]
        at sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:93) ~[?:1.8.0_242]
ERROR 2027 (HY000): Malformed packet
ERROR 2013 (HY000): Lost connection to MySQL server during query

 

影响因素:

mycat后端连接数据库交换有问题

后端连接使用jdbc或者native交换

aio与nio交换

cpu核数,参考权威指南