Table 'ACT_APP_DEPLOYMENT' already启动错误?

kuzank
kuzank 剑者 2020-04-17 11:21

一、该问题的重现步骤是什么?

  1. 公司局域网部署了一个bladex-boot + saber系统,我本地电脑工程 bladex-boot 连接局域网的mysql数据库,启动后报错


二、你期待的结果是什么?实际看到的又是什么?

期待:启动成功

报错:liquibase.exception.DatabaseException: Table 'ACT_APP_DEPLOYMENT' already exists

我在网上搜索找到这篇文章,不知道是否有帮助:https://my.oschina.net/66das/blog/1806794


三、你正在使用的是什么产品,什么版本?在什么操作系统上?

产品:全家桶

版本:2.5.0版本

操作系统:MacBook 10.15.4


四、请提供详细的错误堆栈信息,这很重要。

Connected to the target VM, address: '127.0.0.1:50947', transport: 'socket'

----启动中,读取到的环境变量:[dev],jar地址:[/Users/kuzan/Documents/blade/BladeX-Boot/target/classes/]----

            ______  _             _       ___   ___

            | ___ \| |           | |      \  \ /  /

            | |_/ /| |  __ _   __| |  ___  \  V  /

            | ___ \| | / _` | / _` | / _ \   > <

            | |_/ /| || (_| || (_| ||  __/ /  .  \

            \____/ |_| \__,_| \__,_| \___|/__/ \__\


:: BladeX :: blade-api:dev :: Running SpringBoot 2.1.13.RELEASE :: 


2020-04-17 10:55:29.490  INFO 35903 --- [           main] org.springblade.Application              : Starting Application on localhost with PID 35903 (/Users/kuzan/Documents/blade/BladeX-Boot/target/classes started by kuzan in /Users/kuzan/Documents/blade/BladeX-Boot)

2020-04-17 10:55:29.493 DEBUG 35903 --- [           main] org.springblade.Application              : Running with Spring Boot v2.1.13.RELEASE, Spring v5.1.14.RELEASE

2020-04-17 10:55:29.493  INFO 35903 --- [           main] org.springblade.Application              : The following profiles are active: dev

2020-04-17 10:55:30.845  INFO 35903 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Multiple Spring Data modules found, entering strict repository configuration mode!

2020-04-17 10:55:30.846  INFO 35903 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data Redis repositories in DEFAULT mode.

2020-04-17 10:55:30.948  INFO 35903 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 91ms. Found 0 Redis repository interfaces.

2020-04-17 10:55:31.088  WARN 35903 --- [           main] o.m.s.mapper.ClassPathMapperScanner      : No MyBatis mapper was found in '[org.springblade]' package. Please check your configuration.

2020-04-17 10:55:31.368  INFO 35903 --- [           main] s.c.l.p.BladePropertySourcePostProcessor : BladePropertySourcePostProcessor init.

2020-04-17 10:55:31.368  INFO 35903 --- [           main] s.c.l.p.BladePropertySourcePostProcessor : BladePropertySourcePostProcessor process @BladePropertySource bean.

2020-04-17 10:55:31.998  WARN 35903 --- [           main] io.undertow.websockets.jsr               : UT026010: Buffer pool was not set on WebSocketDeploymentInfo, the default pool will be used

2020-04-17 10:55:32.022  INFO 35903 --- [           main] io.undertow.servlet                      : Initializing Spring embedded WebApplicationContext

2020-04-17 10:55:32.023  INFO 35903 --- [           main] o.s.web.context.ContextLoader            : Root WebApplicationContext: initialization completed in 2501 ms

2020-04-17 10:55:32.302  INFO 35903 --- [           main] c.a.d.s.b.a.DruidDataSourceAutoConfigure : Init DruidDataSource

2020-04-17 10:55:32.781  INFO 35903 --- [           main] com.alibaba.druid.pool.DruidDataSource   : {dataSource-1} inited

2020-04-17 10:55:34.664  INFO 35903 --- [           main] o.s.s.concurrent.ThreadPoolTaskExecutor  : Initializing ExecutorService 'applicationTaskExecutor'

2020-04-17 10:55:34.950  INFO 35903 --- [           main] guration$$EnhancerBySpringCGLIB$$d93068b : No deployment resources were found for autodeployment

2020-04-17 10:55:35.112  INFO 35903 --- [           main] uration$$EnhancerBySpringCGLIB$$6514487d : No deployment resources were found for autodeployment

2020-04-17 10:55:35.186  INFO 35903 --- [           main] uration$$EnhancerBySpringCGLIB$$a939c2eb : No deployment resources were found for autodeployment

2020-04-17 10:55:35.271  INFO 35903 --- [           main] uration$$EnhancerBySpringCGLIB$$bcfbfe45 : No deployment resources were found for autodeployment

2020-04-17 10:55:35.313  INFO 35903 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Found 6 Engine Configurators in total:

2020-04-17 10:55:35.313  INFO 35903 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : class org.flowable.engine.spring.configurator.SpringProcessEngineConfigurator (priority:50000)

2020-04-17 10:55:35.313  INFO 35903 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : class org.flowable.idm.spring.configurator.SpringIdmEngineConfigurator (priority:100000)

2020-04-17 10:55:35.313  INFO 35903 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : class org.flowable.dmn.spring.configurator.SpringDmnEngineConfigurator (priority:200000)

2020-04-17 10:55:35.313  INFO 35903 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : class org.flowable.form.spring.configurator.SpringFormEngineConfigurator (priority:300000)

2020-04-17 10:55:35.313  INFO 35903 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : class org.flowable.content.spring.configurator.SpringContentEngineConfigurator (priority:400000)

2020-04-17 10:55:35.313  INFO 35903 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : class org.flowable.cmmn.spring.configurator.SpringCmmnEngineConfigurator (priority:500000)

2020-04-17 10:55:35.313  INFO 35903 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing beforeInit() of class org.flowable.engine.spring.configurator.SpringProcessEngineConfigurator (priority:50000)

2020-04-17 10:55:35.315  INFO 35903 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing beforeInit() of class org.flowable.idm.spring.configurator.SpringIdmEngineConfigurator (priority:100000)

2020-04-17 10:55:35.316  INFO 35903 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing beforeInit() of class org.flowable.dmn.spring.configurator.SpringDmnEngineConfigurator (priority:200000)

2020-04-17 10:55:35.318  INFO 35903 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing beforeInit() of class org.flowable.form.spring.configurator.SpringFormEngineConfigurator (priority:300000)

2020-04-17 10:55:35.319  INFO 35903 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing beforeInit() of class org.flowable.content.spring.configurator.SpringContentEngineConfigurator (priority:400000)

2020-04-17 10:55:35.320  INFO 35903 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing beforeInit() of class org.flowable.cmmn.spring.configurator.SpringCmmnEngineConfigurator (priority:500000)

2020-04-17 10:55:35.954  INFO 35903 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing configure() of class org.flowable.engine.spring.configurator.SpringProcessEngineConfigurator (priority:50000)

2020-04-17 10:55:36.327  INFO 35903 --- [           main] o.f.engine.impl.ProcessEngineImpl        : ProcessEngine default created

2020-04-17 10:55:36.334  INFO 35903 --- [           main] o.f.j.s.i.a.AbstractAsyncExecutor        : Starting up the async job executor [org.flowable.spring.job.service.SpringAsyncExecutor].

2020-04-17 10:55:36.334  INFO 35903 --- [      Thread-17] o.f.j.s.i.a.AcquireAsyncJobsDueRunnable  : starting to acquire async jobs due

2020-04-17 10:55:36.334  INFO 35903 --- [      Thread-18] o.f.j.s.i.a.AcquireTimerJobsRunnable     : starting to acquire async jobs due

2020-04-17 10:55:36.335  INFO 35903 --- [      Thread-19] o.f.j.s.i.a.ResetExpiredJobsRunnable     : starting to reset expired jobs for engine bpmn

2020-04-17 10:55:36.382  INFO 35903 --- [           main] o.f.e.impl.cmd.ValidateV5EntitiesCmd     : Total of v5 deployments found: 0

2020-04-17 10:55:36.452  INFO 35903 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing configure() of class org.flowable.idm.spring.configurator.SpringIdmEngineConfigurator (priority:100000)

2020-04-17 10:55:36.496  INFO 35903 --- [           main] o.f.idm.engine.impl.IdmEngineImpl        : IdmEngine default created

2020-04-17 10:55:36.497  INFO 35903 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing configure() of class org.flowable.dmn.spring.configurator.SpringDmnEngineConfigurator (priority:200000)

2020-04-17 10:55:37.153  INFO 35903 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM bladex_boot.ACT_DMN_DATABASECHANGELOGLOCK

2020-04-17 10:55:37.158  INFO 35903 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM bladex_boot.ACT_DMN_DATABASECHANGELOGLOCK

2020-04-17 10:55:37.164  INFO 35903 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT `LOCKED` FROM bladex_boot.ACT_DMN_DATABASECHANGELOGLOCK WHERE ID=1

2020-04-17 10:55:37.194  INFO 35903 --- [           main] l.lockservice.StandardLockService        : Successfully acquired change log lock

2020-04-17 10:55:37.938  INFO 35903 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT MD5SUM FROM bladex_boot.ACT_DMN_DATABASECHANGELOG WHERE MD5SUM IS NOT NULL LIMIT 1

2020-04-17 10:55:37.941  INFO 35903 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM bladex_boot.ACT_DMN_DATABASECHANGELOG

2020-04-17 10:55:37.946  INFO 35903 --- [           main] l.c.StandardChangeLogHistoryService      : Reading from bladex_boot.ACT_DMN_DATABASECHANGELOG

2020-04-17 10:55:37.946  INFO 35903 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT * FROM bladex_boot.ACT_DMN_DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC

2020-04-17 10:55:37.983  INFO 35903 --- [           main] l.lockservice.StandardLockService        : Successfully released change log lock

2020-04-17 10:55:37.994  INFO 35903 --- [           main] o.f.dmn.engine.impl.DmnEngineImpl        : DmnEngine default created

2020-04-17 10:55:37.995  INFO 35903 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing configure() of class org.flowable.form.spring.configurator.SpringFormEngineConfigurator (priority:300000)

2020-04-17 10:55:38.051  INFO 35903 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM bladex_boot.ACT_FO_DATABASECHANGELOGLOCK

2020-04-17 10:55:38.057  INFO 35903 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM bladex_boot.ACT_FO_DATABASECHANGELOGLOCK

2020-04-17 10:55:38.060  INFO 35903 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT `LOCKED` FROM bladex_boot.ACT_FO_DATABASECHANGELOGLOCK WHERE ID=1

2020-04-17 10:55:38.074  INFO 35903 --- [           main] l.lockservice.StandardLockService        : Successfully acquired change log lock

2020-04-17 10:55:38.111  INFO 35903 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT MD5SUM FROM bladex_boot.ACT_FO_DATABASECHANGELOG WHERE MD5SUM IS NOT NULL LIMIT 1

2020-04-17 10:55:38.115  INFO 35903 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM bladex_boot.ACT_FO_DATABASECHANGELOG

2020-04-17 10:55:38.118  INFO 35903 --- [           main] l.c.StandardChangeLogHistoryService      : Reading from bladex_boot.ACT_FO_DATABASECHANGELOG

2020-04-17 10:55:38.119  INFO 35903 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT * FROM bladex_boot.ACT_FO_DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC

2020-04-17 10:55:38.194  INFO 35903 --- [           main] l.lockservice.StandardLockService        : Successfully released change log lock

2020-04-17 10:55:38.203  INFO 35903 --- [           main] o.f.form.engine.impl.FormEngineImpl      : FormEngine default created

2020-04-17 10:55:38.204  INFO 35903 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing configure() of class org.flowable.content.spring.configurator.SpringContentEngineConfigurator (priority:400000)

2020-04-17 10:55:38.209  INFO 35903 --- [           main] o.f.c.s.SpringContentEngineConfiguration : Content file system root : /Users/kuzan/content

2020-04-17 10:55:38.249  INFO 35903 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM bladex_boot.ACT_CO_DATABASECHANGELOGLOCK

2020-04-17 10:55:38.255  INFO 35903 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM bladex_boot.ACT_CO_DATABASECHANGELOGLOCK

2020-04-17 10:55:38.261  INFO 35903 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT `LOCKED` FROM bladex_boot.ACT_CO_DATABASECHANGELOGLOCK WHERE ID=1

2020-04-17 10:55:38.277  INFO 35903 --- [           main] l.lockservice.StandardLockService        : Successfully acquired change log lock

2020-04-17 10:55:38.315  INFO 35903 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT MD5SUM FROM bladex_boot.ACT_CO_DATABASECHANGELOG WHERE MD5SUM IS NOT NULL LIMIT 1

2020-04-17 10:55:38.317  INFO 35903 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM bladex_boot.ACT_CO_DATABASECHANGELOG

2020-04-17 10:55:38.320  INFO 35903 --- [           main] l.c.StandardChangeLogHistoryService      : Reading from bladex_boot.ACT_CO_DATABASECHANGELOG

2020-04-17 10:55:38.320  INFO 35903 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT * FROM bladex_boot.ACT_CO_DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC

2020-04-17 10:55:38.351  INFO 35903 --- [           main] l.lockservice.StandardLockService        : Successfully released change log lock

2020-04-17 10:55:38.363  INFO 35903 --- [           main] o.f.c.engine.impl.ContentEngineImpl      : ContentEngine default created

2020-04-17 10:55:38.364  INFO 35903 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing configure() of class org.flowable.cmmn.spring.configurator.SpringCmmnEngineConfigurator (priority:500000)

2020-04-17 10:55:38.631  INFO 35903 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM bladex_boot.ACT_CMMN_DATABASECHANGELOGLOCK

2020-04-17 10:55:38.634  INFO 35903 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM bladex_boot.ACT_CMMN_DATABASECHANGELOGLOCK

2020-04-17 10:55:38.637  INFO 35903 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT `LOCKED` FROM bladex_boot.ACT_CMMN_DATABASECHANGELOGLOCK WHERE ID=1

2020-04-17 10:55:38.645  INFO 35903 --- [           main] l.lockservice.StandardLockService        : Successfully acquired change log lock

2020-04-17 10:55:38.688  INFO 35903 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT MD5SUM FROM bladex_boot.ACT_CMMN_DATABASECHANGELOG WHERE MD5SUM IS NOT NULL LIMIT 1

2020-04-17 10:55:38.698  INFO 35903 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM bladex_boot.ACT_CMMN_DATABASECHANGELOG

2020-04-17 10:55:38.707  INFO 35903 --- [           main] l.c.StandardChangeLogHistoryService      : Reading from bladex_boot.ACT_CMMN_DATABASECHANGELOG

2020-04-17 10:55:38.707  INFO 35903 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT * FROM bladex_boot.ACT_CMMN_DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC

2020-04-17 10:55:38.758  INFO 35903 --- [           main] l.lockservice.StandardLockService        : Successfully released change log lock

2020-04-17 10:55:38.779  INFO 35903 --- [           main] o.f.j.s.i.a.AbstractAsyncExecutor        : Starting up the async job executor [org.flowable.spring.job.service.SpringAsyncExecutor].

2020-04-17 10:55:38.780  INFO 35903 --- [      Thread-25] o.f.j.s.i.a.AcquireAsyncJobsDueRunnable  : starting to acquire async jobs due

2020-04-17 10:55:38.780  INFO 35903 --- [      Thread-26] o.f.j.s.i.a.AcquireTimerJobsRunnable     : starting to acquire async jobs due

2020-04-17 10:55:38.780  INFO 35903 --- [           main] o.f.cmmn.engine.impl.CmmnEngineImpl      : CmmnEngine default created

2020-04-17 10:55:38.781  INFO 35903 --- [      Thread-27] o.f.j.s.i.a.ResetExpiredJobsRunnable     : starting to reset expired jobs for engine cmmn

2020-04-17 10:55:38.897  INFO 35903 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM bladex_boot.ACT_APP_DATABASECHANGELOGLOCK

2020-04-17 10:55:38.907  INFO 35903 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM bladex_boot.ACT_APP_DATABASECHANGELOGLOCK

2020-04-17 10:55:38.916  INFO 35903 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT `LOCKED` FROM bladex_boot.ACT_APP_DATABASECHANGELOGLOCK WHERE ID=1

2020-04-17 10:55:38.935  INFO 35903 --- [           main] l.lockservice.StandardLockService        : Successfully acquired change log lock

2020-04-17 10:55:38.967  INFO 35903 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT MD5SUM FROM bladex_boot.ACT_APP_DATABASECHANGELOG WHERE MD5SUM IS NOT NULL LIMIT 1

2020-04-17 10:55:38.972  INFO 35903 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM bladex_boot.ACT_APP_DATABASECHANGELOG

2020-04-17 10:55:38.975  INFO 35903 --- [           main] l.c.StandardChangeLogHistoryService      : Reading from bladex_boot.ACT_APP_DATABASECHANGELOG

2020-04-17 10:55:38.976  INFO 35903 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT * FROM bladex_boot.ACT_APP_DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC

2020-04-17 10:55:38.992  WARN 35903 --- [           main] liquibase.changelog.DatabaseChangeLog    : modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use and re-specify all configuration if this is the case

2020-04-17 10:55:38.997  INFO 35903 --- [           main] liquibase.executor.jvm.JdbcExecutor      : CREATE TABLE bladex_boot.ACT_APP_DEPLOYMENT (ID_ VARCHAR(255) NOT NULL, NAME_ VARCHAR(255) NULL, CATEGORY_ VARCHAR(255) NULL, KEY_ VARCHAR(255) NULL, DEPLOY_TIME_ datetime NULL, TENANT_ID_ VARCHAR(255) DEFAULT '' NULL, CONSTRAINT PK_ACT_APP_DEPLOYMENT PRIMARY KEY (ID_))

2020-04-17 10:55:39.026 ERROR 35903 --- [           main] liquibase.changelog.ChangeSet            : Change Set org/flowable/app/db/liquibase/flowable-app-db-changelog.xml::1::flowable failed.  Error: Table 'ACT_APP_DEPLOYMENT' already exists [Failed SQL: CREATE TABLE bladex_boot.ACT_APP_DEPLOYMENT (ID_ VARCHAR(255) NOT NULL, NAME_ VARCHAR(255) NULL, CATEGORY_ VARCHAR(255) NULL, KEY_ VARCHAR(255) NULL, DEPLOY_TIME_ datetime NULL, TENANT_ID_ VARCHAR(255) DEFAULT '' NULL, CONSTRAINT PK_ACT_APP_DEPLOYMENT PRIMARY KEY (ID_))]

2020-04-17 10:55:39.032  INFO 35903 --- [           main] l.lockservice.StandardLockService        : Successfully released change log lock

2020-04-17 10:55:39.043  WARN 35903 --- [           main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'workController' defined in file [/Users/kuzan/Documents/blade/BladeX-Boot/target/classes/org/springblade/flow/business/controller/WorkController.class]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'taskServiceBean' defined in class path resource [org/flowable/spring/boot/ProcessEngineServicesAutoConfiguration.class]: Unsatisfied dependency expressed through method 'taskServiceBean' parameter 0; nested exception is 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; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flowableAppEngine': FactoryBean threw exception on object creation; nested exception is org.flowable.common.engine.api.FlowableException: Error initialising app data model

2020-04-17 10:55:39.044  INFO 35903 --- [           main] o.f.j.s.i.a.AbstractAsyncExecutor        : Shutting down the async job executor [org.flowable.spring.job.service.SpringAsyncExecutor].

2020-04-17 10:55:39.045  INFO 35903 --- [et-expired-jobs] o.f.j.s.i.a.ResetExpiredJobsRunnable     : stopped resetting expired jobs for engine cmmn

2020-04-17 10:55:39.045  INFO 35903 --- [uire-async-jobs] o.f.j.s.i.a.AcquireAsyncJobsDueRunnable  : stopped async job due acquisition for engine cmmn

2020-04-17 10:55:39.045  INFO 35903 --- [uire-timer-jobs] o.f.j.s.i.a.AcquireTimerJobsRunnable     : stopped async job due acquisition

2020-04-17 10:55:39.045  INFO 35903 --- [           main] o.f.j.s.i.a.AbstractAsyncExecutor        : Shutting down the async job executor [org.flowable.spring.job.service.SpringAsyncExecutor].

2020-04-17 10:55:39.045  INFO 35903 --- [et-expired-jobs] o.f.j.s.i.a.ResetExpiredJobsRunnable     : stopped resetting expired jobs for engine bpmn

2020-04-17 10:55:39.045  INFO 35903 --- [uire-timer-jobs] o.f.j.s.i.a.AcquireTimerJobsRunnable     : stopped async job due acquisition

2020-04-17 10:55:39.045  INFO 35903 --- [uire-async-jobs] o.f.j.s.i.a.AcquireAsyncJobsDueRunnable  : stopped async job due acquisition for engine bpmn

2020-04-17 10:55:39.045  INFO 35903 --- [           main] o.s.s.concurrent.ThreadPoolTaskExecutor  : Shutting down ExecutorService 'applicationTaskExecutor'

2020-04-17 10:55:39.045  INFO 35903 --- [           main] com.alibaba.druid.pool.DruidDataSource   : {dataSource-1} closing ...

2020-04-17 10:55:39.050  INFO 35903 --- [           main] com.alibaba.druid.pool.DruidDataSource   : {dataSource-1} closed

2020-04-17 10:55:39.061  INFO 35903 --- [           main] ConditionEvaluationReportLoggingListener : 


Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.

2020-04-17 10:55:39.069 ERROR 35903 --- [           main] o.s.boot.SpringApplication               : Application run failed


org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'workController' defined in file [/Users/kuzan/Documents/blade/BladeX-Boot/target/classes/org/springblade/flow/business/controller/WorkController.class]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'taskServiceBean' defined in class path resource [org/flowable/spring/boot/ProcessEngineServicesAutoConfiguration.class]: Unsatisfied dependency expressed through method 'taskServiceBean' parameter 0; nested exception is 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; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flowableAppEngine': FactoryBean threw exception on object creation; nested exception is org.flowable.common.engine.api.FlowableException: Error initialising app data model

at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:769)

at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:218)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1340)

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

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

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

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

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

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

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

