mysql longer than the server configured value of ‘wait_timeout‘
mysql longer than the server configured value of 'wait_timeout'
问题现象:
com.mysql.jdbc.CommunicationsException: The last packet successfully received from the server was58129 seconds ago.The last packet sent successfully to the server was 58129 seconds ago, which 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.
解决办法:
mysql4.x版本 设置autoReconnect=true
mysql5以上的,修改my.ini配置文件,在mysqld下面添加以上两行,后面的数字是时间
[mysqld]
wait_timeout=31536000
interactive_timeout=31536000
开放原子开发者工作坊旨在鼓励更多人参与开源活动,与志同道合的开发者们相互交流开发经验、分享开发心得、获取前沿技术趋势。工作坊有多种形式的开发者活动,如meetup、训练营等,主打技术交流,干货满满,真诚地邀请各位开发者共同参与!
更多推荐
所有评论(0)