kettle作业拉取服务器文件超时问题
2022/12/06 06:47:49 - 服务器备份操作 - ERROR (version 9.1.0.0-324, build 9.1.0.0-324 from 2020-09-07 05.09.05 by buildguy) : Error running job entry 'job' :
2022/12/06 06:47:49 - 服务器备份操作 - ERROR (version 9.1.0.0-324, build 9.1.0.0-324 from 2020-09-07 05.09.05 by buildguy) : org.pentaho.di.core.exception.KettleException:
2022/12/06 06:47:49 - 服务器备份操作 - Unexpected error during job metadata load
2022/12/06 06:47:49 - 服务器备份操作 -
2022/12/06 06:47:49 - 服务器备份操作 - An error occured loading the directory tree from the repository
2022/12/06 06:47:49 - 服务器备份操作 -
2022/12/06 06:47:49 - 服务器备份操作 - Error comitting connection
2022/12/06 06:47:49 - 服务器备份操作 - No operations allowed after connection closed.
2022/12/06 06:47:49 - 服务器备份操作 -
2022/12/06 06:47:49 - 服务器备份操作 -
2022/12/06 06:47:49 - 服务器备份操作 -
2022/12/06 06:47:49 - 服务器备份操作 - at org.pentaho.di.job.entries.job.JobEntryJob.getJobMeta(JobEntryJob.java:1455)
2022/12/06 06:47:49 - 服务器备份操作 - at org.pentaho.di.job.entries.job.JobEntryJob.getJobMeta(JobEntryJob.java:1373)
2022/12/06 06:47:49 - 服务器备份操作 - at org.pentaho.di.job.entries.job.JobEntryJob.execute(JobEntryJob.java:695)
2022/12/06 06:47:49 - 服务器备份操作 - at org.pentaho.di.job.Job.execute(Job.java:682)
2022/12/06 06:47:49 - 服务器备份操作 - at org.pentaho.di.job.Job.execute(Job.java:823)
2022/12/06 06:47:49 - 服务器备份操作 - at org.pentaho.di.job.Job.execute(Job.java:500)
2022/12/06 06:47:49 - 服务器备份操作 - at org.pentaho.di.job.Job.run(Job.java:386)
2022/12/06 06:47:49 - 服务器备份操作 - Caused by: org.pentaho.di.core.exception.KettleException:
2022/12/06 06:47:49 - 服务器备份操作 - An error occured loading the directory tree from the repository
2022/12/06 06:47:49 - 服务器备份操作 -
2022/12/06 06:47:49 - 服务器备份操作 - Error comitting connection
2022/12/06 06:47:49 - 服务器备份操作 - No operations allowed after connection closed.
2022/12/06 06:47:49 - 服务器备份操作 -
2022/12/06 06:47:49 - 服务器备份操作 -
2022/12/06 06:47:49 - 服务器备份操作 - at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryDirectoryDelegate.loadRepositoryDirectoryTree(KettleDatabaseRepositoryDirectoryDelegate.java:108)
2022/12/06 06:47:49 - 服务器备份操作 - at org.pentaho.di.repository.kdr.KettleDatabaseRepository.loadRepositoryDirectoryTree(KettleDatabaseRepository.java:608)
2022/12/06 06:47:49 - 服务器备份操作 - at org.pentaho.di.job.entries.job.JobEntryJob.getJobMetaFromRepository(JobEntryJob.java:1390)
2022/12/06 06:47:49 - 服务器备份操作 - at org.pentaho.di.job.entries.job.JobEntryJob.getJobMeta(JobEntryJob.java:1430)
2022/12/06 06:47:49 - 服务器备份操作 - ... 6 more
2022/12/06 06:47:49 - 服务器备份操作 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
2022/12/06 06:47:49 - 服务器备份操作 - Error comitting connection
2022/12/06 06:47:49 - 服务器备份操作 - No operations allowed after connection closed.
2022/12/06 06:47:49 - 服务器备份操作 -
2022/12/06 06:47:49 - 服务器备份操作 - at org.pentaho.di.core.database.Database.commit(Database.java:841)
2022/12/06 06:47:49 - 服务器备份操作 - at org.pentaho.di.core.database.Database.commit(Database.java:813)
2022/12/06 06:47:49 - 服务器备份操作 - at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.closeReadTransaction(KettleDatabaseRepositoryConnectionDelegate.java:2019)
2022/12/06 06:47:49 - 服务器备份操作 - at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.callRead(KettleDatabaseRepositoryConnectionDelegate.java:2033)
2022/12/06 06:47:49 - 服务器备份操作 - at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.getIDs(KettleDatabaseRepositoryConnectionDelegate.java:1624)
2022/12/06 06:47:49 - 服务器备份操作 - at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryDirectoryDelegate.getSubDirectoryIDs(KettleDatabaseRepositoryDirectoryDelegate.java:290)
2022/12/06 06:47:49 - 服务器备份操作 - at org.pentaho.di.repository.kdr.KettleDatabaseRepository.getSubDirectoryIDs(KettleDatabaseRepository.java:684)
2022/12/06 06:47:49 - 服务器备份操作 - at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryDirectoryDelegate.loadRepositoryDirectoryTree(KettleDatabaseRepositoryDirectoryDelegate.java:98)
2022/12/06 06:47:49 - 服务器备份操作 - ... 9 more
2022/12/06 06:47:49 - 服务器备份操作 - Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
2022/12/06 06:47:49 - 服务器备份操作 - at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
2022/12/06 06:47:49 - 服务器备份操作 - at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
2022/12/06 06:47:49 - 服务器备份操作 - at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
2022/12/06 06:47:49 - 服务器备份操作 - at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
2022/12/06 06:47:49 - 服务器备份操作 - at com.mysql.jdbc.Util.handleNewInstance(Util.java:403)
2022/12/06 06:47:49 - 服务器备份操作 - at com.mysql.jdbc.Util.getInstance(Util.java:386)
2022/12/06 06:47:49 - 服务器备份操作 - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
2022/12/06 06:47:49 - 服务器备份操作 - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
2022/12/06 06:47:49 - 服务器备份操作 - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
2022/12/06 06:47:49 - 服务器备份操作 - at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861)
2022/12/06 06:47:49 - 服务器备份操作 - at com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1182)
2022/12/06 06:47:49 - 服务器备份操作 - at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1177)
2022/12/06 06:47:49 - 服务器备份操作 - at com.mysql.jdbc.ConnectionImpl.commit(ConnectionImpl.java:1514)
2022/12/06 06:47:49 - 服务器备份操作 - at org.pentaho.di.core.database.Database.commit(Database.java:832)
2022/12/06 06:47:49 - 服务器备份操作 - ... 16 more
2022/12/06 06:47:49 - 服务器备份操作 - Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet successfully received from the server was 29,184,455 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
2022/12/06 06:47:49 - 服务器备份操作 - at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
2022/12/06 06:47:49 - 服务器备份操作 - at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
2022/12/06 06:47:49 - 服务器备份操作 - at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
2022/12/06 06:47:49 - 服务器备份操作 - at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
2022/12/06 06:47:49 - 服务器备份操作 - at com.mysql.jdbc.Util.handleNewInstance(Util.java:403)
2022/12/06 06:47:49 - 服务器备份操作 - at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990)
2022/12/06 06:47:49 - 服务器备份操作 - at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3517)
2022/12/06 06:47:49 - 服务器备份操作 - at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3417)
2022/12/06 06:47:49 - 服务器备份操作 - at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3860)
2022/12/06 06:47:49 - 服务器备份操作 - at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
2022/12/06 06:47:49 - 服务器备份操作 - at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675)
2022/12/06 06:47:49 - 服务器备份操作 - at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
2022/12/06 06:47:49 - 服务器备份操作 - at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1915)
2022/12/06 06:47:49 - 服务器备份操作 - at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2023)
2022/12/06 06:47:49 - 服务器备份操作 - at org.pentaho.di.core.database.Database.openQuery(Database.java:1820)
2022/12/06 06:47:49 - 服务器备份操作 - at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate$6.call(KettleDatabaseRepositoryConnectionDelegate.java:1626)
2022/12/06 06:47:49 - 服务器备份操作 - at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate$6.call(KettleDatabaseRepositoryConnectionDelegate.java:1624)
2022/12/06 06:47:49 - 服务器备份操作 - at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.callRead(KettleDatabaseRepositoryConnectionDelegate.java:2025)
2022/12/06 06:47:49 - 服务器备份操作 - ... 13 more
2022/12/06 06:47:49 - 服务器备份操作 - Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
2022/12/06 06:47:49 - 服务器备份操作 - at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2969)
2022/12/06 06:47:49 - 服务器备份操作 - at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3427)
2022/12/06 06:47:49 - 服务器备份操作 - ... 24 more
但是另一个作业 备份数据库sql文件又不会出现这种错误，每天都能定时拉取
我这个备份服务器文件作业连接超过8小时无响应就会自动断开。按照网上的教程配置了wait_timeout 大于8小时也没用
但是假如是因为8小时无连接自动断开的话，备份数据库作业为啥又能正常运行呢？
