第一次运行林风社交论坛开源版linfengcommunity出现Quartz报错解决方案
·
第一次运行林风社交论坛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执行~ 否则执行会报错。
最后,重新启动后端即可。
-
林风社交论坛开源版下载地址Gitee: https://gitee.com/virus010101/linfeng-community
更多推荐
所有评论(0)