我遇到的问题是，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 .kettledb.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
