XiaoZhiSnow opened a new issue, #15863: URL: https://github.com/apache/dolphinscheduler/issues/15863
### 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 when reboot mysql which dolphinscheduler used, I run any process, i did not find the process instance, then I checked the master server log , I find these error message: [ERROR] 2024-04-17 15:54:22.168 +0800 o.a.d.s.m.r.MasterSchedulerBootstrap:[166] - Master schedule workflow error org.springframework.dao.DuplicateKeyException: ### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '5' for key 'PRIMARY' ### The error may exist in org/apache/dolphinscheduler/dao/mapper/ErrorCommandMapper.java (best guess) ### The error may involve org.apache.dolphinscheduler.dao.mapper.ErrorCommandMapper.insert-Inline ### The error occurred while setting parameters ### SQL: INSERT INTO t_ds_error_command ( id, command_type, process_definition_code, executor_id, command_param, task_depend_type, failure_strategy, warning_type, start_time, process_instance_priority, update_time, message, environment_code, dry_run, test_flag ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ### Cause: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '5' for key 'PRIMARY' ; Duplicate entry '5' for key 'PRIMARY'; nested exception is java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '5' for key 'PRIMARY' at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:247) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70) at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) at com.sun.proxy.$Proxy136.insert(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:59) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89) at com.sun.proxy.$Proxy167.insert(Unknown Source) at org.apache.dolphinscheduler.service.command.CommandServiceImpl.moveToErrorCommand(CommandServiceImpl.java:85) at org.apache.dolphinscheduler.service.command.CommandServiceImpl$$FastClassBySpringCGLIB$$299af041.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97) I have suffered these error messages manty times . when reboot mysql ,it will appear again. ### What you expected to happen when reboot mysql which ds used , dolphinscheduler should run normally. ### How to reproduce reboot the mysql which ds used, and you will suffer it ### Anything else nothing ### Version 3.2.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]
