Error after restart Tomcat - Flowable with Mysql

i’m using Flowable 6.6.0 anf Mysql 5.7.26 in a docker-compose.
At the first run, everything works perfectly.
If i turn off, the stack and start it again to check persistency, tomcat start, but flowable-ui can’t start again.

Log of tomcat container:

05-May-2021 12:37:57.310 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version: Apache Tomcat/8.0.53
05-May-2021 12:37:57.312 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: Jun 29 2018 14:42:45 UTC
05-May-2021 12:37:57.312 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number: 8.0.53.0
05-May-2021 12:37:57.312 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Linux
05-May-2021 12:37:57.312 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 4.4.0-47-generic
05-May-2021 12:37:57.312 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture: amd64
05-May-2021 12:37:57.313 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: /usr/lib/jvm/java-8-openjdk-amd64/jre
05-May-2021 12:37:57.313 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 1.8.0_181-8u181-b13-1~deb9u1-b13
05-May-2021 12:37:57.313 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor: Oracle Corporation
05-May-2021 12:37:57.313 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: /usr/local/tomcat
05-May-2021 12:37:57.313 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: /usr/local/tomcat
05-May-2021 12:37:57.313 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/usr/local/tomcat/conf/logging.properties
05-May-2021 12:37:57.314 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
05-May-2021 12:37:57.314 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
05-May-2021 12:37:57.314 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
05-May-2021 12:37:57.314 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs=
05-May-2021 12:37:57.314 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/usr/local/tomcat
05-May-2021 12:37:57.314 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/usr/local/tomcat
05-May-2021 12:37:57.314 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/usr/local/tomcat/temp
05-May-2021 12:37:57.315 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent Loaded APR based Apache Tomcat Native library 1.2.17 using APR version 1.5.2.
05-May-2021 12:37:57.315 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].
05-May-2021 12:37:57.318 INFO [main] org.apache.catalina.core.AprLifecycleListener.initializeSSL OpenSSL successfully initialized (OpenSSL 1.1.0f 25 May 2017)
05-May-2021 12:37:57.387 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler [“http-apr-8080”]
05-May-2021 12:37:57.394 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler [“ajp-apr-8009”]
05-May-2021 12:37:57.396 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 400 ms
05-May-2021 12:37:57.424 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service Catalina
05-May-2021 12:37:57.424 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.0.53
05-May-2021 12:37:57.446 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive /usr/local/tomcat/webapps/flowable-ui.war
05-May-2021 12:38:03.500 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
////////// &&&& &&& , ,
////////////// &&&&&&& &&& , ,
/// /// &&& &&& , ,
//////// /// &&&&&&&& &&& &&&&&&& &&& &&& &&& , , , ,
////// // /// &&&&&&&& &&& &&&& &&&& &&& &&& &&& , , , , , , ,
/// //// /// &&& &&& &&& &&& &&& &&& &&& , , , , , ,
// ///// /// &&& &&& &&& &&&& &&& &&& &&& , , , , , ,
/////////// &&& &&& &&&&&&&& &&&&&&&&&&&&&& , , , ,
:: Flowable :: (v6.6.0) :: Spring Boot :: (v2.3.4.RELEASE)
2021-05-05 12:38:04.936 INFO 1 — [ost-startStop-1] o.f.u.application.FlowableUiApplication : Starting FlowableUiApplication v6.6.0 on 159976fd0981 with PID 1 (/usr/local/tomcat/webapps/flowable-ui/WEB-INF/classes started by root in /usr/local/tomcat)
2021-05-05 12:38:04.951 INFO 1 — [ost-startStop-1] o.f.u.application.FlowableUiApplication : No active profile set, falling back to default profiles: default
2021-05-05 12:38:08.794 INFO 1 — [ost-startStop-1] trationDelegate$BeanPostProcessorChecker : Bean ‘org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@17526fac’ of type [org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2021-05-05 12:38:08.807 INFO 1 — [ost-startStop-1] trationDelegate$BeanPostProcessorChecker : Bean ‘org.flowable.ui.common.properties.FlowableRemoteIdmAutoConfiguration’ of type [org.flowable.ui.common.properties.FlowableRemoteIdmAutoConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2021-05-05 12:38:08.860 INFO 1 — [ost-startStop-1] trationDelegate$BeanPostProcessorChecker : Bean ‘flowable.common.app-org.flowable.ui.common.properties.FlowableCommonAppProperties’ of type [org.flowable.ui.common.properties.FlowableCommonAppProperties] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2021-05-05 12:38:08.861 INFO 1 — [ost-startStop-1] trationDelegate$BeanPostProcessorChecker : Bean ‘grantedAuthorityDefaults’ of type [org.springframework.security.config.core.GrantedAuthorityDefaults] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2021-05-05 12:38:08.866 INFO 1 — [ost-startStop-1] trationDelegate$BeanPostProcessorChecker : Bean ‘methodSecurityMetadataSource’ of type [org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2021-05-05 12:38:08.897 INFO 1 — [ost-startStop-1] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 3214 ms
2021-05-05 12:38:09.867 INFO 1 — [ost-startStop-1] o.f.s.b.ProcessEngineAutoConfiguration : No deployment resources were found for autodeployment
2021-05-05 12:38:09.934 INFO 1 — [ost-startStop-1] o.s.s.concurrent.ThreadPoolTaskExecutor : Initializing ExecutorService ‘applicationTaskExecutor’
2021-05-05 12:38:10.293 INFO 1 — [ost-startStop-1] o.f.s.b.c.CmmnEngineAutoConfiguration : No deployment resources were found for autodeployment
2021-05-05 12:38:10.476 INFO 1 — [ost-startStop-1] o.f.s.b.dmn.DmnEngineAutoConfiguration : No deployment resources were found for autodeployment
2021-05-05 12:38:10.544 INFO 1 — [ost-startStop-1] o.f.s.b.f.FormEngineAutoConfiguration : No deployment resources were found for autodeployment
2021-05-05 12:38:10.614 INFO 1 — [ost-startStop-1] o.f.s.b.e.EventRegistryAutoConfiguration : No deployment resources were found for autodeployment
2021-05-05 12:38:10.667 INFO 1 — [ost-startStop-1] o.f.s.b.app.AppEngineAutoConfiguration : No deployment resources were found for autodeployment
2021-05-05 12:38:10.739 INFO 1 — [ost-startStop-1] o.f.a.s.SpringAppEngineConfiguration : Found 7 Engine Configurators in total:
2021-05-05 12:38:10.740 INFO 1 — [ost-startStop-1] o.f.a.s.SpringAppEngineConfiguration : class org.flowable.engine.spring.configurator.SpringProcessEngineConfigurator (priority:50000)
2021-05-05 12:38:10.741 INFO 1 — [ost-startStop-1] o.f.a.s.SpringAppEngineConfiguration : class org.flowable.eventregistry.spring.configurator.SpringEventRegistryConfigurator (priority:100000)
2021-05-05 12:38:10.741 INFO 1 — [ost-startStop-1] o.f.a.s.SpringAppEngineConfiguration : class org.flowable.idm.spring.configurator.SpringIdmEngineConfigurator (priority:150000)
2021-05-05 12:38:10.741 INFO 1 — [ost-startStop-1] o.f.a.s.SpringAppEngineConfiguration : class org.flowable.dmn.spring.configurator.SpringDmnEngineConfigurator (priority:200000)
2021-05-05 12:38:10.741 INFO 1 — [ost-startStop-1] o.f.a.s.SpringAppEngineConfiguration : class org.flowable.form.spring.configurator.SpringFormEngineConfigurator (priority:300000)
2021-05-05 12:38:10.741 INFO 1 — [ost-startStop-1] o.f.a.s.SpringAppEngineConfiguration : class org.flowable.content.spring.configurator.SpringContentEngineConfigurator (priority:400000)
2021-05-05 12:38:10.741 INFO 1 — [ost-startStop-1] o.f.a.s.SpringAppEngineConfiguration : class org.flowable.cmmn.spring.configurator.SpringCmmnEngineConfigurator (priority:500000)
2021-05-05 12:38:10.742 INFO 1 — [ost-startStop-1] o.f.a.s.SpringAppEngineConfiguration : Executing beforeInit() of class org.flowable.engine.spring.configurator.SpringProcessEngineConfigurator (priority:50000)
2021-05-05 12:38:10.884 INFO 1 — [ost-startStop-1] o.f.a.s.SpringAppEngineConfiguration : Executing beforeInit() of class org.flowable.eventregistry.spring.configurator.SpringEventRegistryConfigurator (priority:100000)
2021-05-05 12:38:10.889 INFO 1 — [ost-startStop-1] o.f.a.s.SpringAppEngineConfiguration : Executing beforeInit() of class org.flowable.idm.spring.configurator.SpringIdmEngineConfigurator (priority:150000)
2021-05-05 12:38:10.892 INFO 1 — [ost-startStop-1] o.f.a.s.SpringAppEngineConfiguration : Executing beforeInit() of class org.flowable.dmn.spring.configurator.SpringDmnEngineConfigurator (priority:200000)
2021-05-05 12:38:10.895 INFO 1 — [ost-startStop-1] o.f.a.s.SpringAppEngineConfiguration : Executing beforeInit() of class org.flowable.form.spring.configurator.SpringFormEngineConfigurator (priority:300000)
2021-05-05 12:38:10.899 INFO 1 — [ost-startStop-1] o.f.a.s.SpringAppEngineConfiguration : Executing beforeInit() of class org.flowable.content.spring.configurator.SpringContentEngineConfigurator (priority:400000)
2021-05-05 12:38:10.902 INFO 1 — [ost-startStop-1] o.f.a.s.SpringAppEngineConfiguration : Executing beforeInit() of class org.flowable.cmmn.spring.configurator.SpringCmmnEngineConfigurator (priority:500000)
2021-05-05 12:38:10.930 INFO 1 — [ost-startStop-1] com.zaxxer.hikari.HikariDataSource : flowable-ui - Starting…
2021-05-05 12:38:11.386 INFO 1 — [ost-startStop-1] com.zaxxer.hikari.HikariDataSource : flowable-ui - Start completed.
2021-05-05 12:38:12.983 INFO 1 — [ost-startStop-1] o.f.a.s.SpringAppEngineConfiguration : Executing configure() of class org.flowable.engine.spring.configurator.SpringProcessEngineConfigurator (priority:50000)
2021-05-05 12:38:13.473 INFO 1 — [ost-startStop-1] o.f.engine.impl.ProcessEngineImpl : ProcessEngine default created
2021-05-05 12:38:13.544 INFO 1 — [ost-startStop-1] o.f.e.impl.cmd.ValidateV5EntitiesCmd : Total of v5 deployments found: 0
2021-05-05 12:38:13.550 INFO 1 — [ost-startStop-1] o.f.a.s.SpringAppEngineConfiguration : Executing configure() of class org.flowable.eventregistry.spring.configurator.SpringEventRegistryConfigurator (priority:100000)
2021-05-05 12:38:14.644 INFO 1 — [ost-startStop-1] liquibase.executor.jvm.JdbcExecutor : SELECT COUNT() FROM flowable.FLW_EV_DATABASECHANGELOGLOCK
2021-05-05 12:38:14.646 INFO 1 — [ost-startStop-1] liquibase.executor.jvm.JdbcExecutor : SELECT COUNT(
) FROM flowable.FLW_EV_DATABASECHANGELOGLOCK
2021-05-05 12:38:14.649 INFO 1 — [ost-startStop-1] liquibase.executor.jvm.JdbcExecutor : SELECT LOCKED FROM flowable.FLW_EV_DATABASECHANGELOGLOCK WHERE ID=1
2021-05-05 12:38:14.665 INFO 1 — [ost-startStop-1] l.lockservice.StandardLockService : Successfully acquired change log lock
2021-05-05 12:38:15.849 INFO 1 — [ost-startStop-1] liquibase.executor.jvm.JdbcExecutor : SELECT MD5SUM FROM flowable.FLW_EV_DATABASECHANGELOG WHERE MD5SUM IS NOT NULL LIMIT 1
2021-05-05 12:38:15.851 INFO 1 — [ost-startStop-1] liquibase.executor.jvm.JdbcExecutor : SELECT COUNT(*) FROM flowable.FLW_EV_DATABASECHANGELOG
2021-05-05 12:38:15.851 INFO 1 — [ost-startStop-1] l.c.StandardChangeLogHistoryService : Reading from flowable.FLW_EV_DATABASECHANGELOG
2021-05-05 12:38:15.852 INFO 1 — [ost-startStop-1] liquibase.executor.jvm.JdbcExecutor : SELECT * FROM flowable.FLW_EV_DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
2021-05-05 12:38:15.856 INFO 1 — [ost-startStop-1] l.lockservice.StandardLockService : Successfully released change log lock
2021-05-05 12:38:15.858 WARN 1 — [ost-startStop-1] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘idmSecurityConfiguration’: Unsatisfied dependency expressed through field ‘identityService’; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘idmIdentityService’ defined in class path resource [org/flowable/spring/boot/idm/IdmEngineServicesAutoConfiguration.class]: Unsatisfied dependency expressed through method ‘idmIdentityService’ parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘idmEngine’ defined in class path resource [org/flowable/spring/boot/idm/IdmEngineServicesAutoConfiguration$AlreadyInitializedAppEngineConfiguration.class]: Unsatisfied dependency expressed through method ‘idmEngine’ 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 eventregistry data model
2021-05-05 12:38:15.861 INFO 1 — [ost-startStop-1] o.s.s.concurrent.ThreadPoolTaskExecutor : Shutting down ExecutorService ‘applicationTaskExecutor’
2021-05-05 12:38:15.861 INFO 1 — [ost-startStop-1] com.zaxxer.hikari.HikariDataSource : flowable-ui - Shutdown initiated…
2021-05-05 12:38:15.888 INFO 1 — [ost-startStop-1] com.zaxxer.hikari.HikariDataSource : flowable-ui - Shutdown completed.
2021-05-05 12:38:15.924 INFO 1 — [ost-startStop-1] ConditionEvaluationReportLoggingListener :
Error starting ApplicationContext. To display the conditions report re-run your application with ‘debug’ enabled.
2021-05-05 12:38:15.940 ERROR 1 — [ost-startStop-1] o.s.boot.SpringApplication : Application run failed
org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘idmSecurityConfiguration’: Unsatisfied dependency expressed through field ‘identityService’; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘idmIdentityService’ defined in class path resource [org/flowable/spring/boot/idm/IdmEngineServicesAutoConfiguration.class]: Unsatisfied dependency expressed through method ‘idmIdentityService’ parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘idmEngine’ defined in class path resource [org/flowable/spring/boot/idm/IdmEngineServicesAutoConfiguration$AlreadyInitializedAppEngineConfiguration.class]: Unsatisfied dependency expressed through method ‘idmEngine’ 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 eventregistry data model
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:643) ~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:130) ~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:399) ~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1420) ~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:593) ~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
…/…
Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘idmIdentityService’ defined in class path resource [org/flowable/spring/boot/idm/IdmEngineServicesAutoConfiguration.class]: Unsatisfied dependency expressed through method ‘idmIdentityService’ parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘idmEngine’ defined in class path resource [org/flowable/spring/boot/idm/IdmEngineServicesAutoConfiguration$AlreadyInitializedAppEngineConfiguration.class]: Unsatisfied dependency expressed through method ‘idmEngine’ 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 eventregistry data model
at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:797) ~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
…/…
Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘idmEngine’ defined in class path resource [org/flowable/spring/boot/idm/IdmEngineServicesAutoConfiguration$AlreadyInitializedAppEngineConfiguration.class]: Unsatisfied dependency expressed through method ‘idmEngine’ 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 eventregistry data model
…/…
05-May-2021 12:38:15.942 SEVERE [localhost-startStop-1] org.apache.catalina.core.ContainerBase.addChildInternal ContainerBase.addChild: start:
org.apache.catalina.LifecycleException: Failed to start component [StandardEngine[Catalina].StandardHost[localhost].StandardContext[/flowable-ui]]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:162)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:755)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:731)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:973)
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1850)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
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:748)
Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘idmSecurityConfiguration’: Unsatisfied dependency expressed through field ‘identityService’; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘idmIdentityService’ defined in class path resource [org/flowable/spring/boot/idm/IdmEngineServicesAutoConfiguration.class]: Unsatisfied dependency expressed through method ‘idmIdentityService’ parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘idmEngine’ defined in class path resource [org/flowable/spring/boot/idm/IdmEngineServicesAutoConfiguration$AlreadyInitializedAppEngineConfiguration.class]: Unsatisfied dependency expressed through method ‘idmEngine’ 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 eventregistry data model
at …/…
Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘idmIdentityService’ defined in class path resource [org/flowable/spring/boot/idm/IdmEngineServicesAutoConfiguration.class]: Unsatisfied dependency expressed through method ‘idmIdentityService’ parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘idmEngine’ defined in class path resource [org/flowable/spring/boot/idm/IdmEngineServicesAutoConfiguration$AlreadyInitializedAppEngineConfiguration.class]: Unsatisfied dependency expressed through method ‘idmEngine’ 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 eventregistry data model
at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:797)
at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:538)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1336)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1176)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:556)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:516)
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:324)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1307)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1227)
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:640)
… 33 more
Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘idmEngine’ defined in class path resource [org/flowable/spring/boot/idm/IdmEngineServicesAutoConfiguration$AlreadyInitializedAppEngineConfiguration.class]: Unsatisfied dependency expressed through method ‘idmEngine’ 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 eventregistry data model
at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:797)
…/…
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 eventregistry data model
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:176)
…/…
Caused by: org.flowable.common.engine.api.FlowableException: Error initialising eventregistry data model
at org.flowable.common.engine.impl.db.LiquibaseBasedSchemaManager.initSchema(LiquibaseBasedSchemaManager.java:68)
at …/…
Caused by: org.flowable.common.engine.api.FlowableException: Error updating eventregistry engine tables
at org.flowable.common.engine.impl.db.LiquibaseBasedSchemaManager.schemaUpdate(LiquibaseBasedSchemaManager.java:105)
at org.flowable.eventregistry.impl.db.EventDbSchemaManager.schemaUpdate(EventDbSchemaManager.java:63)
at org.flowable.common.engine.impl.db.LiquibaseBasedSchemaManager.initSchema(LiquibaseBasedSchemaManager.java:61)
… 93 more
Caused by: java.lang.ClassCastException: java.time.LocalDateTime cannot be cast to java.lang.String
at liquibase.changelog.StandardChangeLogHistoryService.getRanChangeSets(StandardChangeLogHistoryService.java:328)
at liquibase.changelog.AbstractChangeLogHistoryService.upgradeChecksums(AbstractChangeLogHistoryService.java:66)
at liquibase.changelog.StandardChangeLogHistoryService.upgradeChecksums(StandardChangeLogHistoryService.java:297)
at liquibase.Liquibase.checkLiquibaseTables(Liquibase.java:1234)
at liquibase.Liquibase.update(Liquibase.java:193)
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)
… 95 more
05-May-2021 12:38:15.949 SEVERE [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Error deploying web application archive /usr/local/tomcat/webapps/flowable-ui.war
java.lang.IllegalStateException: ContainerBase.addChild: start: org.apache.catalina.LifecycleException: Failed to start component [StandardEngine[Catalina].StandardHost[localhost].StandardContext[/flowable-ui]]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:731)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:973)
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1850)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
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:748)
05-May-2021 12:38:15.954 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive /usr/local/tomcat/webapps/flowable-ui.war has finished in 18,506 ms
…/…

