github-actions[bot] commented on issue #17766: URL: https://github.com/apache/dolphinscheduler/issues/17766#issuecomment-3615293665
### Search before asking - [x] I had searched in the [issues](https://github.com/apache/dolphinscheduler/issues?q=is%3Aissue) and found no similar issues. ### What happened 2025-12-05 10:16:04.249 [main] INFO Engine - { "content":[ { "reader":{ "name":"mysqlreader", "parameter":{ "username":"XXXX", "password":"*********************", "connection":[ { "querySql":[ "select now() as etl_time,id,name,age,create_time from temp_lp" ], "jdbcUrl":[ "jdbc:mysql://XXXXXXX:3306/cloudpivot?allowLoadLocalInfile=false&autoDeserialize=false&allowLocalInfile=false&allowUrlInLocalInfile=false" ] } ] } }, "writer":{ "name":"oraclewriter", "parameter":{ "username":"XXXX", "password":"*******", "column":[ "\"etl_time\"", "\"id\"", "\"name\"", "\"age\"", "\"create_time\"" ], "connection":[ { "table":[ "temp_lp" ], "jdbcUrl":"jdbc:oracle:thin:@//XXXXXX:1521/orcl" } ], "preSql":[ "truncate table temp_lp" ] } } } ], "setting":{ "speed":{ "channel":1, "record":1000 }, "errorLimit":{ "record":0, "percentage":0 } } } 2025-12-05 10:16:04.277 [main] INFO PerfTrace - PerfTrace traceId=job_-1, isEnable=false 2025-12-05 10:16:04.277 [main] INFO JobContainer - DataX jobContainer starts job. 2025-12-05 10:16:04.279 [main] INFO JobContainer - Set jobId = 0 Fri Dec 05 10:16:04 GMT+08:00 2025 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. [INFO] 2025-12-05 02:16:05.896 +0000 - -> 2025-12-05 10:16:05.493 [job-0] INFO OriginalConfPretreatmentUtil - Available jdbcUrl:jdbc:mysql://xxxxx:3306/cloudpivot?allowLoadLocalInfile=false&autoDeserialize=false&allowLocalInfile=false&allowUrlInLocalInfile=false&yearIsDateType=false&zeroDateTimeBehavior=convertToNull&tinyInt1isBit=false&rewriteBatchedStatements=true. [INFO] 2025-12-05 02:16:06.374 +0000 - process has exited. execute path:/tmp/dolphinscheduler/exec/process/dolphinscheduler/18311183213984/18543609727776_12/10018/10022, processId:37027 ,exitStatusCode:1 ,processWaitForStatus:true ,processExitValue:1 [INFO] 2025-12-05 02:16:06.379 +0000 - Send task execute result to master, the current task status: TaskExecutionStatus{code=6, desc='failure'} [INFO] 2025-12-05 02:16:06.380 +0000 - Remove the current task execute context from worker cache [INFO] 2025-12-05 02:16:06.380 +0000 - The current execute mode isn't develop mode, will clear the task execute file: /tmp/dolphinscheduler/exec/process/dolphinscheduler/18311183213984/18543609727776_12/10018/10022 [INFO] 2025-12-05 02:16:06.383 +0000 - Success clear the task execute file: /tmp/dolphinscheduler/exec/process/dolphinscheduler/18311183213984/18543609727776_12/10018/10022 [INFO] 2025-12-05 02:16:06.897 +0000 - -> 2025-12-05 10:16:06.266 [job-0] INFO OriginalConfPretreatmentUtil - table:[temp_lp] all columns:[ ETL_TIME,ID,NAME,AGE,CREATE_TIME ]. 2025-12-05 10:16:06.315 [job-0] ERROR JobContainer - Exception when job run com.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-01], Description:[获取表字段相关信息失败.]. - 获取表:temp_lp 的字段的元信息时失败. 请联系 DBA 核查该库、表信息. - java.sql.SQLSyntaxErrorException: ORA-00904: "create_time": 标识符无效 ### What you expected to happen It seems that the reason for adding escape characters to the writer column in JSON is due to "/" ### How to reproduce 问题：使用datax的时候没有用自定义的模板，使用ds数据源的方式进行同步 ### Anything else _No response_ ### Version 3.1.x ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
