You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@dolphinscheduler.apache.org by "XiaoZhiSnow (via GitHub)" <gi...@apache.org> on 2024/04/17 08:09:27 UTC
[I] [Bug] [masterserver] when reboot mysql , suffered java.sql.SQLIntegrityConstraintViolationException: Duplicate entry [dolphinscheduler]
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: commits-unsubscribe@dolphinscheduler.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug] [masterserver] when reboot mysql , suffered java.sql.SQLIntegrityConstraintViolationException: Duplicate entry [dolphinscheduler]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] closed issue #15863: [Bug] [masterserver] when reboot mysql , suffered java.sql.SQLIntegrityConstraintViolationException: Duplicate entry
URL: https://github.com/apache/dolphinscheduler/issues/15863
--
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: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug] [masterserver] when reboot mysql , suffered java.sql.SQLIntegrityConstraintViolationException: Duplicate entry [dolphinscheduler]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #15863:
URL: https://github.com/apache/dolphinscheduler/issues/15863#issuecomment-2131783085
This issue has been closed because it has not received response for too long time. You could reopen it if you encountered similar problems in the future.
--
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: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug] [masterserver] when reboot mysql , suffered java.sql.SQLIntegrityConstraintViolationException: Duplicate entry [dolphinscheduler]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #15863:
URL: https://github.com/apache/dolphinscheduler/issues/15863#issuecomment-2118521283
This issue has been automatically marked as stale because it has not had recent activity for 30 days. It will be closed in next 7 days if no further activity occurs.
--
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: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org