黑盒子錯誤訊息
有大大可以幫忙解惑嗎? 此訊息都是維修前跳出來的The last packet successfully received from the server was 61,698,676 milliseconds ago.The last packet sent successfully to the server was 61,698,677 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 61,698,676 milliseconds ago.The last packet sent successfully to the server was 61,698,677 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.UpdataPrestigScore(voa:933)
at com.lineage.server.datatables.lock.AccountReading.UpdataPrestigScore(lta:704)
at com.lineage.server.model.Instance.L1PcInstance.logout(koa:2023)
at com.lineage.echo.QuitGame.quitGame(mib:276)
at com.lineage.server.Shutdown.saveData(idb:664)
at com.lineage.server.Shutdown.countdown(idb:688)
at com.lineage.server.Shutdown.run(idb:252)
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)
... 13 more
看不懂英文的話 丟翻譯就知道了
閒置過久 MySQL連線因為超過wait_timeout 設定的等待時間所以中斷了~MySQL的wait_timeout 預設好像是28800 秒（8 小時），如果在此期間內沒有任何資料庫活動，連線會自動終止~~~以上 1019449101 發表於 2024-11-6 20:29
MySQL連線因為超過wait_timeout 設定的等待時間所以中斷了~MySQL的wait_timeout 預設好像是28800 秒（8 小 ...
感謝解惑~~
頁:
[1]