here’s docker-compose.yml

version: ‘2.0’
services:
mysql-db:
image: mysql:5.7.26
container_name: flowable-mysql-mysql-5.7.26
command: --default-authentication-plugin=mysql_native_password
restart: always
volumes:
- db_data:/var/lib/mysql
environment:
MYSQL_ROOT_PASSWORD: flowable
MYSQL_USER: flowable
MYSQL_PASSWORD: flowable
MYSQL_DATABASE: flowable
ports:
- “3306:3306”
networks:
- flowable-mysql

adminer:
image: adminer
restart: always
ports:
- 18080:8080
networks:
- flowable-mysql

tomcat:
build: .
image: tomcat:8.0-jre8
ports:
- “8080:8080” # Forward the exposed port 8080 on the container to port 8080 on the host machine
environment:
- SPRING_DATASOURCE_DRIVER-CLASS-NAME=com.mysql.cj.jdbc.Driver
- SPRING_DATASOURCE_URL=jdbc:mysql://mysql-db:3306/flowable?autoReconnect=true
depends_on:
- mysql-db # This service depends on mysql. Start that first.
restart: always
networks:
- flowable-mysql

networks:
flowable-mysql:

volumes:
db_data: {}

and here’s Dockerfile for tomcat container:

FROM ubuntu:latest AS base

