求助 黑盒子亂碼
ERROR - The last packet successfully received from the server was 59,488,851 milliseconds ago.The last packet sent successfully to the server was 59,488,852 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 59,488,851 milliseconds ago.The last packet sent successfully to the server was 59,488,852 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3851)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2471)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2683)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2144)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1379)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:989)
at com.lineage.server.datatables.sql.AccountTable.updateLan(AccountTable.java:311)
at com.lineage.server.datatables.lock.AccountReading.updateLan(AccountReading.java:119)
at com.lineage.list.OnlineUser.updateClient(OnlineUser.java:70)
at com.lineage.server.clientpackets.C_AuthLogin.checkLogin(C_AuthLogin.java:210)
at com.lineage.server.clientpackets.C_AuthLogin.start(C_AuthLogin.java:68)
at com.lineage.echo.PacketHandler.handlePacket(PacketHandler.java:179)
at com.lineage.echo.ClientExecutor.run(ClientExecutor.java:127)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.net.SocketException: Software caused connection abort: socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(Unknown Source)
at java.net.SocketOutputStream.write(Unknown Source)
at java.io.BufferedOutputStream.flushBuffer(Unknown Source)
at java.io.BufferedOutputStream.flush(Unknown Source)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3832)
... 16 more
有大大知道是哪個部分錯誤嗎
是不是伺服器開著就去睡覺
這個是閒置過久 自動關閉連線的
可以用上面的英文 去搜尋怎麼改時間 这是困扰无数人的SQL连接问题
其实可以无视，网络上有很多解决办法，但不一定有效。
有修改c3p0控制文件的，也有改MySQL连接时间的（这个有上限），但不一定能够杜绝这东西出现……
頁:
[1]