问题解决Caused by: org.quartz.ObjectAlreadyExistsException: Unable to store Job

BugGavin_Qin

于 2025-03-28 15:01:45 发布

阅读量246

点赞数 2

文章标签： spring boot 后端

本文链接：https://blog.youkuaiyun.com/qq_37713521/article/details/146601829

版权

项目场景：

springboot 2.x 项目测试定时任务，项目使用quartz包来实现定时任务功能。

问题描述

本地测试时，启动代码时抛出异常

Caused by: org.quartz.ObjectAlreadyExistsException: Unable to store Job : 'DEFAULT.TASK_b0837ddf1931ecfb29c13a500e3b9bee', because one already exists with this identification.

从报错可以看出，定时任务的表中应该已经存在这条数据，导致有冲突。

解决方案：

删除对应表中的数据即可。

DELETE FROM QRTZ_CRON_TRIGGERS WHERE TRIGGER_NAME = 'TASK_b0837ddf1931ecfb29c13a500e3b9bee';
DELETE FROM QRTZ_TRIGGERS WHERE JOB_NAME = 'DEFAULT.TASK_b0837ddf1931ecfb29c13a500e3b9bee';
DELETE FROM QRTZ_JOB_DETAILS WHERE JOB_NAME = 'DEFAULT.TASK_b0837ddf1931ecfb29c13a500e3b9bee';