kettle 【关闭的连接】Closed Connection 的问题
求教 各位大神,
kettle运行一段时间就会出现【关闭的链接】错误,相同数据、相同程序逻辑在另外一台服务器就没有这个问题。
应用:kettle版本4.3
数据库:oracle 11g
操作系统:suse12
以下是日志部分:
ERROR 15-01 01:00:36,783 - T_USER - Because of an error, this step can't continue:
ERROR 15-01 01:00:36,783 - T_USER - org.pentaho.di.core.exception.KettleDatabaseException:
Error performing rollback on connection
Closed Connection
at org.pentaho.di.core.database.Database.rollback(Database.java:743)
at org.pentaho.di.core.database.Database.rollback(Database.java:717)
at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:384)
at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:117)
at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: Closed Connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:1142)
at org.pentaho.di.core.database.Database.rollback(Database.java:732)
... 5 more
大体出错的地方是有8个转换串行连接,转换里面都是2个表之间的同步操作。