at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:847)

at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:877)

at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:549)

at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:141)

at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:744)

at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:391)

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

at org.springframework.boot.builder.SpringApplicationBuilder.run(SpringApplicationBuilder.java:140)

at org.springblade.core.launch.BladeApplication.run(BladeApplication.java:49)

at org.springblade.Application.main(Application.java:34)

Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'taskServiceBean' defined in class path resource [org/flowable/spring/boot/ProcessEngineServicesAutoConfiguration.class]: Unsatisfied dependency expressed through method 'taskServiceBean' parameter 0; nested exception is 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; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flowableAppEngine': FactoryBean threw exception on object creation; nested exception is org.flowable.common.engine.api.FlowableException: Error initialising app data model

at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:769)

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

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

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

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

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

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

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

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

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

at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:277)

at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1255)

at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1175)

at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:857)

at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:760)

... 19 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; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flowableAppEngine': FactoryBean threw exception on object creation; nested exception is org.flowable.common.engine.api.FlowableException: Error initialising app data model

at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:769)

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

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

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

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

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

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

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

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

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

at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:277)

at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1255)

at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1175)

at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:857)

at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:760)

... 33 common frames omitted

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flowableAppEngine': FactoryBean threw exception on object creation; nested exception is org.flowable.common.engine.api.FlowableException: Error initialising app data model

