fastdb java_项目启动失败 · Issue #I1HFJR · 周周/J2eeFAST - Gitee.com

麹浩瀚

2023-12-01

项目启动异常:

java.lang.IllegalStateException: Failed to execute ApplicationRunner

at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:778)

at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:765)

at org.springframework.boot.SpringApplication.run(SpringApplication.java:322)

at com.j2eefast.FastApplication.main(FastApplication.java:32)

Caused by: com.j2eefast.common.core.exception.RxcException: 创建定时任务失败

at com.j2eefast.framework.quartz.utils.ScheduleUtils.createScheduleJob(ScheduleUtils.java:81)

at com.j2eefast.framework.config.BaseInitialze.run(BaseInitialze.java:79)

at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:775)

... 3 common frames omitted

Caused by: org.quartz.JobPersistenceException: Couldn't store trigger 'DEFAULT.TASK_1239107312446103553' for 'DEFAULT.TASK_1239107312446103553' job:Cannot add or update a child row: a foreign key constraint fails (fastdb.QRTZ_TRIGGERS, CONSTRAINT qrtz_triggers_ibfk_1 FOREIGN KEY (SCHED_NAME, JOB_NAME, JOB_GROUP) REFERENCES qrtz_job_details (SCHED_NAME, JOB_NAME, JOB_GROUP))

at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSupport.java:1228)

at org.quartz.impl.jdbcjobstore.JobStoreSupport$2.executeVoid(JobStoreSupport.java:1068)

at org.quartz.impl.jdbcjobstore.JobStoreSupport$VoidTransactionCallback.execute(JobStoreSupport.java:3780)

at org.quartz.impl.jdbcjobstore.JobStoreSupport$VoidTransactionCallback.execute(JobStoreSupport.java:3778)

at org.quartz.impl.jdbcjobstore.JobStoreCMT.executeInLock(JobStoreCMT.java:245)

at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJobAndTrigger(JobStoreSupport.java:1063)

at org.quartz.core.QuartzScheduler.scheduleJob(QuartzScheduler.java:855)

at org.quartz.impl.StdScheduler.scheduleJob(StdScheduler.java:249)

at com.j2eefast.framework.quartz.utils.ScheduleUtils.createScheduleJob(ScheduleUtils.java:74)

... 5 common frames omitted

Caused by: java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (fastdb.QRTZ_TRIGGERS, CONSTRAINT qrtz_triggers_ibfk_1 FOREIGN KEY (SCHED_NAME, JOB_NAME, JOB_GROUP) REFERENCES qrtz_job_details (SCHED_NAME, JOB_NAME, JOB_GROUP))

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

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

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

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

at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1116)

at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1066)

at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1396)

at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1051)

at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:3253)

at com.alibaba.druid.filter.FilterAdapter.preparedStatement_executeUpdate(FilterAdapter.java:1092)

at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeUpdate(FilterEventAdapter.java:491)

at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:3251)

at com.alibaba.druid.wall.WallFilter.preparedStatement_executeUpdate(WallFilter.java:662)

at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:3251)

at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.executeUpdate(PreparedStatementProxyImpl.java:194)

at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeUpdate(DruidPooledPreparedStatement.java:255)

at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.insertTrigger(StdJDBCDelegate.java:1093)

at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSupport.java:1225)

... 13 common frames omitted

2020-05-17 20:12:04.486 INFO 12116 --- [[FastScheduler]] o.s.s.quartz.SchedulerFactoryBean : Starting Quartz Scheduler now, after delay of 5 seconds

Exception in thread "Quartz Scheduler [FastScheduler]" org.springframework.scheduling.SchedulingException: Could not start Quartz Scheduler after delay; nested exception is org.quartz.SchedulerException: The Scheduler cannot be restarted after shutdown() has been called.

at org.springframework.scheduling.quartz.SchedulerFactoryBean$1.run(SchedulerFactoryBean.java:754)

Caused by: org.quartz.SchedulerException: The Scheduler cannot be restarted after shutdown() has been called.

at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:529)

at org.quartz.impl.StdScheduler.start(StdScheduler.java:142)

at org.springframework.scheduling.quartz.SchedulerFactoryBean$1.run(SchedulerFactoryBean.java:751)

删除sys_job的默认记录后，启动成功但是浏览器访问时报404，启动中间有报错：

获取数据异常!

java.lang.NullPointerException: null

at java.util.Properties$LineReader.readLine(Properties.java:434)

at java.util.Properties.load0(Properties.java:353)

at java.util.Properties.load(Properties.java:341)

at com.j2eefast.common.db.collector.SqlSessionFactoryCreator.createSqlSessionFactory(SqlSessionFactoryCreator.java:192)

at com.j2eefast.common.core.config.SqlSessionFactoryConfig.sqlSessionfFowableFactoryPrimary(SqlSessionFactoryConfig.java:51)

at com.j2eefast.common.core.config.SqlSessionFactoryConfig$$EnhancerBySpringCGLIB$$ce5ab8c8.CGLIB$sqlSessionfFowableFactoryPrimary$0()

at com.j2eefast.common.core.config.SqlSessionFactoryConfig$$EnhancerBySpringCGLIB$$ce5ab8c8$$FastClassBySpringCGLIB$$a3680ed1.invoke()

at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:244)

at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:331)

at com.j2eefast.common.core.config.SqlSessionFactoryConfig$$EnhancerBySpringCGLIB$$ce5ab8c8.sqlSessionfFowableFactoryPrimary()

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:498)

at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:154)

at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:651)

at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:636)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1338)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1177)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:557)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517)

at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323)

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)

at com.j2eefast.common.core.utils.SpringUtil.getBean(SpringUtil.java:31)

at com.j2eefast.common.core.config.SqlSessionFactoryConfig.fastSqlSessionTemplate(SqlSessionFactoryConfig.java:68)

at com.j2eefast.common.core.config.SqlSessionFactoryConfig$$EnhancerBySpringCGLIB$$ce5ab8c8.CGLIB$fastSqlSessionTemplate$1()

at com.j2eefast.common.core.config.SqlSessionFactoryConfig$$EnhancerBySpringCGLIB$$ce5ab8c8$$FastClassBySpringCGLIB$$a3680ed1.invoke()

at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:244)

at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:331)

at com.j2eefast.common.core.config.SqlSessionFactoryConfig$$EnhancerBySpringCGLIB$$ce5ab8c8.fastSqlSessionTemplate()