mysql資料庫連線超時問題

t0958593678 · 發表於 2021-5-27 11:26:22

本帖最後由 t0958593678 於 2021-5-27 17:43 編輯

小弟最近在研究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，結果問題一樣。所以希望各位大大們能幫忙小弟指點迷津，謝謝。

共收到 0 A幣

打賞榜

暫無

暫無

暫無

暫無