at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:178)

at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:101)

at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1674)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.getObjectForBeanInstance(AbstractAutowireCapableBeanFactory.java:1248)

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

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

at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:277)

at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1255)

at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1175)

at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:857)

at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:760)

... 47 common frames omitted

Caused by: org.flowable.common.engine.api.FlowableException: Error initialising app data model

at org.flowable.common.engine.impl.db.LiquibaseBasedSchemaManager.initSchema(LiquibaseBasedSchemaManager.java:68)

at org.flowable.app.engine.impl.db.AppDbSchemaManager.initSchema(AppDbSchemaManager.java:37)

at org.flowable.app.engine.impl.cmd.SchemaOperationsAppEngineBuild.execute(SchemaOperationsAppEngineBuild.java:27)

at org.flowable.app.engine.impl.cmd.SchemaOperationsAppEngineBuild.execute(SchemaOperationsAppEngineBuild.java:23)

at org.flowable.app.engine.impl.interceptor.AppCommandInvoker.execute(AppCommandInvoker.java:35)

at org.flowable.common.engine.impl.interceptor.TransactionContextInterceptor.execute(TransactionContextInterceptor.java:53)

at org.flowable.common.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:72)

at org.flowable.common.spring.SpringTransactionInterceptor.lambda$execute$0(SpringTransactionInterceptor.java:56)

