回复第29楼 表里有这个任务吗

有这个数据，您这么一说我想起一个事情来，就时在启动项目的时候有统计相关的报错。这是报错的相关信息：

2021-04-08 09:14:40.386 [main] INFO  org.springframework.web.context.ContextLoader - Root WebApplicationContext: initialization completed in 3416 ms 
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: Table 'kjcxds2.QRTZ_LOCKS' doesn't exist [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'kjcxds2.QRTZ_LOCKS' doesn't exist]]
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: Table 'kjcxds2.QRTZ_LOCKS' doesn't exist [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'kjcxds2.QRTZ_LOCKS' doesn't exist]]
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: Table 'kjcxds2.QRTZ_LOCKS' doesn't exist [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'kjcxds2.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.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3842)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:839)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:695)
... 3 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'kjcxds2.QRTZ_LOCKS' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2495)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2011)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:96)
... 7 more
2021-04-08 09:14:48.499 [main] INFO  o.s.scheduling.quartz.SchedulerFactoryBean - Loading Quartz config from [class path resource [quartz.properties]] 
2021-04-08 09:14:48.499 [main] INFO  org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 
2021-04-08 09:14:48.500 [main] INFO  org.quartz.simpl.SimpleThreadPool - Job execution threads will use class loader of thread: main 
2021-04-08 09:14:48.541 [main] INFO  org.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 
2021-04-08 09:14:48.541 [main] INFO  org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.0 created. 
2021-04-08 09:14:48.541 [main] INFO  o.s.scheduling.quartz.LocalDataSourceJobStore - Using db table-based data access locking (synchronization). 
2021-04-08 09:14:48.542 [main] INFO  o.s.scheduling.quartz.LocalDataSourceJobStore - JobStoreCMT initialized. 
2021-04-08 09:14:48.542 [main] INFO  org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.0) 'schedulerFactoryBean' with instanceId 'NON_CLUSTERED'
  Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
  NOT STARTED.
  Currently in standby mode.
  Number of jobs executed: 0
  Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 50 threads.
  Using job-store 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which supports persistence. and is not clustered.
 
2021-04-08 09:14:48.542 [main] INFO  org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'schedulerFactoryBean' initialized from an externally provided properties instance. 
2021-04-08 09:14:48.542 [main] INFO  org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.0 
2021-04-08 09:14:48.542 [main] INFO  org.quartz.core.QuartzScheduler - JobFactory set to: com.jeecms.component.QuartzConfiguration$AutowiringSpringBeanJobFactory@30b6cd26 
2021-04-08 09:14:48*7 [pool-1-thread-2] ERROR com.jeecms.system.service.impl.SysJobServiceImpl - 生成数据统计任务启动失败, time:Thu Apr 08 09:14:48 CST 2021 
2021-04-08 09:14:48*7 [pool-1-thread-2] ERROR com.jeecms.system.service.impl.SysJobServiceImpl - 生成日志统计任务启动失败, time:Thu Apr 08 09:14:48 CST 2021 
2021-04-08 09:14:48*8 [pool-1-thread-2] ERROR com.jeecms.system.service.impl.SysJobServiceImpl - 生成日志告警任务启动失败, time:Thu Apr 08 09:14:48 CST 2021 
2021-04-08 09:14:48*8 [pool-1-thread-2] ERROR com.jeecms.system.service.impl.SysJobServiceImpl - 生成日志预警任务启动失败, time:Thu Apr 08 09:14:48 CST 2021 
2021-04-08 09:14:48*9 [pool-1-thread-2] ERROR com.jeecms.system.service.impl.SysJobServiceImpl - 粉丝统计任务启动失败, time:Thu Apr 08 09:14:48 CST 2021 
2021-04-08 09:14:48.560 [pool-1-thread-2] ERROR com.jeecms.system.service.impl.SysJobServiceImpl - 内容统计任务启动失败, time:Thu Apr 08 09:14:48 CST 2021 
2021-04-08 09:14:48.560 [pool-1-thread-2] ERROR com.jeecms.system.service.impl.SysJobServiceImpl - 定时清除日志, time:Thu Apr 08 09:14:48 CST 2021 
2021-04-08 09:14:54.953 [main] ERROR com.jeecms.common.util.office.OpenOfficeConverter - openoffic 启动失败: officeHome doesn't exist or is not a directory: D:\openoffice4\ 

好的，您报错信息已反馈

回复第32楼
您好，你那少了表，您现在用的是开源的还是我们购买了授权的？

您把您的表展开截个图

您好，我看了下提示报错的表示有的，这是我的表的截图。我用的是开源的

回复第36楼
发一张这样的图

好的

回复第38楼
您好，已反馈哈，您稍等

好的，谢谢