连接数据库后报获取定时任务CronTrigger出现异常
| 版本：renren-security 3.2.0 |
开发环境：360 |
2018-11-14 12:59:22.899 WARN 10536 --- [ main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'scheduleJobController': Unsatisfied dependency expressed through field 'scheduleJobService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'scheduleJobService': Invocation of init method failed; nested exception is io.renren.common.exception.RRException: 获取定时任务CronTrigger出现异常
2018-11-14 12:59:22.899 INFO 10536 --- [ main] o.s.s.quartz.SchedulerFactoryBean : Shutting down Quartz Scheduler
2018-11-14 12:59:22.899 INFO 10536 --- [ main] org.quartz.core.QuartzScheduler : Scheduler RenrenScheduler_$_DESKTOP-6LAMNPF1542171562732 shutting down.
2018-11-14 12:59:22.899 INFO 10536 --- [ main] org.quartz.core.QuartzScheduler : Scheduler RenrenScheduler_$_DESKTOP-6LAMNPF1542171562732 paused.
2018-11-14 12:59:22.900 INFO 10536 --- [ main] org.quartz.core.QuartzScheduler : Scheduler RenrenScheduler_$_DESKTOP-6LAMNPF1542171562732 shutdown complete.
2018-11-14 12:59:22.925 INFO 10536 --- [ main] com.alibaba.druid.pool.DruidDataSource : {dataSource-1} closed
2018-11-14 12:59:22.928 INFO 10536 --- [ main] o.apache.catalina.core.StandardService : Stopping service [Tomcat]
-
2018-11-14
https://www.renren.io/detail/10297
-
2018-11-14
@Mark 看到那个答案了，不懂定时任务数据是哪些表内容，重新添加是重新添加数据吗？所以我试着把自己的数据库删掉，直接导入另一个机器上能运行成功的数据库，还是不行。。。
-
2018-11-14
@ovaclp 不能导数据，把qrtz开头的表删除，重新建
-
2018-11-14
@Mark 我试试，img[//cdn.renren.io/7e50c201811141700327642.PNG] ，是这些都要重建吗，包括最下面的俩不？
-
2018-11-14
@ovaclp 下面的不用
-
2018-11-14
@Mark 重新把表创建后的确成功运行起来项目了，目前看没啥问题，但是我创建的新表有三个表的外键约束无法创建，不知道会不会有什么影响？（我用的是Mysql 5.6）[pre]
已执行的 SQL 语句：Alter table `renren_security`.`qrtz_triggers`
add constraint `qrtz_triggers_ibfk_1` foreign key (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`)
references `renren_security`.`qrtz_job_details`(`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`)
错误号：1452错误信息：Cannot add or update a child row: a foreign key constraint fails
(`renren_security`.`#sql-21ec_1a`, CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`)
REFERENCES `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`))
已执行的 SQL 语句：Alter table `renren_security`.`qrtz_blob_triggers`
add constraint `qrtz_blob_triggers_ibfk_1` foreign key (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
references `renren_security`.`qrtz_triggers`(`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
错误号：1215错误信息：Cannot add foreign key constraint
已执行的 SQL 语句：Alter table `renren_security`.`qrtz_cron_triggers`
add constraint `qrtz_cron_triggers_ibfk_1` foreign key (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
references `renren_security`.`qrtz_triggers`(`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
错误号：1452错误信息：Cannot add or update a child row: a foreign key constraint fails
(`renren_security`.`#sql-21ec_1a`, CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `)
[/pre]