at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)

at org.flowable.common.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:56)

at org.flowable.common.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:30)

at org.flowable.common.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:56)

at org.flowable.app.engine.impl.AppEngineImpl.(AppEngineImpl.java:44)

at org.flowable.app.engine.AppEngineConfiguration.buildAppEngine(AppEngineConfiguration.java:182)

at org.flowable.app.spring.SpringAppEngineConfiguration.buildAppEngine(SpringAppEngineConfiguration.java:63)

at org.flowable.app.spring.AppEngineFactoryBean.getObject(AppEngineFactoryBean.java:59)

at org.flowable.app.spring.AppEngineFactoryBean.getObject(AppEngineFactoryBean.java:31)

at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:171)

... 57 common frames omitted

Caused by: org.flowable.common.engine.api.FlowableException: Error updating App engine tables

at org.flowable.app.engine.impl.db.AppDbSchemaManager.schemaUpdate(AppDbSchemaManager.java:95)

at org.flowable.common.engine.impl.db.LiquibaseBasedSchemaManager.initSchema(LiquibaseBasedSchemaManager.java:61)

... 74 common frames omitted

Caused by: org.flowable.common.engine.api.FlowableException: Error updating app engine tables

at org.flowable.common.engine.impl.db.LiquibaseBasedSchemaManager.schemaUpdate(LiquibaseBasedSchemaManager.java:105)

