kettle_manager吧 关注:32贴子:80
  • 1回复贴,共1

mysql数据库执行一段时间容易断开连接问题,大家怎么解决的

只看楼主收藏回复

执行job的时候就会抛异常,连接url上已经加了autoReconnect=true
org.pentaho.di.core.exception.KettleDatabaseException:
ERROR executing query
The last packet successfully received from the server was 59,279,621 milliseconds ago. The last packet sent successfully to the server was 59,279,622 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.
at org.pentaho.di.core.database.Database.openQuery(Database.java:1776)
at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.getIDs(KettleDatabaseRepositoryConnectionDelegate.java:1576)


IP属地:阿联酋1楼2018-04-25 22:54回复
    我也是遇到同样的问题。


    IP属地:广东2楼2019-07-30 09:28
    回复