CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet successfully received from the server was 2,297,746 milliseconds ago. The last packet sent successfully to the server was 4 milliseconds ago.
什么,创建事务失败,内部异常 连接失败?what?
通过查找资料,可能是wait_timeout设置过小导致的,尝试加大wait_timeout的值后,系统恢复正常。或者修改连接池的配置信息。
那么wait_timeout是什么?
wait_timeout:当数据库重启或数据库空闲连接超过设置的最大timemout时间,数据库会强行断开已有的链接,MySQL服务器默认的“wait_timeout”默认是28800秒即8小时,意味着如果一个连接的空闲时间超过8个小时,MySQL将自动断开该连接,而连接池却认为该连接还是有效的(因为并未校验连接的有效性)