RUN apt-get update && apt-get install -y wget zip

WORKDIR /src

ENV FLOWABLE_VERSION=6.6.0
ENV MYSQL_CONNECTOR_VERSION=8.0.24

RUN wget https://github.com/flowable/flowable-engine/releases/download/flowable-$FLOWABLE_VERSION/flowable-$FLOWABLE_VERSION.zip
RUN unzip flowable-$FLOWABLE_VERSION.zip

RUN wget https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-$MYSQL_CONNECTOR_VERSION.zip
RUN unzip mysql-connector-java-$MYSQL_CONNECTOR_VERSION.zip

FROM tomcat:8.0-jre8

ENV DIRPATH /usr/local/tomcat
ENV FLOWABLE_VERSION=6.6.0
ENV MYSQL_CONNECTOR_VERSION=8.0.24

COPY ./tomcat-users.xml $DIRPATH/conf

COPY --from=base /src/mysql-connector-java-$MYSQL_CONNECTOR_VERSION/*.jar $DIRPATH/lib

COPY --from=base /src/flowable-$FLOWABLE_VERSION/wars/flowable-ui.war $DIRPATH/webapps

COPY --from=base /src/flowable-$FLOWABLE_VERSION/wars/flowable-rest.war $DIRPATH/webapps

EXPOSE 8080

CMD [“catalina.sh”, “run”]

Hi,

have a look here Upgrade mysql-jdbc-drivers 8.0.23, liquibase threw exceptions · Issue #2836 · flowable/flowable-engine · GitHub

(use mysql version 8.0.22)

Regards,

Yvo

Thanks that fix my problem.

I had started with flowable 6.5.0 and mysql driver 8.0.20 but it did not work, so I tried to upgrade, but not tried every intermediate combinations …
Best regards

Sébastien Dejean