表找不到和获取数据错误

2025-04-10 21:13:05.504 | ERROR 5665 | QuartzScheduler_schedulerName-yuMac-Pro.local1744290083570_ClusterManager [TID: N/A] o.s.s.quartz.LocalDataSourceJobStore     | ClusterManager: Error managing cluster: Failure obtaining db row lock: Table 'dev_jeelowcode_master.QRTZ_LOCKS' doesn't exist


org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: Table 'dev_jeelowcode_master.QRTZ_LOCKS' doesn't exist

        at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:184)

        at org.quartz.impl.jdbcjobstore.DBSemaphore.obtainLock(DBSemaphore.java:113)

        at org.quartz.impl.jdbcjobstore.JobStoreSupport.doCheckin(JobStoreSupport.java:3335)

        at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:3935)

        at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.run(JobStoreSupport.java:3972)

Caused by: java.sql.SQLSyntaxErrorException: Table 'dev_jeelowcode_master.QRTZ_LOCKS' doesn't exist

        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)

        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)

        at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)

        at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972)

        at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:3241)

        at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeQuery(FilterEventAdapter.java:459)

        at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:3238)

        at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.executeQuery(PreparedStatementProxyImpl.java:175)

        at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:213)

        at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:123)

        ... 4 common frames omitted


2025-04-10 21:13:44.648 | ERROR 5665 | QuartzScheduler_schedulerName-yuMac-Pro.local1744290083570_MisfireHandler [TID: N/A] o.s.s.quartz.LocalDataSourceJobStore     | MisfireHandler: Error handling misfires: Database error recovering from misfires.


org.quartz.JobPersistenceException: Database error recovering from misfires.

        at org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3274)

        at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:4012)

        at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:4033)

Caused by: java.sql.SQLSyntaxErrorException: Table 'dev_jeelowcode_master.QRTZ_TRIGGERS' doesn't exist

        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)

        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)

        at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)

        at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972)

        at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:3241)

        at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeQuery(FilterEventAdapter.java:459)

        at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:3238)

        at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.executeQuery(PreparedStatementProxyImpl.java:175)

        at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:213)

        at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.countMisfiredTriggersInState(StdJDBCDelegate.java:393)

        at org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3253)

        ... 2 common frames omitted


评论区

超级管理员 2025-04-11 08:53

把数据库改为忽略大小写,或者改为mysql8.0+

回复