我遇到的问题是,kettle执行较复杂脚本时秒退。之后打不开的问题
具体可以在运行日志中找到问题
2021/11/17 16:42:16 - ERROR (version 9.1.0.0-324, build 9.1.0.0-324 from 2020-09-07 05.09.05 by buildguy) : Error starting Spoon shell
2021/11/17 16:42:16 - ERROR (version 9.1.0.0-324, build 9.1.0.0-324 from 2020-09-07 05.09.05 by buildguy) : java.lang.RuntimeException: Unable to create the database cache:
2021/11/17 16:42:16 -
2021/11/17 16:42:16 - Couldn't read the database cache
2021/11/17 16:42:16 -
2021/11/17 16:42:16 -
2021/11/17 16:42:16 - : Unable to read row metadata from input stream
2021/11/17 16:42:16 -
2021/11/17 16:42:16 - Unable to locate value meta plugin of type (id) 131072
2021/11/17 16:42:16 -
2021/11/17 16:42:16 -
2021/11/17 16:42:16 -
2021/11/17 16:42:16 - Unable to locate value meta plugin of type (id) 131072
2021/11/17 16:42:16 -
2021/11/17 16:42:16 -
2021/11/17 16:42:16 -
2021/11/17 16:42:16 -
2021/11/17 16:42:16 -
2021/11/17 16:42:16 - : Unable to read row metadata from input stream
Couldn't read the database cache
解决方法:删除本地kettle缓存文件
C:\Users\ .kettle\db.cache
删除对应目录下,相似文件即可
一般情况下,有这三种解决方式
一,JAVA环境配置的问题
二,JAVA版本问题,一般需要jdk1.8
三,通过修改spoon.bat的内存设置
if "%PENTAHO_DI_JAVA_OPTIONS%"=="" set PENTAHO_DI_JAVA_OPTIONS="-Xms2058m" "-Xmx1024m" "-XX:MaxPermSize=256m"
改为
if "%PENTAHO_DI_JAVA_OPTIONS%"=="" set PENTAHO_DI_JAVA_OPTIONS="-Xms512m" "-Xmx512m" "-XX:MaxPermSize=256m"
修改之后保存,重新启动spoon.bat