org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: No row exists in table QRTZ_LOCKS for lock named: TRIGGER_ACCESS [See nested exception: java.sql.SQLException: No row exists in table QRTZ_LOCKS for lock named: TRIGGER_ACCESS]
at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.obtainLock(StdRowLockSemaphore.java:155)
at org.quartz.impl.jdbcjobstore.JobStoreTX.storeJob(JobStoreTX.java:205)
at org.quartz.core.QuartzScheduler.addJob(QuartzScheduler.java:687)
at org.quartz.impl.StdScheduler.addJob(StdScheduler.java:261)
at org.springframework.scheduling.quartz.SchedulerFactoryBean.addJobToScheduler(SchedulerFactoryBean.java:883)
Truncated. see log file for complete stacktrace
>
以上问题解决办法,需要添加:JOB_ACCESS,STATE_ACCESS,TRIGGER_ACCESS ,以上记录增加后重启weblogic即能解决问题。