jeecms x是不是不支持mysql8? - JEECMS官方论坛|开源java cms,jsp cms,jsp bbs

13951821405

级别: 贡士

UID: 81576
积分:456 加为好友
威望: 0 精华: 0
主题:38 回复:141
注册时间:2015-10-29
在线时长:0

1# 发表于:2019-10-17 14:03:47 IP:117.71.*.*

修改org.quartz.jobStore.class 后，启动一直报mysql的错误

Exception in thread "Quartz Scheduler [schedulerFactoryBean]" org.springframework.scheduling.SchedulingException: Could not start Quartz Scheduler after delay; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(UPDLOCK,ROWLOCK) WHERE SCHED_NAME = 'schedulerFactoryBean' AND LOCK_NAME = 'TRI' at line 1 [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(UPDLOCK,ROWLOCK) WHERE SCHED_NAME = 'schedulerFactoryBean' AND LOCK_NAME = 'TRI' at line 1]]
at org.springframework.scheduling.quartz.SchedulerFactoryBean$1.run(SchedulerFactoryBean.java:733)
Caused by: org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(UPDLOCK,ROWLOCK) WHERE SCHED_NAME = 'schedulerFactoryBean' AND LOCK_NAME = 'TRI' at line 1 [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(UPDLOCK,ROWLOCK) WHERE SCHED_NAME = 'schedulerFactoryBean' AND LOCK_NAME = 'TRI' at line 1]]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:697)
at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:539)
at org.quartz.impl.StdScheduler.start(StdScheduler.java:142)
at org.springframework.scheduling.quartz.SchedulerFactoryBean$1.run(SchedulerFactoryBean.java:730)
Caused by: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(UPDLOCK,ROWLOCK) WHERE SCHED_NAME = 'schedulerFactoryBean' AND LOCK_NAME = 'TRI' at line 1 [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(UPDLOCK,ROWLOCK) WHERE SCHED_NAME = 'schedulerFactoryBean' AND LOCK_NAME = 'TRI' at line 1]
at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:157)