第一次运行林风社交论坛linfeng-commuity项目,出现定时任务Quartz报错如图,报错如下图:

解决办法就是在数据库中清理quartz表,删除表数据即可。
直接复制如下sql在MySQL中执行,选择“大写的方式”或“小写的方式”中的一种即可,然后重启后端服务即可:

//大写的方式
DELETE FROM `QRTZ_LOCKS`;
DELETE FROM `QRTZ_CALENDARS`;
DELETE FROM `QRTZ_FIRED_TRIGGERS`;
DELETE FROM `QRTZ_PAUSED_TRIGGER_GRPS`;
DELETE FROM `QRTZ_SCHEDULER_STATE`;
DELETE FROM `QRTZ_BLOB_TRIGGERS`;
DELETE FROM `QRTZ_CRON_TRIGGERS`;
DELETE FROM `QRTZ_SIMPLE_TRIGGERS`;
DELETE FROM `QRTZ_SIMPROP_TRIGGERS`;
DELETE FROM `QRTZ_TRIGGERS`;
DELETE FROM `QRTZ_JOB_DETAILS`;
//小写的方式
delete from `qrtz_locks`;
delete from `qrtz_calendars`;
delete from `qrtz_fired_triggers`;
delete from `qrtz_paused_trigger_grps`;
delete from `qrtz_scheduler_state`;
delete from `qrtz_blob_triggers`;
delete from `qrtz_cron_triggers`;
delete from `qrtz_simple_triggers`;
delete from `qrtz_simprop_triggers`;
delete from `qrtz_triggers`;
delete from `qrtz_job_details`;


注意:如果你的数据库区分大小写,那么需要用“小写的方式”的sql执行~ 否则执行会报错。

最后,重新启动后端即可。

Logo

腾讯云面向开发者汇聚海量精品云计算使用和开发经验,营造开放的云计算技术生态圈。

更多推荐