t0958593678

mysql資料庫連線超時問題

發表於 2021-5-27 11:26:22
t0958593678 發表於 2021-5-27 11:26:22 | 顯示全部樓層 |閱讀模式
小弟最近在研究V113端的伺服器,最近發現伺服器當用戶未登入使用下的閒置狀態時一但超過與Mysql資料庫連線默認8小時。
就會產生這個錯誤訊息:
error loading characters internalcom.mysql.jdbc.exceptions.jdbc4.Communications
Exception: The last packet successfully received from the server was 235,283,552
milliseconds ago.  The last packet sent successfully to the server was 235,283,552 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 tim
eouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
error updating login statecom.mysql.jdbc.exceptions.jdbc4.Communications Exception: The last packet successfully received from the server was 241,131,104 millise
conds ago.  The last packet sent successfully to the server was 241,131,104 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.

導致進入選角時都變成空白:


小弟也在Settings.ini檔使用了autoReconnect=true,結果問題一樣。所以希望各位大大們能幫忙小弟指點迷津,謝謝。
瀏覽 2672 回復 0

您需要登錄後才可以回帖 登錄 | 註冊會員

返回頂部