Caused by: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: Table 'ry.qrtz_locks' doesn't exist
at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:157)
at org.quartz.impl.jdbcjobstore.DBSemaphore.obtainLock(DBSemaphore.java:113)
at org.quartz.impl.jdbcjobstore.JobStoreCMT.executeInLock(JobStoreCMT.java:238)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.clearAllSchedulingData(JobStoreSupport.java:2002)
at org.quartz.core.QuartzScheduler.clear(QuartzScheduler.java:1541)
at org.quartz.impl.StdScheduler.clear(StdScheduler.java:239)
at com.ruoyi.project.monitor.job.service.JobServiceImpl.init(JobServiceImpl.java:41)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)

sql下面还有一个quartz.sql文件,需要执行,执行后的结果

再次重启,问题解决

展开阅读全文