Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

将xxl_job 后台表改为Oracle 数据库后,在GLUE(Shell)模式调用sh脚本报空指针 #2984

Closed
172151295 opened this issue Sep 21, 2022 · 2 comments

Comments

@172151295
Copy link

报错如下
2022-09-21_094856

2022-09-21 08:41:48 [com.xxl.job.core.thread.JobThread#run]-[133]-[xxl-job, JobThread-100000020-1663720896507]
----------- xxl-job job execute start -----------
----------- Param:null
2022-09-21 08:41:48 [com.xxl.job.core.handler.impl.ScriptJobHandler#execute]-[80]-[xxl-job, JobThread-100000020-1663720896507] ----------- script file:/data/applogs/xxl-job/jobhandler/gluesource/100000020_1663663162000.sh -----------
2022-09-21 08:41:48 [com.xxl.job.core.util.ScriptUtil#execToFile]-[112]-[xxl-job, JobThread-100000020-1663720896507] java.lang.NullPointerException
at java.lang.ProcessBuilder.start(ProcessBuilder.java:1012)
at java.lang.Runtime.exec(Runtime.java:620)
at java.lang.Runtime.exec(Runtime.java:485)
at com.xxl.job.core.util.ScriptUtil.execToFile(ScriptUtil.java:76)
at com.xxl.job.core.handler.impl.ScriptJobHandler.execute(ScriptJobHandler.java:81)
at com.xxl.job.core.thread.JobThread.run(JobThread.java:166)

2022-09-21 08:41:48 [com.xxl.job.core.thread.JobThread#run]-[179]-[xxl-job, JobThread-100000020-1663720896507]
----------- xxl-job job execute end(finish) -----------
----------- Result: handleCode=500, handleMsg = script exit value(-1) is failed
2022-09-21 08:41:48 [com.xxl.job.core.thread.TriggerCallbackThread#callbackLog]-[197]-[xxl-job, executor TriggerCallbackThread]
----------- xxl-job job callback finish.
在任务管理点击执行一次正常运.sh脚本 截图如下
2022-09-21_095056

哪位大佬直达如何修改

@172151295 172151295 changed the title 讲xxl_job 后台表改为Oracle 数据库后,在GLUE(Shell)模式调用sh脚本报空指针 将xxl_job 后台表改为Oracle 数据库后,在GLUE(Shell)模式调用sh脚本报空指针 Sep 21, 2022
@LockiJiang
Copy link
Contributor

某些数据库默认情况下会将空字符串保存为null,执行脚本任务时EXECUTOR_PARAM为空,导致空指针异常
修改https://github.com/xuxueli/xxl-job/blob/master/xxl-job-core/src/main/java/com/xxl/job/core/util/ScriptUtil.java
图片
WeiYe-Jing/datax-web#439

@xuxueli
Copy link
Owner

xuxueli commented Jan 11, 2025

可以参考 #154

@xuxueli xuxueli closed this as completed Jan 11, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants