Java MySQL JDBC通信链路故障

Question

我有一个带有JDBC mysql连接的服务器，但每天早上检查服务器时都会出现这样的错误：

在com.mysql.jdbc.mysqlio.readfly(mysqlio.java:1395)在com.mysql.jdbc.mysqlio.reuseandreadpacket(mysqlio.java:1539)在com.mysql.jdbc.mysqlio.checkerrorpacket(mysqlio.java:1930)在com.mysql.jdbc.mysqlio.sendcommand(mysqlio.java:1168)在在hu.craftbox.server.craftboxServerHandler.messageReceed(CraftboxServerHandler.java:158)在org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpper(simpleChannelUpstreamHandler.java:70)在org.jboss.netty.channel.defaultChannelPipeline.sendupStreamStream(DefaultChannelPipeline.java:564)在jboss.netty.handler.timeout.readtimeouthandler.messageReceed(readtimeouthandler.java:184)位于org.jboss.netty.channel.SimpleChannelupStreamHandler.HandleUpstream(simpleChannelupStreamHandler.java:70)在org.jboss.netty.channel.defaultChannelPipeline.sendupStream(DefaultChannelPipeline.java:564)在org.jboss.netty.channel.defaultChannelPipeline.java:564)在java:70)在org.jboss.netty.channel.defaultChannelPipeline.sendupStream（defaultChannelPipeline.java:564)在org.jboss.netty.channel.defaultChannelPipeline.sendupStream（defaultChannelPipeline.java:559)在org.jboss.netty.channel.channels.firemessageReceed（channels.java:268)在位于org.jboss.net的netty.channel.socket.nio.abstractnioworker.process（abstractnioworker.java:108)run(abstractnioselector.java:318)在org.jboss.netty.channel.socket.nio.abstractnioworker.run(abstractnioworker.java:89)在org.jboss.netty.channel.nocket.nio.nioworker.run(nioworker.java:178)在org.jboss.netty.netty.threadrenamingrunnable.run(threadrenamingrunnable.java:108)在java.util.concurrent.ThreadPoolExecutor.runworker(threadPoolExecutor.java:1145)在java.util.concurrent.threadPoolExecutor$worker.run(threadPoolExecutor.java:615)在java.lang.thread.run(thread.java:744)

**结束嵌套异常**

    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1714)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1930)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1168)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
    at com.mysql.jdbc.Connection.execSQL(Connection.java:2281)
    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1634)
    at hu.craftbox.Server.CraftboxServerHandler.messageReceived(CraftboxServerHandler.java:158)
    at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70)
    at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)
    at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791)
    at org.jboss.netty.handler.timeout.ReadTimeoutHandler.messageReceived(ReadTimeoutHandler.java:184)
    at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70)
    at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)
    at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791)
    at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296)
    at org.jboss.netty.handler.codec.oneone.OneToOneDecoder.handleUpstream(OneToOneDecoder.java:70)
    at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)
    at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:559)
    at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:268)
    at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:255)
    at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:88)
    at org.jboss.netty.channel.socket.nio.AbstractNioWorker.process(AbstractNioWorker.java:108)
    at org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:318)
    at org.jboss.netty.channel.socket.nio.AbstractNioWorker.run(AbstractNioWorker.java:89)
    at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:178)
    at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108)
    at org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:744)

什么会导致这个问题，我如何解决它？

Answer 1

MySQL会在一段时间后删除未使用的连接，因为它假设另一方忘记关闭它。

您需要做的是根据您的业务正确配置您的MySQL，请查看此处如何配置您的MySQL。