at org.flowable.app.engine.impl.db.AppDbSchemaManager.schemaUpdate(AppDbSchemaManager.java:92)

... 75 common frames omitted

Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set org/flowable/app/db/liquibase/flowable-app-db-changelog.xml::1::flowable:

     Reason: liquibase.exception.DatabaseException: Table 'ACT_APP_DEPLOYMENT' already exists [Failed SQL: CREATE TABLE bladex_boot.ACT_APP_DEPLOYMENT (ID_ VARCHAR(255) NOT NULL, NAME_ VARCHAR(255) NULL, CATEGORY_ VARCHAR(255) NULL, KEY_ VARCHAR(255) NULL, DEPLOY_TIME_ datetime NULL, TENANT_ID_ VARCHAR(255) DEFAULT '' NULL, CONSTRAINT PK_ACT_APP_DEPLOYMENT PRIMARY KEY (ID_))]

at liquibase.changelog.ChangeSet.execute(ChangeSet.java:637)

at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:53)

at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:83)

at liquibase.Liquibase.update(Liquibase.java:202)

at liquibase.Liquibase.update(Liquibase.java:179)

at liquibase.Liquibase.update(Liquibase.java:175)

at liquibase.Liquibase.update(Liquibase.java:168)

at org.flowable.common.engine.impl.db.LiquibaseBasedSchemaManager.schemaUpdate(LiquibaseBasedSchemaManager.java:103)

