Please answer some questions before submitting your issue. Thanks!
Which version of XXL-JOB do you using?
2.1.2
Expected behavior
调度失败,在调度中心打印了,sql报错日志。经修复之后。中心还在打印错误日志
于是中心重启,还是在打印旧调度的报错。
调度中心服务器重启之后,再起调度中心。还是疯狂打印旧代码的报错
于是把执行器都改名,再起调度中心。还是疯狂打印旧代码的报错
调度中心日志疯狂在刷,磁盘很快就满。伤心~~
代码都改了,还是报同一行错,怎么办?
部分错误信息:
parameterClasses......[Ljava.lang.Class;
16:42:06.569 logback [http-nio-8084-exec-2] ERROR c.x.job.admin.core.util.JacksonUtil - Unexpected character ('f' (code 102)): was expecting comma to separate Object entries
at [Source: [{"logId":324835,"logDateTim":1609317900017,"executeResult":{"code":500,"msg":"java.lang.reflect.InvocationTargetException\n\tat sun.reflect.GeneratedMethodAccessor260.invoke(Unknown Source)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:498)\n\tat com.xxl.job.core.handler.impl.MethodJobHandler.execute(MethodJobHandler.java:29)\n\tat com.xxl.job.core.thread.JobThread.run(JobThread.java:152)\nCaused by: org.springframework.jdbc.UncategorizedSQLException: \n### Error querying database. Cause: java.sql.SQLException: sql injection violation, syntax error: syntax error, expect RPAREN, actual GROUP pos 2263, line 41, column 34, token GROUP : select CO.LIFEX, CASE WHEN CO.BOOK_DATE IS NULL AND TO_CHAR(MLR.LEAVE_TIME, 'YYYY-MM-DD HH24:MI:SS') = '2099-12-31 00:00:00' THEN COR.CREATE_TIME\n WHEN CO.BOOK_DATE IS NULL AND TO_CHAR(MLR.LEAVE_TIME, 'YYYY-MM-DD HH24:MI:SS') != '2099-12-31 00:00:00' THEN MLR.LEAVE_TIME\n WHEN CO.BOOK_DATE IS NOT NULL THEN CO.LEAVE_TIME END "firstTime",\n LISTAGG(RD.LONGITUDE, ',') WITHIN GROUP (ORDER BY RD.LONGITUDE) "beginLongitude",\n LISTAGG(RD.LATITUDE, ',') WITHIN GROUP (ORDER BY RD.LATITUDE) "beginLatitude",
暂无答案!
目前还没有任何答案,快来回答吧!