kettle内存溢出错误解决
环境:
源端数据库:oracle 10G R2
目标端数据库:oracle 11G R2
kettle版本:5.0.1-stable
报错:
抽取大数据量表时,报错,日志信息如下:
2015/01/05 11:27:42 - Spoon - 转换已经打开. 2015/01/05 11:27:42 - Spoon - 正在打开转换 [TABLE_BWWN]... 2015/01/05 11:27:42 - Spoon - 开始执行转换. 2015/01/05 11:27:42 - TABLE_BWWN - 为了转换解除补丁开始 [TABLE_BWWN] 2015/01/05 11:27:44 - max.0 - Finished reading query, closing connection. 2015/01/05 11:27:44 - max.0 - 完成处理 (I=1, O=0, R=0, W=1, U=0, E=0 2015/01/05 12:25:08 - 插入 / 更新.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : UnexpectedError: 2015/01/05 12:25:08 - Spoon - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : 一个未预期的错误发生在Spoon: probable cause:在停止Spoon前,请先关闭其它spoon窗口! 2015/01/05 12:25:08 - Spoon - Java heap space 2015/01/05 12:25:08 - 插入 / 更新.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : java.lang.OutOfMemoryError: Java heap space 2015/01/05 12:25:08 - 插入 / 更新.0 - at oracle.jdbc.driver.OraclePreparedStatement.bindBytesAsStream(OraclePreparedStatement.java:6713) 2015/01/05 12:25:08 - 插入 / 更新.0 - at oracle.jdbc.driver.OraclePreparedStatement.setBytesInternal(OraclePreparedStatement.java:6700) 2015/01/05 12:25:08 - 插入 / 更新.0 - at oracle.jdbc.driver.OraclePreparedStatement.setBytes(OraclePreparedStatement.java:6660) 2015/01/05 12:25:08 - 插入 / 更新.0 - at oracle.jdbc.driver.OraclePreparedStatementWrapper.setBytes(OraclePreparedStatementWrapper.java:150) 2015/01/05 12:25:08 - 插入 / 更新.0 - at org.pentaho.di.core.row.value.ValueMetaBase.setPreparedStatementValue(ValueMetaBase.java:4704) 2015/01/05 12:25:08 - 插入 / 更新.0 - at org.pentaho.di.core.database.Database.setValue(Database.java:928) 2015/01/05 12:25:08 - 插入 / 更新.0 - at org.pentaho.di.core.database.Database.setValues(Database.java:943) 2015/01/05 12:25:08 - 插入 / 更新.0 - at org.pentaho.di.core.database.Database.setValuesInsert(Database.java:888) 2015/01/05 12:25:08 - 插入 / 更新.0 - at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.lookupValues(InsertUpdate.java:113) 2015/01/05 12:25:08 - 插入 / 更新.0 - at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.processRow(InsertUpdate.java:301) 2015/01/05 12:25:08 - 插入 / 更新.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60) 2015/01/05 12:25:08 - 插入 / 更新.0 - at java.lang.Thread.run(Unknown Source) 2015/01/05 12:25:08 - Spoon - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : java.lang.OutOfMemoryError: Java heap space 2015/01/05 12:25:08 - Spoon - at java.util.Arrays.copyOf(Unknown Source) 2015/01/05 12:25:08 - Spoon - at java.lang.StringCoding.safeTrim(Unknown Source) 2015/01/05 12:25:08 - Spoon - at java.lang.StringCoding.access$100(Unknown Source) 2015/01/05 12:25:08 - Spoon - at java.lang.StringCoding$StringDecoder.decode(Unknown Source) 2015/01/05 12:25:08 - Spoon - at java.lang.StringCoding.decode(Unknown Source) 2015/01/05 12:25:08 - Spoon - at java.lang.StringCoding.decode(Unknown Source) 2015/01/05 12:25:08 - Spoon - at java.lang.String.(Unknown Source) 2015/01/05 12:25:08 - Spoon - at java.lang.String. (Unknown Source) 2015/01/05 12:25:08 - Spoon - at org.pentaho.di.core.row.value.ValueMetaBase.convertBinaryStringToString(ValueMetaBase.java:1105) 2015/01/05 12:25:08 - Spoon - at o