... 76 common frames omitted

Caused by: liquibase.exception.DatabaseException: Table 'ACT_APP_DEPLOYMENT' already exists [Failed SQL: CREATE TABLE bladex_boot.ACT_APP_DEPLOYMENT (ID_ VARCHAR(255) NOT NULL, NAME_ VARCHAR(255) NULL, CATEGORY_ VARCHAR(255) NULL, KEY_ VARCHAR(255) NULL, DEPLOY_TIME_ datetime NULL, TENANT_ID_ VARCHAR(255) DEFAULT '' NULL, CONSTRAINT PK_ACT_APP_DEPLOYMENT PRIMARY KEY (ID_))]

at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:356)

at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:57)

at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:125)

at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1229)

at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1211)

at liquibase.changelog.ChangeSet.execute(ChangeSet.java:600)

... 83 common frames omitted

Caused by: java.sql.SQLSyntaxErrorException: Table 'ACT_APP_DEPLOYMENT' already exists

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

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

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

at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764)

at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)

at com.alibaba.druid.pool.DruidPooledStatement.execute(DruidPooledStatement.java:633)

at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:352)

... 88 common frames omitted


Disconnected from the target VM, address: '127.0.0.1:50947', transport: 'socket'


Process finished with exit code 1



1条回答
  • 这个应该是liquibase的问题,服务器部署的boot或者数据库内的版本较低,然后本地较高版本启动有可能会出错。后续会优化一下,禁用liquibase,这样启动就不会去自动更新表了

    0 讨论(1)
提交回复