执行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)
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)