冰楓論壇

標題: mysql資料庫連線超時問題 [打印本頁]

作者: t0958593678    時間: 2021-5-27 17:38
標題: mysql資料庫連線超時問題
本帖最後由 t0958593678 於 2021-5-27 17:42 編輯

小弟最近在研究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.

導致進入選角時都變成空白:
登入異常.jpg

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








歡迎光臨 冰楓論壇 (https://bingfong.com/) Powered by 冰楓