error:java.lang.RuntimeException: org.springframework.jdbc.BadSqlGrammarException: Unknown column ‘n

报错表明在执行Java程序时遇到了SpringJDBC的异常,具体是由于尝试插入的数据包含字段national_pqi,而数据库表中不存在这个字段。解决方案包括检查实体类与数据库表结构的对应关系,删除实体中的多余字段或在数据库中添加缺失的字段。

【errror:】java.lang.RuntimeException: org.springframework.jdbc.BadSqlGrammarException: com.ectit.mapper.business.RiaDProjectSchemeMapper.insert (batch index #1) failed. Cause: java.sql.BatchUpdateException: Unknown column ‘national_pqi’ in ‘field list’
; bad SQL grammar []; nested exception is java.sql.BatchUpdateException: Unknown column ‘national_pqi’ in ‘field list’
org.springframework.jdbc.BadSqlGrammarException: com.ectit.mapper.business.RiaDProjectSchemeMapper.insert (batch index #1) failed. Cause: java.sql.BatchUpdateException: Unknown column ‘national_pqi’ in ‘field list’
; bad SQL grammar []; nested exception is java.sql.BatchUpdateException: Unknown column ‘national_pqi’ in ‘field list’

在这里插入图片描述

报错信息说的很清楚:在数据库表中没有national_pqi这个字段。
解决方案:在实体中删除该字段/在数据库表中添加该字段。

1.通常情况下,先检查实体字段与数据库字段是否匹配的上。

2025-10-14T15:14:45.562+08:00 DEBUG 23396 --- [jnpf-workflow] [ main] o.s.jdbc.datasource.DataSourceUtils : Fetching JDBC Connection from DataSource 2025-10-14T15:14:45.596+08:00 DEBUG 23396 --- [jnpf-workflow] [ main] java.lang.ProcessBuilder : ProcessBuilder.start(): pid: 12064, dir: null, cmd: "hostname" java.lang.RuntimeException: ProcessBuilder.start() debug at java.base/java.lang.ProcessBuilder.start(ProcessBuilder.java:1147) at java.base/java.lang.ProcessBuilder.start(ProcessBuilder.java:1089) at java.base/java.lang.Runtime.exec(Runtime.java:681) at java.base/java.lang.Runtime.exec(Runtime.java:491) at java.base/java.lang.Runtime.exec(Runtime.java:366) at dm.jdbc.util.DriverUtil.getHostMchName(SourceFile:168) at dm.jdbc.internal.desc.Const.<clinit>(SourceFile:74) at dm.jdbc.driver.Configuration.<clinit>(SourceFile:196) at dm.jdbc.driver.DmdbDataSource.getConnection(SourceFile:68) at dm.jdbc.driver.DmdbDataSource.getConnection(SourceFile:51) at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:160) at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:118) at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:247) at jdk.proxy2/jdk.proxy2.$Proxy92.getMetaData(Unknown Source) at org.flowable.common.engine.impl.AbstractEngineConfiguration.initDatabaseType(AbstractEngineConfiguration.java:501) at org.flowable.common.engine.impl.AbstractEngineConfiguration.initDataSource(AbstractEngineConfiguration.java:493) at org.flowable.app.engine.AppEngineConfiguration.init(AppEngineConfiguration.java:213) at org.flowable.app.engine.AppEngineConfiguration.buildAppEngine(AppEngineConfiguration.java:195) at org.flowable.app.spring.SpringAppEngineConfiguration.buildAppEngine(SpringAppEngineConfiguration.java:66) at org.flowable.app.spring.AppEngineFactoryBean.getObject(AppEngineFactoryBean.java:58) at org.flowable.app.spring.AppEngineFactoryBean.getObject(AppEngineFactoryBean.java:31) at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:182) at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:124) at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1867) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.getObjectForBeanInstance(AbstractAutowireCapableBeanFactory.java:1296) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:347) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:254) at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1443) at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1353) at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:904) at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:782) at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:542) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1355) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1185) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:562) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:337) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:335) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:254) at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1443) at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1353) at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:904) at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:782) at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:542) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1355) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1185) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:562) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:337) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:335) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:254) at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1443) at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1353) at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:904) at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:782) at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:237) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1375) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1212) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:562) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:337) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:335) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:254) at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1443) at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1353) at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:904) at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:782) at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:237) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1375) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1212) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:562) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:337) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:335) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:975) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:971) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:625) at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146) at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:754) at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:456) at org.springframework.boot.SpringApplication.run(SpringApplication.java:335) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1363) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1352) at jnpf.JnpfFlowableApplication.main(JnpfFlowableApplication.java:16) 2025-10-14T15:14:47.584+08:00 INFO 23396 --- [jnpf-workflow] [ main] liquibase.database : Could not set remarks reporting on OracleDatabase: jdk.proxy2.$Proxy92.setRemarksReporting(boolean) 2025-10-14T15:14:47.590+08:00 INFO 23396 --- [jnpf-workflow] [ main] liquibase.database : Could not set check compatibility mode on OracleDatabase, assuming not running in any sort of compatibility mode: Cannot read from DBMS_UTILITY.DB_VERSION: -2193 第1 行附近出现错误: 无效的方法名[DB_VERSION] 2025-10-14T15:14:47.598+08:00 DEBUG 23396 --- [jnpf-workflow] [ main] liquibase.configuration : No configuration value for liquibase.ddlLockTimeout aka ddl_lock_timeout aka liquibase.ddlLockTimeout aka liquibase.ddl_lock_timeout found 2025-10-14T15:14:48.079+08:00 INFO 23396 --- [jnpf-workflow] [ main] liquibase.command : Logging exception. ERROR: Exception Primary Class: NullPointerException ERROR: Exception Primary Reason: Cannot invoke "liquibase.structure.core.Column.getType()" because the return value of "liquibase.structure.core.Table.getColumn(String)" is null ERROR: Exception Primary Source: Oracle 8.1.3.100 2025-10-14T15:14:48.079+08:00 INFO 23396 --- [jnpf-workflow] [ main] liquibase.command : Command execution complete 2025-10-14T15:14:48.080+08:00 DEBUG 23396 --- [jnpf-workflow] [ main] o.s.jdbc.support.JdbcTransactionManager : Participating in existing transaction 2025-10-14T15:14:48.080+08:00 DEBUG 23396 --- [jnpf-workflow] [ main] o.s.t.support.TransactionTemplate : Initiating transaction rollback on application exception org.flowable.common.engine.api.FlowableException: Error initialising eventregistry data model Caused by: org.flowable.common.engine.api.FlowableException: Error updating eventregistry engine tables ... 94 common frames omitted Caused by: liquibase.exception.CommandExecutionException: java.lang.NullPointerException: Cannot invoke "liquibase.structure.core.Column.getType()" because the return value of "liquibase.structure.core.Table.getColumn(String)" is null at liquibase.command.CommandScope.execute(CommandScope.java:257) at liquibase.Liquibase.lambda$update$0(Liquibase.java:245) ... 101 common frames omitted Caused by: java.lang.NullPointerException: Cannot invoke "liquibase.structure.core.Column.getType()" because the return value of "liquibase.structure.core.Table.getColumn(String)" is null at liquibase.changelog.StandardChangeLogHistoryService.init(StandardChangeLogHistoryService.java:130) at liquibase.command.core.helpers.DatabaseChangelogCommandStep.checkLiquibaseTables(DatabaseChangelogCommandStep.java:141) at liquibase.command.core.helpers.DatabaseChangelogCommandStep.run(DatabaseChangelogCommandStep.java:91) at liquibase.command.CommandScope.execute(CommandScope.java:219) No persisted sessions to unload 2025-10-14T15:14:48.091+08:00 DEBUG 23396 --- [jnpf-workflow] [ main] o.apache.catalina.loader.WebappLoader : Stopping this Loader 2025-10-14T15:14:48.112+08:00 DEBUG 23396 --- [jnpf-workflow] [ main] .s.b.a.l.ConditionEvaluationReportLogger : ============================ CONDITIONS EVALUATION REPORT ============================ Positive matches: ----------------- AopAutoConfiguration matched: - @ConditionalOnProperty (spring.aop.auto=true) matched (OnPropertyCondition) AopAutoConfiguration.ClassProxyingConfiguration matched: - @ConditionalOnMissingClass did not find unwanted class 'org.aspectj.weaver.Advice' (OnClassCondition) - @ConditionalOnProperty (spring.aop.proxy-target-class=true) matched (OnPropertyCondition) AppEngineAutoConfiguration matched: - @ConditionalOnClass found required classes 'org.flowable.app.engine.AppEngine', 'org.flowable.app.spring.SpringA - @ConditionalOnClass did not find required class 'jakarta.transaction.TransactionManager' (OnClassCondition) Exclusions: ----------- None Unconditional classes: ---------------------- org.springframework.boot.autoconfigure.context.ConfigurationPropertiesAutoConfiguration org.springframework.boot.autoconfigure.ssl.SslAutoConfiguration org.springframework.boot.autoconfigure.context.PropertyPlaceholderAutoConfiguration org.springframework.boot.autoconfigure.context.LifecycleAutoConfiguration cn.hutool.extra.spring.SpringUtil org.springframework.boot.autoconfigure.availability.ApplicationAvailabilityAutoConfiguration org.springframework.boot.autoconfigure.info.ProjectInfoAutoConfiguration 2025-10-14T15:14:48.129+08:00 ERROR 23396 --- [jnpf-workflow] [ main] o.s.boot.SpringApplication : Application run failed org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'definitionController' defined in file [E:\code\jnpf-workflow\jnpf-workflow-admin\target\classes\jnpf\workflow\admin\controller\DefinitionController.class]: Unsatisfied dependency expressed through constructor parameter 0: Error creating bean with name 'definitionServiceImpl' defined in file [E:\code\jnpf-workflow-core\jnpf-workflow-flowable\target\classes\jnpf\workflow\flowable\service\DefinitionServiceImpl.class]: Unsatisfied dependency expressed through constructor parameter 0: Error creating bean with name 'repositoryServiceBean' defined in class path resource [org/flowable/spring/boot/ProcessEngineServicesAutoConfiguration.class]: Unsatisfied dependency expressed through method 'repositoryServiceBean' parameter 0: Error creating bean with name 'processEngine' defined in class path resource [org/flowable/spring/boot/ProcessEngineServicesAutoConfiguration$AlreadyInitializedAppEngineConfiguration.class]: Unsatisfied dependency expressed through method 'processEngine' parameter 0: Error creating bean with name 'flowableAppEngine': FactoryBean threw exception on object creation at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:795) at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:237) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1375) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1212) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:562) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:337) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:335) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:975) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:971) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:625) at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146) at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:754) at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:456) at org.springframework.boot.SpringApplication.run(SpringApplication.java:335) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1363) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1352) at jnpf.JnpfFlowableApplication.main(JnpfFlowableApplication.java:16) Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'definitionServiceImpl' defined in file [E:\code\jnpf-workflow-core\jnpf-workflow-flowable\target\classes\jnpf\workflow\flowable\service\DefinitionServiceImpl.class]: Unsatisfied dependency expressed through constructor parameter 0: Error creating bean with name 'repositoryServiceBean' defined in class path resource [org/flowable/spring/boot/ProcessEngineServicesAutoConfiguration.class]: Unsatisfied dependency expressed through method 'repositoryServiceBean' parameter 0: Error creating bean with name 'processEngine' defined in class path resource [org/flowable/spring/boot/ProcessEngineServicesAutoConfiguration$AlreadyInitializedAppEngineConfiguration.class]: Unsatisfied dependency expressed through method 'processEngine' parameter 0: Error creating bean with name 'flowableAppEngine': FactoryBean threw exception on object creation at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:795) at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:237) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1375) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1212) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:562) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:337) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:335) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:254) at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1443) at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1353) at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:904) at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:782) ... 19 common frames omitted Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'repositoryServiceBean' defined in class path resource [org/flowable/spring/boot/ProcessEngineServicesAutoConfiguration.class]: Unsatisfied dependency expressed through method 'repositoryServiceBean' parameter 0: Error creating bean with name 'processEngine' defined in class path resource [org/flowable/spring/boot/ProcessEngineServicesAutoConfiguration$AlreadyInitializedAppEngineConfiguration.class]: Unsatisfied dependency expressed through method 'processEngine' parameter 0: Error creating bean with name 'flowableAppEngine': FactoryBean threw exception on object creation at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:795) at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:542) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1355) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1185) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:562) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:337) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:335) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:254) at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1443) at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1353) at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:904) at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:782) ... 33 common frames omitted Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'processEngine' defined in class path resource [org/flowable/spring/boot/ProcessEngineServicesAutoConfiguration$AlreadyInitializedAppEngineConfiguration.class]: Unsatisfied dependency expressed through method 'processEngine' parameter 0: Error creating bean with name 'flowableAppEngine': FactoryBean threw exception on object creation at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:795) at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:542) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1355) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1185) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:562) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:337) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:335) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:254) at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1443) at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1353) at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:904) at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:782) ... 47 common frames omitted Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flowableAppEngine': FactoryBean threw exception on object creation at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:188) at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:124) at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1867) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.getObjectForBeanInstance(AbstractAutowireCapableBeanFactory.java:1296) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:347) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:254) at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1443) at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1353) at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:904) at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:782) ... 61 common frames omitted Caused by: org.flowable.common.engine.api.FlowableException: Error initialising eventregistry data model at org.flowable.common.engine.impl.db.LiquibaseBasedSchemaManager.initSchema(LiquibaseBasedSchemaManager.java:91) at org.flowable.eventregistry.impl.db.EventDbSchemaManager.initSchema(EventDbSchemaManager.java:36) at org.flowable.eventregistry.impl.cmd.SchemaOperationsEventRegistryEngineBuild.execute(SchemaOperationsEventRegistryEngineBuild.java:29) at org.flowable.eventregistry.impl.cmd.SchemaOperationsEventRegistryEngineBuild.execute(SchemaOperationsEventRegistryEngineBuild.java:24) at org.flowable.common.engine.impl.interceptor.DefaultCommandInvoker.execute(DefaultCommandInvoker.java:22) at org.flowable.common.engine.impl.interceptor.TransactionContextInterceptor.execute(TransactionContextInterceptor.java:53) at org.flowable.common.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:105) at org.flowable.common.spring.SpringTransactionInterceptor.lambda$execute$0(SpringTransactionInterceptor.java:57) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) at org.flowable.common.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:57) at org.flowable.common.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:35) at org.flowable.common.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:56) at org.flowable.eventregistry.impl.EventRegistryEngineImpl.<init>(EventRegistryEngineImpl.java:47) at org.flowable.eventregistry.impl.EventRegistryEngineConfiguration.buildEventRegistryEngine(EventRegistryEngineConfiguration.java:210) at org.flowable.eventregistry.spring.SpringEventRegistryEngineConfiguration.buildEventRegistryEngine(SpringEventRegistryEngineConfiguration.java:73) at org.flowable.eventregistry.spring.configurator.SpringEventRegistryConfigurator.initEventRegistryEngine(SpringEventRegistryConfigurator.java:57) at org.flowable.eventregistry.spring.configurator.SpringEventRegistryConfigurator.configure(SpringEventRegistryConfigurator.java:47) at org.flowable.common.engine.impl.AbstractEngineConfiguration.configuratorsAfterInit(AbstractEngineConfiguration.java:1122) at org.flowable.app.engine.AppEngineConfiguration.init(AppEngineConfiguration.java:239) at org.flowable.app.engine.AppEngineConfiguration.buildAppEngine(AppEngineConfiguration.java:195) at org.flowable.app.spring.SpringAppEngineConfiguration.buildAppEngine(SpringAppEngineConfiguration.java:66) at org.flowable.app.spring.AppEngineFactoryBean.getObject(AppEngineFactoryBean.java:58) at org.flowable.app.spring.AppEngineFactoryBean.getObject(AppEngineFactoryBean.java:31) at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:182) ... 71 common frames omitted Caused by: org.flowable.common.engine.api.FlowableException: Error updating eventregistry engine tables at org.flowable.common.engine.impl.db.LiquibaseBasedSchemaManager.schemaUpdate(LiquibaseBasedSchemaManager.java:132) at org.flowable.eventregistry.impl.db.EventDbSchemaManager.schemaUpdate(EventDbSchemaManager.java:63) at liquibase.Scope.lambda$child$0(Scope.java:190) at liquibase.Scope.child(Scope.java:199) at liquibase.Scope.child(Scope.java:189) at liquibase.Scope.child(Scope.java:168) at org.flowable.common.engine.impl.db.LiquibaseBasedSchemaManager.runForLiquibase(LiquibaseBasedSchemaManager.java:96) at org.flowable.common.engine.impl.db.LiquibaseBasedSchemaManager.initSchema(LiquibaseBasedSchemaManager.java:84) ... 94 common frames omitted Caused by: liquibase.exception.CommandExecutionException: java.lang.NullPointerException: Cannot invoke "liquibase.structure.core.Column.getType()" because the return value of "liquibase.structure.core.Table.getColumn(String)" is null at liquibase.command.CommandScope.execute(CommandScope.java:257) at liquibase.Liquibase.lambda$update$0(Liquibase.java:245) at liquibase.Scope.lambda$child$0(Scope.java:190) at liquibase.Scope.child(Scope.java:199) at liquibase.Scope.child(Scope.java:189) at liquibase.Scope.child(Scope.java:168) at liquibase.Liquibase.runInScope(Liquibase.java:1436) at liquibase.Liquibase.update(Liquibase.java:234) at liquibase.Liquibase.update(Liquibase.java:212) at liquibase.Liquibase.update(Liquibase.java:194) at liquibase.Liquibase.update(Liquibase.java:179) at org.flowable.common.engine.impl.db.LiquibaseBasedSchemaManager.schemaUpdate(LiquibaseBasedSchemaManager.java:130) ... 101 common frames omitted Caused by: java.lang.NullPointerException: Cannot invoke "liquibase.structure.core.Column.getType()" because the return value of "liquibase.structure.core.Table.getColumn(String)" is null at liquibase.changelog.StandardChangeLogHistoryService.init(StandardChangeLogHistoryService.java:130) at liquibase.command.core.helpers.DatabaseChangelogCommandStep.checkLiquibaseTables(DatabaseChangelogCommandStep.java:141) at liquibase.command.core.helpers.DatabaseChangelogCommandStep.run(DatabaseChangelogCommandStep.java:91) at liquibase.command.CommandScope.execute(CommandScope.java:219) ... 112 common frames omitted
10-15
2025-10-29 15:16:38 [com.xxl.job.core.thread.JobThread#run]-[124]-[Thread-8] ----------- xxl-job job execute start ----------- ----------- Param: 2025-10-29 15:16:41 [com.xxl.job.core.thread.JobThread#run]-[183]-[Thread-8] ----------- JobThread Exception:java.util.concurrent.ExecutionException: java.lang.reflect.InvocationTargetException at java.util.concurrent.FutureTask.report(FutureTask.java:122) at java.util.concurrent.FutureTask.get(FutureTask.java:206) at com.xxl.job.core.thread.JobThread.run(JobThread.java:140) Caused by: java.lang.reflect.InvocationTargetException 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 com.xxl.job.core.handler.impl.MethodJobHandler.execute(MethodJobHandler.java:29) at com.xxl.job.core.thread.JobThread$1.call(JobThread.java:134) at com.xxl.job.core.thread.JobThread$1.call(JobThread.java:131) at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266) at java.util.concurrent.FutureTask.run(FutureTask.java) at --- Async.Stack.Trace --- (captured by IntelliJ IDEA debugger) at java.util.concurrent.FutureTask.(FutureTask.java:132) at com.xxl.job.core.thread.JobThread.run(JobThread.java:131) Caused by: org.springframework.dao.DataIntegrityViolationException: Error attempting to get column 'createByName' from result set. Cause: java.sql.SQLDataException: Cannot determine value type from string 'hhj' ; Cannot determine value type from string 'hhj'; nested exception is java.sql.SQLDataException: Cannot determine value type from string 'hhj' at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:84) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79) at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:88) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440) at com.sun.proxy.$Proxy104.selectList(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:223) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:177) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:78) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:96) at com.sun.proxy.$Proxy149.getExpiredConsMemberOfTemporaryApprove(Unknown Source) at com.rrd.ims.job.handler.ConsHandler.consUnitMemberExpiredOfTemporaryApprove(ConsHandler.java:244) at com.rrd.ims.job.handler.ConsHandler$$FastClassBySpringCGLIB$$8ed5c0e.invoke() at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708) at com.rrd.ims.job.handler.ConsHandler$$EnhancerBySpringCGLIB$$41d0d2.consUnitMemberExpiredOfTemporaryApprove() ... 12 more Caused by: java.sql.SQLDataException: Cannot determine value type from string 'hhj' at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:114) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:96) at com.mysql.cj.jdbc.result.ResultSetImpl.getObject(ResultSetImpl.java:1431) at com.mysql.cj.jdbc.result.ResultSetImpl.getLong(ResultSetImpl.java:856) at com.mysql.cj.jdbc.result.ResultSetImpl.getLong(ResultSetImpl.java:862) at com.zaxxer.hikari.pool.HikariProxyResultSet.getLong(HikariProxyResultSet.java) 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.apache.ibatis.logging.jdbc.ResultSetLogger.invoke(ResultSetLogger.java:69) at com.sun.proxy.$Proxy221.getLong(Unknown Source) at org.apache.ibatis.type.LongTypeHandler.getNullableResult(LongTypeHandler.java:37) at org.apache.ibatis.type.LongTypeHandler.getNullableResult(LongTypeHandler.java:26) at org.apache.ibatis.type.BaseTypeHandler.getResult(BaseTypeHandler.java:81) at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.applyAutomaticMappings(DefaultResultSetHandler.java:521) at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getRowValue(DefaultResultSetHandler.java:402) at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValuesForSimpleResultMap(DefaultResultSetHandler.java:354) at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValues(DefaultResultSetHandler.java:328) at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSet(DefaultResultSetHandler.java:301) at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSets(DefaultResultSetHandler.java:194) at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:65) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) 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.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63) at com.sun.proxy.$Proxy218.query(Unknown Source) at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.doQuery(MybatisSimpleExecutor.java:67) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:136) 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.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49) at com.rrd.ims.aspect.MybatisInterceptor.intercept(MybatisInterceptor.java:76) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) at com.sun.proxy.$Proxy217.query(Unknown Source) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) 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.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426) ... 31 more Caused by: com.mysql.cj.exceptions.DataConversionException: Cannot determine value type from string 'hhj' at com.mysql.cj.result.AbstractNumericValueFactory.createFromBytes(AbstractNumericValueFactory.java:65) at com.mysql.cj.protocol.a.MysqlTextValueDecoder.decodeByteArray(MysqlTextValueDecoder.java:143) at com.mysql.cj.protocol.result.AbstractResultsetRow.decodeAndCreateReturnValue(AbstractResultsetRow.java:135) at com.mysql.cj.protocol.result.AbstractResultsetRow.getValueFromBytes(AbstractResultsetRow.java:243) at com.mysql.cj.protocol.a.result.ByteArrayRow.getValue(ByteArrayRow.java:91) at com.mysql.cj.jdbc.result.ResultSetImpl.getObject(ResultSetImpl.java:1329) ... 76 more ----------- xxl-job job execute end(error) ----------- 2025-10-29 15:16:41 [com.xxl.job.core.thread.TriggerCallbackThread#callbackLog]-[191]-[xxl-job, executor TriggerCallbackThread] ----------- xxl-job job callback finish. 分析一下上述xxl-job执行日志
最新发布
10-30
... at com.alibaba.yunbi.v2.query.service.SqlPreviewServiceImpl$$EnhancerBySpringCGLIB$$97d101c7.previewSqlData(<generated>) at com.alibaba.yunbi.v2.query.controller.SqlPreviewController.previewSqlData(SqlPreviewController.java:82) at com.alibaba.yunbi.v2.query.controller.SqlPreviewController$$FastClassBySpringCGLIB$$af09b704.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) ... at com.alibaba.yunbi.v2.query.performance.QueryPerformanceAspect.recordApiPerformance(QueryPerformanceAspect.java:163) at sun.reflect.GeneratedMethodAccessor253.invoke(Unknown Source) ... at com.alibaba.yunbi.v2.common.service.aop.SentinelFlowControlAspect.doPrepare(SentinelFlowControlAspect.java:79) at sun.reflect.GeneratedMethodAccessor331.invoke(Unknown Source) ... at com.alibaba.yunbi.v2.query.controller.SqlPreviewController$$EnhancerBySpringCGLIB$$6b7a5f97.previewSqlData(<generated>) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ... at com.alibaba.yunbi.server.filter.InstanceFilter.doFilter(InstanceFilter.java:105) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) ... at com.alibaba.yunbi.server.filter.LicenseFilter.doFilter(LicenseFilter.java:124) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) ... at com.alibaba.yunbi.server.filter.ServiceLevelAgreementFilter.doFilter(ServiceLevelAgreementFilter.java:46) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) ... at com.alibaba.yunbi.server.filter.GrayScaleFilter.doFilter(GrayScaleFilter.java:88) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) ... at com.alibaba.yunbi.server.filter.GlobalParamFilter.doFilter(GlobalParamFilter.java:89) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) ... at com.alibaba.yunbi.server.filter.LocaleFilter.doFilter(LocaleFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) ... at com.alibaba.yunbi.server.filter.UserAccessFilter.doFilter(UserAccessFilter.java:255) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) ... at com.alibaba.ly.sso.adapter.core.filter.AuthenticationFilter.doFilter(AuthenticationFilter.java:94) at com.alibaba.yunbi.v2.sso.NewUserAccessFilter.doFilter(NewUserAccessFilter.java:83) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) ... at com.alibaba.yunbi.server.filter.TbSessionFilter.doFilter(TbSessionFilter.java:51) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) ... at com.alibaba.yunbi.server.filter.RequestOriginFilter.doFilter(RequestOriginFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) ... at com.alibaba.yunbi.server.filter.ResponseWrapperFilter.doFilter(ResponseWrapperFilter.java:54) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) ... at com.alibaba.yunbi.server.filter.EntranceFilter.doFilter(EntranceFilter.java:89) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) ... at com.alibaba.yunbi.server.filter.CustomCharacterEncodingFilter.doFilterInternal(CustomCharacterEncodingFilter.java:55) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ... at com.alibaba.yunbi.server.filter.PreHandleFilter.doFilter(PreHandleFilter.java:36) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) ... Caused by: java.lang.RuntimeException: java.lang.RuntimeException: SQL execute error by datasource... com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=OFFSET 0 ROWS;ystem ) TS712333852;<space>, DRIVER=4.14.146 com.ibm.db2.jcc.am.ed.a(ed.java:677) com.ibm.db2.jcc.am.ed.a(ed.java:60) com.ibm.db2.jcc.am.ed.a(ed.java:127) com.ibm.db2.jcc.am.oo.c(oo.java:2730) com.ibm.db2.jcc.am.oo.d(oo.java:2718) at com.alibaba.nox.connector.action.executor.JdbcTemplate.execute(JdbcTemplate.java:321) at com.alibaba.nox.connector.action.task.impl.jdbc.JdbcDataQueryTaskImpl.executeQuery(JdbcDataQueryTaskImpl.java:91) at com.alibaba.nox.connector.action.director.DataQueryServiceImpl.executeQuery(DataQueryServiceImpl.java:79) at com.alibaba.nox.connector.action.director.DataQueryServiceImpl$$FastClassBySpringCGLIB$$f9374538.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) ... at com.alibaba.quickbi.pluginx.core.AbstractAdviceExecute.doExecute(AbstractAdviceExecute.java:89) at com.alibaba.yunbi.v2.plugin.pluginx.adaptor.query.post.CubeQueryPostAdvice.around(CubeQueryPostAdvice.java:45) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ... at com.alibaba.nox.connector.action.director.DataQueryServiceImpl$$EnhancerBySpringCGLIB$$7cba04ee.executeQuery(<generated>) at com.alibaba.yunbi.v2.xengine.executor.task.taskexecutor.DefaultTaskExecutor.executeNewQuery(DefaultTaskExecutor.java:337) ... 218 more Caused by: java.lang.RuntimeException: SQL execute error by datasource... com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=OFFSET 0 ROWS;ystem ) TS712333852;<space>, DRIVER=4.14.146 com.ibm.db2.jcc.am.ed.a(ed.java:677) com.ibm.db2.jcc.am.ed.a(ed.java:60) com.ibm.db2.jcc.am.ed.a(ed.java:127) com.ibm.db2.jcc.am.oo.c(oo.java:2730) com.ibm.db2.jcc.am.oo.d(oo.java:2718) at com.alibaba.nox.connector.action.task.impl.jdbc.JdbcDataQueryTaskImpl$1.call(JdbcDataQueryTaskImpl.java:240) at com.alibaba.nox.connector.action.task.impl.jdbc.JdbcDataQueryTaskImpl$1.call(JdbcDataQueryTaskImpl.java:91) at com.alibaba.nox.connector.action.executor.JdbcTemplate.execute(JdbcTemplate.java:317) ... 242 more Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=OFFSET 0 ROWS;ystem ) TS712333852;<space>, DRIVER=4.14.146 at com.ibm.db2.jcc.am.ed.a(ed.java:677)
09-24
2025-09-19 13:11:07.204 [lettuce-nioEventLoop-4-1] DEBUG io.lettuce.core.protocol.CommandHandler - [channel=0x69b8c689, /127.0.0.1:22669 -> localhost/127.0.0.1:6379, epid=0x1, chid=0x1] write(ctx, AsyncCommand [type=DEL, output=IntegerOutput [output=null, error='null'], commandType=io.lettuce.core.protocol.Command], promise) 2025-09-19 13:11:07.205 [lettuce-nioEventLoop-4-1] DEBUG io.lettuce.core.protocol.CommandEncoder - [channel=0x69b8c689, /127.0.0.1:22669 -> localhost/127.0.0.1:6379] writing command AsyncCommand [type=DEL, output=IntegerOutput [output=null, error='null'], commandType=io.lettuce.core.protocol.Command] 2025-09-19 13:11:07.205 [lettuce-nioEventLoop-4-1] DEBUG io.lettuce.core.protocol.CommandHandler - [channel=0x69b8c689, /127.0.0.1:22669 -> localhost/127.0.0.1:6379, epid=0x1, chid=0x1] Received: 4 bytes, 1 commands in the stack 2025-09-19 13:11:07.205 [lettuce-nioEventLoop-4-1] DEBUG io.lettuce.core.protocol.CommandHandler - [channel=0x69b8c689, /127.0.0.1:22669 -> localhost/127.0.0.1:6379, epid=0x1, chid=0x1] Stack contains: 1 commands 2025-09-19 13:11:07.206 [lettuce-nioEventLoop-4-1] DEBUG io.lettuce.core.protocol.RedisStateMachine - Decode done, empty stack: true 2025-09-19 13:11:07.209 [lettuce-nioEventLoop-4-1] DEBUG io.lettuce.core.protocol.CommandHandler - [channel=0x69b8c689, /127.0.0.1:22669 -> localhost/127.0.0.1:6379, epid=0x1, chid=0x1] Completing command LatencyMeteredCommand [type=DEL, output=IntegerOutput [output=1, error='null'], commandType=io.lettuce.core.protocol.AsyncCommand] 2025-09-19 13:11:07.209 [scheduling-1] DEBUG o.s.data.redis.core.RedisConnectionUtils - Closing Redis Connection. 2025-09-19 13:11:07.210 [scheduling-1] INFO c.hvlink.service.impl.SyncPlanProtocolServiceImpl - ======================结束了===========================计划协议同步任务锁已释放 2025-09-19 13:11:07.212 [scheduling-1] DEBUG o.s.jdbc.datasource.DataSourceTransactionManager - Initiating transaction rollback 2025-09-19 13:11:07.212 [scheduling-1] DEBUG o.s.jdbc.datasource.DataSourceTransactionManager - Rolling back JDBC transaction on Connection [ConnectionID:1 ClientConnectionId: 99d645c0-e5d6-4b9d-a421-952766829756] 2025-09-19 13:11:07.224 [scheduling-1] DEBUG o.s.jdbc.datasource.DataSourceTransactionManager - Releasing JDBC Connection [ConnectionID:1 ClientConnectionId: 99d645c0-e5d6-4b9d-a421-952766829756] after transaction 2025-09-19 13:11:07.226 [scheduling-1] ERROR o.s.s.support.TaskUtils$LoggingErrorHandler - Unexpected error occurred in scheduled task java.lang.RuntimeException: java.lang.IllegalArgumentException: Result Maps collection does not contain value for com.hvlink.entity.dto.order.PurchaseOrderMainDTO at com.hvlink.service.impl.SyncPlanProtocolServiceImpl.syncPurchaseOrderData(SyncPlanProtocolServiceImpl.java:189) at com.hvlink.service.impl.SyncPlanProtocolServiceImpl$$FastClassBySpringCGLIB$$fba6dd9d.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:792) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762) at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:707) at com.hvlink.service.impl.SyncPlanProtocolServiceImpl$$EnhancerBySpringCGLIB$$38999a59.syncPurchaseOrderData(<generated>) 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.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:750) Caused by: java.lang.IllegalArgumentException: Result Maps collection does not contain value for com.hvlink.entity.dto.order.PurchaseOrderMainDTO at com.baomidou.mybatisplus.core.MybatisConfiguration$StrictMap.get(MybatisConfiguration.java:454) at com.baomidou.mybatisplus.core.MybatisConfiguration.getResultMap(MybatisConfiguration.java:293) at org.apache.ibatis.builder.MapperBuilderAssistant.getStatementResultMaps(MapperBuilderAssistant.java:394) at org.apache.ibatis.builder.MapperBuilderAssistant.addMappedStatement(MapperBuilderAssistant.java:285) at org.apache.ibatis.builder.xml.XMLStatementBuilder.parseStatementNode(XMLStatementBuilder.java:113) at org.apache.ibatis.session.Configuration.lambda$buildAllStatements$2(Configuration.java:914) at java.util.Collection.removeIf(Collection.java:414) at org.apache.ibatis.session.Configuration.buildAllStatements(Configuration.java:913) at com.baomidou.mybatisplus.core.MybatisConfiguration.hasStatement(MybatisConfiguration.java:359) at org.apache.ibatis.session.Configuration.hasStatement(Configuration.java:885) at org.apache.ibatis.binding.MapperMethod$SqlCommand.resolveMappedStatement(MapperMethod.java:257) at org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>(MapperMethod.java:227) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.<init>(MybatisMapperMethod.java:50) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.lambda$cachedInvoker$0(MybatisMapperProxy.java:111) at java.util.concurrent.ConcurrentHashMap.computeIfAbsent(ConcurrentHashMap.java:1660) at com.baomidou.mybatisplus.core.toolkit.CollectionUtils.computeIfAbsent(CollectionUtils.java:115) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.cachedInvoker(MybatisMapperProxy.java:98) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89) at com.sun.proxy.$Proxy116.queryExistingApprovalCodes(Unknown Source) at com.hvlink.service.impl.SyncPlanProtocolServiceImpl.getLatestOrderDetailsList(SyncPlanProtocolServiceImpl.java:541) at com.hvlink.service.impl.SyncPlanProtocolServiceImpl.syncPurchaseOrderData(SyncPlanProtocolServiceImpl.java:139) ... 25 common frames omitted 2025-09-19 13:11:07.251 [RMI TCP Connection(1)-2.0.0.1] DEBUG o.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource 2025-09-19 13:11:07.261 [RMI TCP Connection(1)-2.0.0.1] DEBUG o.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource 2025-09-19 13:11:07.546 [RMI TCP Connection(1)-2.0.0.1] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-2} inited 2025-09-19 13:11:07.680 [RMI TCP Connection(1)-2.0.0.1] DEBUG o.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource 2025-09-19 13:11:07.705 [RMI TCP Connection(1)-2.0.0.1] DEBUG o.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource 2025-09-19 13:11:07.706 [RMI TCP Connection(1)-2.0.0.1] DEBUG o.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource 2025-09-19 13:11:07.741 [RMI TCP Connection(1)-2.0.0.1] DEBUG o.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource 2025-09-19 13:11:07.741 [RMI TCP Connection(1)-2.0.0.1] DEBUG o.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource 2025-09-19 13:11:07.892 [boundedElastic-1] DEBUG io.lettuce.core.RedisClient - Trying to get a Redis connection for: redis://localhost 2025-09-19 13:11:07.893 [boundedElastic-1] DEBUG io.lettuce.core.RedisClient - Resolved SocketAddress localhost:6379 using redis://localhost 2025-09-19 13:11:07.893 [boundedElastic-1] DEBUG io.lettuce.core.AbstractRedisClient - Connecting to Redis at localhost:6379 2025-09-19 13:11:07.895 [lettuce-nioEventLoop-4-2] DEBUG io.lettuce.core.protocol.CommandHandler - [channel=0x3f3b2d91, [id: 0x2d015132] (inactive), epid=0x2, chid=0x2] channelRegistered() 2025-09-19 13:11:07.897 [lettuce-nioEventLoop-4-2] DEBUG io.lettuce.core.protocol.CommandHandler - [channel=0x3f3b2d91, /127.0.0.1:22683 -> localhost/127.0.0.1:6379, epid=0x2, chid=0x2] write(ctx, AsyncCommand [type=HELLO, output=GenericMapOutput [output=null, error='null'], commandType=io.lettuce.core.protocol.Command], promise) 2025-09-19 13:11:07.897 [lettuce-nioEventLoop-4-2] DEBUG io.lettuce.core.protocol.CommandEncoder - [channel=0x3f3b2d91, /127.0.0.1:22683 -> localhost/127.0.0.1:6379] writing command AsyncCommand [type=HELLO, output=GenericMapOutput [output=null, error='null'], commandType=io.lettuce.core.protocol.Command] 2025-09-19 13:11:07.897 [lettuce-nioEventLoop-4-2] DEBUG io.lettuce.core.protocol.CommandHandler - [channel=0x3f3b2d91, /127.0.0.1:22683 -> localhost/127.0.0.1:6379, epid=0x2, chid=0x2] Received: 30 bytes, 1 commands in the stack 2025-09-19 13:11:07.897 [lettuce-nioEventLoop-4-2] DEBUG io.lettuce.core.protocol.CommandHandler - [channel=0x3f3b2d91, /127.0.0.1:22683 -> localhost/127.0.0.1:6379, epid=0x2, chid=0x2] Stack contains: 1 commands 2025-09-19 13:11:07.897 [lettuce-nioEventLoop-4-2] DEBUG io.lettuce.core.protocol.RedisStateMachine - Decode done, empty stack: true 2025-09-19 13:11:07.900 [lettuce-nioEventLoop-4-2] DEBUG io.lettuce.core.protocol.CommandHandler - [channel=0x3f3b2d91, /127.0.0.1:22683 -> localhost/127.0.0.1:6379, epid=0x2, chid=0x2] Completing command LatencyMeteredCommand [type=HELLO, output=GenericMapOutput [output=null, error='ERR unknown command 'HELLO''], commandType=io.lettuce.core.protocol.AsyncCommand] 2025-09-19 13:11:07.900 [lettuce-nioEventLoop-4-2] DEBUG io.lettuce.core.protocol.CommandHandler - [channel=0x3f3b2d91, /127.0.0.1:22683 -> localhost/127.0.0.1:6379, epid=0x2, chid=0x2] write(ctx, AsyncCommand [type=PING, output=StatusOutput [output=null, error='null'], commandType=io.lettuce.core.protocol.Command], promise) 2025-09-19 13:11:07.900 [lettuce-nioEventLoop-4-2] DEBUG io.lettuce.core.protocol.CommandEncoder - [channel=0x3f3b2d91, /127.0.0.1:22683 -> localhost/127.0.0.1:6379] writing command AsyncCommand [type=PING, output=StatusOutput [output=null, error='null'], commandType=io.lettuce.core.protocol.Command] 2025-09-19 13:11:07.901 [lettuce-nioEventLoop-4-2] DEBUG io.lettuce.core.protocol.CommandHandler - [channel=0x3f3b2d91, /127.0.0.1:22683 -> localhost/127.0.0.1:6379, epid=0x2, chid=0x2] Received: 7 bytes, 1 commands in the stack 2025-09-19 13:11:07.901 [lettuce-nioEventLoop-4-2] DEBUG io.lettuce.core.protocol.CommandHandler - [channel=0x3f3b2d91, /127.0.0.1:22683 -> localhost/127.0.0.1:6379, epid=0x2, chid=0x2] Stack contains: 1 commands 2025-09-19 13:11:07.927 [lettuce-nioEventLoop-4-2] DEBUG io.lettuce.core.protocol.RedisStateMachine - Decode done, empty stack: true 2025-09-19 13:11:07.927 [lettuce-nioEventLoop-4-2] DEBUG io.lettuce.core.protocol.CommandHandler - [channel=0x3f3b2d91, /127.0.0.1:22683 -> localhost/127.0.0.1:6379, epid=0x2, chid=0x2] Completing command LatencyMeteredCommand [type=PING, output=StatusOutput [output=PONG, error='null'], commandType=io.lettuce.core.protocol.AsyncCommand] 2025-09-19 13:11:07.927 [lettuce-nioEventLoop-4-2] DEBUG io.lettuce.core.protocol.CommandHandler - [channel=0x3f3b2d91, /127.0.0.1:22683 -> localhost/127.0.0.1:6379, epid=0x2, chid=0x2] channelActive() 2025-09-19 13:11:07.927 [lettuce-nioEventLoop-4-2] DEBUG io.lettuce.core.protocol.DefaultEndpoint - [channel=0x3f3b2d91, /127.0.0.1:22683 -> localhost/127.0.0.1:6379, epid=0x2] activateEndpointAndExecuteBufferedCommands 0 command(s) buffered 2025-09-19 13:11:07.927 [lettuce-nioEventLoop-4-2] DEBUG io.lettuce.core.protocol.DefaultEndpoint - [channel=0x3f3b2d91, /127.0.0.1:22683 -> localhost/127.0.0.1:6379, epid=0x2] activating endpoint 2025-09-19 13:11:07.927 [lettuce-nioEventLoop-4-2] DEBUG io.lettuce.core.protocol.DefaultEndpoint - [channel=0x3f3b2d91, /127.0.0.1:22683 -> localhost/127.0.0.1:6379, epid=0x2] flushCommands() 2025-09-19 13:11:07.927 [lettuce-nioEventLoop-4-2] DEBUG io.lettuce.core.protocol.DefaultEndpoint - [channel=0x3f3b2d91, /127.0.0.1:22683 -> localhost/127.0.0.1:6379, epid=0x2] flushCommands() Flushing 0 commands 2025-09-19 13:11:07.927 [lettuce-nioEventLoop-4-2] DEBUG io.lettuce.core.protocol.ConnectionWatchdog - [channel=0x3f3b2d91, /127.0.0.1:22683 -> localhost/127.0.0.1:6379, last known addr=localhost/127.0.0.1:6379] channelActive() 2025-09-19 13:11:07.927 [lettuce-nioEventLoop-4-2] DEBUG io.lettuce.core.protocol.CommandHandler - [channel=0x3f3b2d91, /127.0.0.1:22683 -> localhost/127.0.0.1:6379, epid=0x2, chid=0x2] channelActive() done 2025-09-19 13:11:07.927 [lettuce-nioEventLoop-4-2] DEBUG io.lettuce.core.AbstractRedisClient - Connecting to Redis at localhost:6379: Success 2025-09-19 13:11:07.988 [boundedElastic-1] DEBUG io.lettuce.core.RedisChannelHandler - dispatching command SubscriptionCommand [type=INFO, output=StatusOutput [output=null, error='null'], commandType=io.lettuce.core.protocol.Command] 2025-09-19 13:11:07.988 [boundedElastic-1] DEBUG io.lettuce.core.protocol.DefaultEndpoint - [channel=0x3f3b2d91, /127.0.0.1:22683 -> localhost/127.0.0.1:6379, epid=0x2] write() writeAndFlush command SubscriptionCommand [type=INFO, output=StatusOutput [output=null, error='null'], commandType=io.lettuce.core.protocol.Command] 2025-09-19 13:11:07.997 [lettuce-nioEventLoop-4-2] DEBUG io.lettuce.core.protocol.CommandHandler - [channel=0x3f3b2d91, /127.0.0.1:22683 -> localhost/127.0.0.1:6379, epid=0x2, chid=0x2] write(ctx, SubscriptionCommand [type=INFO, output=StatusOutput [output=null, error='null'], commandType=io.lettuce.core.protocol.Command], promise) 2025-09-19 13:11:07.997 [boundedElastic-1] DEBUG io.lettuce.core.protocol.DefaultEndpoint - [channel=0x3f3b2d91, /127.0.0.1:22683 -> localhost/127.0.0.1:6379, epid=0x2] write() done 2025-09-19 13:11:07.998 [lettuce-nioEventLoop-4-2] DEBUG io.lettuce.core.protocol.CommandEncoder - [channel=0x3f3b2d91, /127.0.0.1:22683 -> localhost/127.0.0.1:6379] writing command SubscriptionCommand [type=INFO, output=StatusOutput [output=null, error='null'], commandType=io.lettuce.core.protocol.Command] 2025-09-19 13:11:07.999 [lettuce-nioEventLoop-4-2] DEBUG io.lettuce.core.protocol.CommandHandler - [channel=0x3f3b2d91, /127.0.0.1:22683 -> localhost/127.0.0.1:6379, epid=0x2, chid=0x2] Received: 365 bytes, 1 commands in the stack 2025-09-19 13:11:07.999 [lettuce-nioEventLoop-4-2] DEBUG io.lettuce.core.protocol.CommandHandler - [channel=0x3f3b2d91, /127.0.0.1:22683 -> localhost/127.0.0.1:6379, epid=0x2, chid=0x2] Stack contains: 1 commands 2025-09-19 13:11:07.999 [lettuce-nioEventLoop-4-2] DEBUG io.lettuce.core.protocol.RedisStateMachine - Decode done, empty stack: true 2025-09-19 13:11:08.005 [lettuce-nioEventLoop-4-2] DEBUG io.lettuce.core.protocol.CommandHandler - [channel=0x3f3b2d91, /127.0.0.1:22683 -> localhost/127.0.0.1:6379, epid=0x2, chid=0x2] Completing command LatencyMeteredCommand [type=INFO, output=StatusOutput [output=# Server redis_version:3.0.504 redis_git_sha1:00000000 redis_git_dirty:0 redis_build_id:a4f7a6e86f2d60b3 redis_mode:standalone os:Windows arch_bits:64 multiplexing_api:WinSock_IOCP process_id:904 run_id:a7d2e2bdc458123d1f1f741d8bf2bf35dcd84801 tcp_port:6379 uptime_in_seconds:187271 uptime_in_days:2 hz:10 lru_clock:13428203 config_file: , error='null'], commandType=io.lettuce.core.RedisPublisher$SubscriptionCommand]
09-20
<think>我们正在处理一个关于Struts 2启动过滤器异常的问题。根据用户描述,错误出现在启动Catalina容器时,涉及ContainerBase.addChild方法,并抛出RuntimeException和InvocationTargetException。错误指向ContainerBuilder.java的161行。用户还提供了几个引用,这些引用描述了类似的问题和可能的解决方案。 首先,我们需要分析常见的根本原因: 1. **类加载问题**:如引用[3]中提到的ClassNotFoundException,可能是由于类名配置错误(如filter-class中包含了".class"后缀)或缺少必要的JAR包。 2. **依赖冲突或版本不匹配**:引用[1]提到,如果导入了不需要的插件(如struts2-spring-plugin)而没有使用Spring,可能会导致问题。同时,Struts 2的不同版本对依赖的要求不同,比如在6.4.0中已经集成了XWork,不需要单独的XWork-core。 3. **配置文件错误**:struts.xml、web.xml等配置文件中的错误,如DTD声明不正确(引用[1]提到升级时需要修改DTD版本)或filter配置错误。 4. **项目构建问题**:引用[4]提到,在项目结构中可能存在文件丢失,需要检查并修复。 用户的具体错误信息是: ERROR org.apache.catalina.core.ContainerBase Catalina localhost 启动失败 java.lang.RuntimeException java.lang.reflect.InvocationTargetException at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBuilder.java:161) 这个错误通常发生在Tomcat尝试部署Web应用程序时,在添加子容器(如Context)时失败。根本原因可能隐藏在InvocationTargetException中,我们需要查看更底层的异常。 解决步骤: 1. **检查控制台日志**:查找InvocationTargetException之后的第一个“Caused by”部分,以确定根本原因。可能是缺少类、配置文件错误或初始化失败。 2. **检查web.xml中的过滤器配置**: - 确保`<filter-class>`正确,如引用[3]中提到的,不应该有“.class”后缀。正确的类名是`org.apache.struts2.dispatcher.filter.StrutsPrepareAndExecuteFilter`(对于Struts 2.5+,包括6.4.0)。注意:在Struts 2.5之前,使用的是`org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter`(注意“ng”),但新版本已经去掉“ng”。 - 示例配置: ```xml <filter> <filter-name>struts2</filter-name> <filter-class>org.apache.struts2.dispatcher.filter.StrutsPrepareAndExecuteFilter</filter-class> </filter> ``` 3. **检查依赖**: - 确保项目中只包含必要的Struts 2依赖。对于Struts 2.6+(包括6.4.0),核心依赖是`struts2-core`(Maven坐标:`org.apache.struts:struts2-core:6.4.0`)。 - 检查是否有重复或冲突的依赖(例如,同时存在多个版本的Struts 2核心库或XWork)。 - 移除不必要的插件:例如,如果没有使用Spring,就不要包含`struts2-spring-plugin`;同样,检查其他插件(如JSON插件、JFreeChart插件等)是否与当前版本兼容。 4. **检查配置文件**: - `struts.xml`:确保DTD声明正确(对于Struts 2.5+,应使用2.5的DTD)。同时检查包定义、拦截器配置等。 - 检查是否有多个配置文件冲突(例如,在多个JAR包中包含struts.xml)。 5. **项目结构检查**: - 确保所有依赖的JAR包都放在`WEB-INF/lib`目录下(对于非Maven项目)。 - 如果是使用IDE(如IntelliJ IDEA),检查项目结构(Project Structure)中是否有问题(如引用[4]所述),确保所有模块的依赖正确。 6. **类路径问题**:确保没有重复的类(例如,同一个类出现在多个JAR中)或版本冲突。可以使用`mvn dependency:tree`(Maven项目)来查看依赖树。 7. **日志配置**:增加Struts 2和Tomcat的日志级别(如DEBUG),以获取更详细的错误信息。可以在`struts.xml`中配置: ```xml <constant name="struts.devMode" value="true" /> ``` 由于用户没有提供具体的“Caused by”异常,我们只能根据常见情况给出建议。但是,根据引用[1]和[3]的经验,以下两种可能性较大: 可能性1:过滤器类名配置错误(如引用[3]的情况) - 解决:检查web.xml中的filter-class,确保没有多余的后缀(如“.class”),并且类名完全正确。 可能性2:缺少依赖或依赖冲突(如引用[1]的情况) - 解决:检查是否引入了不必要的插件(如struts2-spring-plugin)而没有配置Spring,或者缺少核心依赖。 如果上述步骤不能解决问题,请用户提供更详细的异常堆栈(特别是“Caused by”部分)。 相关问题: 1. 如何解决Struts 2启动时的ClassNotFoundException? 2. 如何配置Struts 2的web.xml过滤器? 3. 如何排除Struts 2依赖冲突? 4. 如何升级Struts 2到最新版本(6.4.0)? 5. 如何调试Struts 2的启动错误? 注意:在回答中,我们引用了用户提供的引用[1]、[3]和[4],所以我们在适当的地方添加了引用标记。</think>### Struts 2 启动过滤器异常解决方案 当遇到 `ContainerBase.addChild: start` 错误并伴随 `RuntimeException` 和 `InvocationTargetException` 时,通常由以下原因引起。请按顺序排查: #### 1. **检查过滤器类名配置**(最常见错误) 在 `web.xml` 中确认过滤器类名是否正确: ```xml <!-- 正确配置(注意无.class后缀) --> <filter> <filter-name>struts2</filter-name> <filter-class>org.apache.struts2.dispatcher.filter.StrutsPrepareAndExecuteFilter</filter-class> </filter> ``` - **错误示例**:`org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.class`(多余的后缀)[^3] - **解决方案**:删除类名中的 `.class` 后缀 #### 2. **验证依赖完整性** Struts 6.4.0 核心依赖: ```xml <dependency> <groupId>org.apache.struts</groupId> <artifactId>struts2-core</artifactId> <version>6.4.0</version> </dependency> ``` - **关键检查点**: - 移除所有 `xwork-core*.jar`(6.x 已内置) - 检查是否误添加了不兼容插件(如 `struts2-spring-plugin` 在非Spring项目中)[^1] - 使用命令验证依赖树: ```bash mvn dependency:tree -Dincludes=org.apache.struts ``` #### 3. **配置文件诊断** 在 `struts.xml` 中启用开发模式: ```xml <struts> <constant name="struts.devMode" value="true" /> <constant name="struts.configuration.xml.reload" value="true" /> </struts> ``` - 检查 `struts-default.xml` 加载问题: - 确认 `struts2-core-6.4.0.jar` 中的 `/struts-default.xml` 文件是否完整 - 避免自定义包名与系统包冲突 #### 4. **项目结构修复** 针对 IDE 配置问题: 1. 在 IntelliJ/Eclipse 中检查项目结构: - 确保 `WEB-INF/lib` 包含所有 Struts JAR - 修复 "Problem" 面板中的依赖缺失警告(点击 [Fix] 按钮)[^4] 2. 清理部署缓存: - 删除 `work/Catalina` 和 `temp` 目录(Tomcat) - 执行 `mvn clean install` #### 5. **日志深度分析** 在 `log4j2.xml` 中添加调试配置: ```xml <Configuration> <Loggers> <Logger name="com.opensymphony.xwork2" level="debug" /> <Logger name="org.apache.struts2" level="trace" /> </Loggers> </Configuration> ``` - 关键日志线索: - 查找首个 `Caused by:` 的堆栈跟踪 - 检查 `ClassNotFoundException` 的具体类名 - 关注 `struts-default.xml` 加载过程中的 OGNL 错误 #### 典型错误场景解决 | 错误现象 | 解决方案 | |---------|---------| | `java.lang.ClassNotFoundException: ...StrutsPrepareAndExecuteFilter` | 修正 `web.xml` 的过滤器类名[^3] | | `Caught exception while loading file struts-default.xml` | 移除冲突插件(如 struts2-spring-plugin)[^1] | | `ContainerBase.addChild: start` 无详细错误 | 检查项目依赖完整性[^4] | | OGNL 表达式错误 | 升级至 OGNL 3.3.4(Struts 6.4.0 内置) | > **重要提示**:80% 的启动错误源于 (1) 过滤器类名配置错误 或 (2) 依赖冲突。建议先检查这两个点[^1][^3]。 --- ### 相关问题 1. 如何正确配置 Struts 2.6+ 的过滤器类名? 2. Struts 6.4.0 需要哪些核心依赖项? 3. 如何诊断 `struts-default.xml` 加载失败的根本原因? 4. 解决 Tomcat 部署时 `ContainerBase.addChild` 错误的通用方法? 5. Struts 2 项目从 Tomcat 8 迁移到 Tomcat 10 需要注意什么?
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值