github-actions[bot] commented on issue #17017: URL: https://github.com/apache/dolphinscheduler/issues/17017#issuecomment-2658736191
### Search before asking - [x] I had searched in the [issues](https://github.com/apache/dolphinscheduler/issues?q=is%3Aissue) and found no similar feature requirement. ### Description The official documentation introduces: Database: [PostgreSQL](https://www.postgresql.org/download/) (8.2.15+) My postgresql: postgres (PostgreSQL) 9.2.24 However, an error was reported during execution: [ERROR] 2025-02-14 17:16:19.894 +0800 o.a.d.a.e.ApiExceptionHandler:[47] - Meet en unknown exception: org.springframework.jdbc.BadSqlGrammarException: ### Error updating database. Cause: org.postgresql.util.PSQLException: Error: Syntax error in "ON" or near Location: 142 ### The error may exist in class path resource [org/apache/dolphinscheduler/dao/mapper/TriggerRelationMapper.xml] ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: INSERT INTO t_ds_trigger_relation (trigger_code, trigger_type, job_id, create_time, update_time) VALUES( ?,?,?,?,?) ON CONFLICT(trigger_type, job_id, trigger_code) DO UPDATE SET update_time = ?; ### Cause: org.postgresql.util.PSQLException: Error: Syntax error in "ON" or near Location: 142 ; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: Error: Syntax error in "ON" or near Location: 142 ### Documentation Links https://dolphinscheduler.apache.org/zh-cn/docs/3.2.2/guide/installation/pseudo-cluster ### Are you willing to submit a 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]
