Flowable工作流数据库迁移及问题记录

最新推荐文章于 2024-08-19 17:43:10 发布

fenccc

最新推荐文章于 2024-08-19 17:43:10 发布

阅读量1.5k

点赞数 8

分类专栏： Flowable工作流文章标签：数据库 java

本文链接：https://blog.csdn.net/FengChSvip/article/details/135184664

版权

Flowable工作流专栏收录该内容

1 篇文章 0 订阅

订阅专栏

一、工作流数据库迁移

由于Flowable工作流数据库数据量越来越多，导致查询时间越来越慢。因此需要将部分模块数据迁移至新数据库。

1.1 创建新数据库

// 创建数据库
create database `xx-flowable`;
// 创建用户
create user 'xxxx'@'%' identified by 'xxxxxxxx';
// 给用户授权
grant all privileges on `xx-flowable`.* to 'xxxx'@'%';

1.2 构建Flowable工程

在新工程中输入新数据库名，在application.yml中配置以下代码。

flowable:
  async-executor-activate: true
  database-schema-update: true

运行工程后数据库中会自动创建下图中的数据库表。
在这里插入图片描述

1.3 迁移数据

以下是需要迁移数据的数据库表：
在这里插入图片描述

1.4 迁移SQL

-- 1、act_re_procdef			
INSERT INTO `xx-flowable`.ACT_RE_PROCDEF SELECT			
	t.*		
FROM			
	`xx-admin`.ACT_RE_PROCDEF t		
WHERE			
	LOCATE('关键字', t.KEY_) > 0		
			
-- 2、act_re_deployment			
INSERT INTO `xx-flowable`.ACT_RE_DEPLOYMENT SELECT			
	t.*		
FROM			
	`xx-admin`.ACT_RE_DEPLOYMENT t		
INNER JOIN `xx-flowable`.ACT_RE_PROCDEF arp ON arp.DEPLOYMENT_ID_ = t.ID_			
			
-- 3、act_ge_bytearray			
INSERT INTO `xx-flowable`.ACT_GE_BYTEARRAY SELECT			
	t.*		
FROM			
	`xx-admin`.ACT_GE_BYTEARRAY t		
INNER JOIN `xx-flowable`.ACT_RE_PROCDEF arp ON arp.DEPLOYMENT_ID_ = t.DEPLOYMENT_ID_			
			
-- 4、act_hi_actinst			
INSERT INTO `xx-flowable`.ACT_HI_ACTINST (			
	SELECT		
		t.*	
	FROM		
		`xx-admin`.ACT_HI_ACTINST t	
	INNER JOIN `xx-flowable`.ACT_RE_PROCDEF arp ON arp.ID_ = t.PROC_DEF_ID_		
)			
			
-- 5、act_hi_taskinst			
INSERT INTO `xx-flowable`.ACT_HI_TASKINST (			
	SELECT		
		t.*	
	FROM		
		`xx-admin`.ACT_HI_TASKINST t	
	INNER JOIN `xx-flowable`.ACT_RE_PROCDEF arp ON arp.ID_ = t.PROC_DEF_ID_		
)			
			
-- 6、act_hi_comment			
INSERT INTO `xx-flowable`.ACT_HI_COMMENT (			
	SELECT		
		t.*	
	FROM		
		`xx-admin`.ACT_HI_COMMENT t	
	INNER JOIN `xx-flowable`.ACT_HI_TASKINST aht ON aht.ID_ = t.TASK_ID_		
)			
			
-- 7、act_hi_varinst			
INSERT INTO `xx-flowable`.ACT_HI_VARINST (			
	SELECT		
		t.*	
	FROM		
		`xx-admin`.ACT_HI_VARINST t	
	INNER JOIN `xx-canteen`.xx-apply oa ON oa.process_id = t.PROC_INST_ID_		
-- 	INNER JOIN `xx-flowable`.ACT_HI_TASKINST aht ON aht.PROC_INST_ID_ = t.PROC_INST_ID_  -- 会报重复key错误		
)			
			
-- 8、act_hi_procinst			
INSERT INTO `xx-flowable`.ACT_HI_PROCINST (			
	SELECT		
		t.*	
	FROM		
		`xx-admin`.ACT_HI_PROCINST t	
	INNER JOIN `xx-canteen`.xx-apply oa ON oa.process_id = t.PROC_INST_ID_		
)			
			
-- 9、act_hi_identitylink			
9.1			
INSERT INTO `xx-flowable`.ACT_HI_IDENTITYLINK (			
	SELECT		
		t.*	
	FROM		
		`xx-admin`.ACT_HI_IDENTITYLINK t	
	INNER JOIN `xx-canteen`.xx-apply oa ON oa.process_id = t.PROC_INST_ID_		
-- 	INNER JOIN `xx-flowable`.ACT_HI_TASKINST art ON art.PROC_INST_ID_ = t.PROC_INST_ID_ -- 会报重复key错误		
)			
9.2			
INSERT INTO `xx-flowable`.ACT_HI_IDENTITYLINK (			
	SELECT		
		t.*	
	FROM		
		`xx-admin`.ACT_HI_IDENTITYLINK t	
	INNER JOIN `xx-flowable`.ACT_HI_TASKINST art ON art.ID_ = t.TASK_ID_		
)			
			
-- 10、ACT_RU_EXECUTION			
-- 导成Sql文件插入数据 使用sql会报无法添加或更新子行：外键约束失败					
-- INSERT INTO `xx-flowable`.ACT_RU_EXECUTION (			
-- 	SELECT		
-- 		t.*	
-- 	FROM		
-- 		`xx-admin`.ACT_RU_EXECUTION t	
-- 	INNER JOIN `xx-flowable`.ACT_RE_PROCDEF arp ON arp.ID_ = t.PROC_DEF_ID_		
-- )						
			
-- 11、act_ru_task			
INSERT INTO `xx-flowable`.ACT_RU_TASK (			
	SELECT		
		t.*	
	FROM		
		`xx-admin`.ACT_RU_TASK t	
	INNER JOIN `xx-flowable`.ACT_RE_PROCDEF arp ON arp.ID_ = t.PROC_DEF_ID_		
)			
			
-- 12、act_ru_variable			
INSERT INTO `xx-flowable`.ACT_RU_VARIABLE (			
	SELECT		
		t.*	
	FROM		
		`xx-admin`.ACT_RU_VARIABLE t	
	INNER JOIN `xx-flowable`.ACT_RU_TASK art ON art.PROC_INST_ID_ = t.PROC_INST_ID_		
)			
			
-- 13、act_ru_identitylink			
13.1			
INSERT INTO `xx-flowable`.ACT_RU_IDENTITYLINK (			
	SELECT		
		t.*	
	FROM		
		`xx-admin`.ACT_RU_IDENTITYLINK t	
	INNER JOIN `xx-flowable`.ACT_RU_TASK art ON art.PROC_INST_ID_ = t.PROC_INST_ID_		
)			
13.2			
INSERT INTO `xx-flowable`.ACT_RU_IDENTITYLINK (			
	SELECT		
		t.*	
	FROM		
		`xx-admin`.ACT_RU_IDENTITYLINK t	
	INNER JOIN `xx-flowable`.ACT_RU_TASK art ON art.ID_ = t.TASK_ID_		
)			
			
-- 14、act_ru_actinst			
INSERT INTO `xx-flowable`.ACT_RU_ACTINST (			
	SELECT		
		t.*	
	FROM		
		`xx-admin`.ACT_RU_ACTINST t	
	INNER JOIN `xx-flowable`.ACT_RU_TASK art ON art.PROC_INST_ID_ = t.PROC_INST_ID_		
)			
			
-- 12、删除ACT_RU_EXECUTION表其他模块数据			
SELECT			
	*		
FROM			
	`xx-flowable`.ACT_RU_EXECUTION t		
WHERE			
	t.PROC_DEF_ID_ NOT IN (		
		SELECT	
			a.ID_
		FROM	
			`xx-flowable`.ACT_RE_PROCDEF a

数据库到此就迁移成功了。

二、迁移中遇到的问题

本地测试没有遇到什么问题，但部署后却发现Flowable工程启动时却报以下错误。

2023-12-23T02:24:26.951513940Z java.lang.NullPointerException: null
2023-12-23T02:24:26.951517573Z  at org.flowable.engine.impl.db.ProcessDbSchemaManager.schemaUpdate(ProcessDbSchemaManager.java:185)
2023-12-23T02:24:26.951532364Z  at org.flowable.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:54)
2023-12-23T02:24:26.951535867Z  at org.flowable.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:28)
2023-12-23T02:24:26.951538930Z  at org.flowable.engine.impl.interceptor.CommandInvoker$1.run(CommandInvoker.java:51)
2023-12-23T02:24:26.951541964Z  at org.flowable.engine.impl.interceptor.CommandInvoker.executeOperation(CommandInvoker.java:93)
2023-12-23T02:24:26.951544952Z  at org.flowable.engine.impl.interceptor.CommandInvoker.executeOperations(CommandInvoker.java:72)
2023-12-23T02:24:26.951547888Z  at org.flowable.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:56)
2023-12-23T02:24:26.951550797Z  at org.flowable.engine.impl.interceptor.BpmnOverrideContextInterceptor.execute(BpmnOverrideContextInterceptor.java:25)
2023-12-23T02:24:26.951553867Z  at org.flowable.common.engine.impl.interceptor.TransactionContextInterceptor.execute(TransactionContextInterceptor.java:53)
2023-12-23T02:24:26.951556850Z  at org.flowable.common.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:71)
2023-12-23T02:24:26.951559844Z  at org.flowable.common.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:49)
2023-12-23T02:24:26.951562813Z  at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)
2023-12-23T02:24:26.951565867Z  at org.flowable.common.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:46)
2023-12-23T02:24:26.951568836Z  at org.flowable.common.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:30)
2023-12-23T02:24:26.951571748Z  at org.flowable.common.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:56)
2023-12-23T02:24:26.951574721Z  at org.flowable.engine.impl.ProcessEngineImpl.<init>(ProcessEngineImpl.java:78)
2023-12-23T02:24:26.951577948Z  at org.flowable.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:904)
2023-12-23T02:24:26.951581889Z  at org.flowable.spring.SpringProcessEngineConfiguration.buildProcessEngine(SpringProcessEngineConfiguration.java:72)
2023-12-23T02:24:26.951585175Z  at org.flowable.spring.ProcessEngineFactoryBean.getObject(ProcessEngineFactoryBean.java:60)
2023-12-23T02:24:26.951588115Z  at org.flowable.spring.ProcessEngineFactoryBean.getObject(ProcessEngineFactoryBean.java:32)
2023-12-23T02:24:26.951591238Z  at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:171)
2023-12-23T02:24:26.951594300Z  at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:101)
2023-12-23T02:24:26.951597437Z  at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1674)
2023-12-23T02:24:26.951603930Z  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.getObjectForBeanInstance(AbstractAutowireCapableBeanFactory.java:1248)
2023-12-23T02:24:26.951607285Z  at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:330)
2023-12-23T02:24:26.951610297Z  at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
2023-12-23T02:24:26.951614208Z  at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:277)
2023-12-23T02:24:26.951618440Z  at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1255)
2023-12-23T02:24:26.951622933Z  at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1175)
2023-12-23T02:24:26.951627270Z  at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:857)
2023-12-23T02:24:26.951631480Z  at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:760)
2023-12-23T02:24:26.951635765Z  at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:509)
2023-12-23T02:24:26.951640388Z  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1320)
2023-12-23T02:24:26.951645316Z  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1159)
2023-12-23T02:24:26.951649779Z  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555)
2023-12-23T02:24:26.951654129Z  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:515)
2023-12-23T02:24:26.951658462Z  at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320)
2023-12-23T02:24:26.951662567Z  at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
2023-12-23T02:24:26.951666845Z  at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318)
2023-12-23T02:24:26.951671045Z  at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
2023-12-23T02:24:26.951675434Z  at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1105)
2023-12-23T02:24:26.951679787Z  at org.springframework.boot.actuate.endpoint.annotation.EndpointDiscoverer.createEndpointBean(EndpointDiscoverer.java:141)
2023-12-23T02:24:26.951684195Z  at org.springframework.boot.actuate.endpoint.annotation.EndpointDiscoverer.createEndpointBeans(EndpointDiscoverer.java:131)
2023-12-23T02:24:26.951688802Z  at org.springframework.boot.actuate.endpoint.annotation.EndpointDiscoverer.discoverEndpoints(EndpointDiscoverer.java:120)
2023-12-23T02:24:26.951698952Z  at org.springframework.boot.actuate.endpoint.annotation.EndpointDiscoverer.getEndpoints(EndpointDiscoverer.java:114)
2023-12-23T02:24:26.951703715Z  at org.springframework.boot.actuate.autoconfigure.endpoint.web.ServletEndpointManagementContextConfiguration$WebMvcServletEndpointManagementContextConfiguration.servletEndpointRegistrar(ServletEndpointManagementContextConfiguration.java:72)
2023-12-23T02:24:26.951708687Z  at org.springframework.boot.actuate.autoconfigure.endpoint.web.ServletEndpointManagementContextConfiguration$WebMvcServletEndpointManagementContextConfiguration$$EnhancerBySpringCGLIB$$44b10cac.CGLIB$servletEndpointRegistrar$0(<generated>)
2023-12-23T02:24:26.951714920Z  at org.springframework.boot.actuate.autoconfigure.endpoint.web.ServletEndpointManagementContextConfiguration$WebMvcServletEndpointManagementContextConfiguration$$EnhancerBySpringCGLIB$$44b10cac$$FastClassBySpringCGLIB$$7c9853e7.invoke(<generated>)
2023-12-23T02:24:26.951719884Z  at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:244)
2023-12-23T02:24:26.951724376Z  at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:363)
2023-12-23T02:24:26.951729067Z  at org.springframework.boot.actuate.autoconfigure.endpoint.web.ServletEndpointManagementContextConfiguration$WebMvcServletEndpointManagementContextConfiguration$$EnhancerBySpringCGLIB$$44b10cac.servletEndpointRegistrar(<generated>)
2023-12-23T02:24:26.951734278Z  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2023-12-23T02:24:26.951738699Z  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
2023-12-23T02:24:26.951743168Z  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
2023-12-23T02:24:26.951747613Z  at java.lang.reflect.Method.invoke(Method.java:498)
2023-12-23T02:24:26.951751890Z  at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:154)
2023-12-23T02:24:26.951756160Z  at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:622)
2023-12-23T02:24:26.951760456Z  at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:607)
2023-12-23T02:24:26.951765028Z  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1320)
2023-12-23T02:24:26.951769610Z  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1159)
2023-12-23T02:24:26.951774014Z  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555)
2023-12-23T02:24:26.951778303Z  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:515)
2023-12-23T02:24:26.951782881Z  at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320)
2023-12-23T02:24:26.951792037Z  at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
2023-12-23T02:24:26.951797413Z  at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318)
2023-12-23T02:24:26.951801857Z  at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
2023-12-23T02:24:26.951806366Z  at org.springframework.boot.web.servlet.ServletContextInitializerBeans.getOrderedBeansOfType(ServletContextInitializerBeans.java:211)
2023-12-23T02:24:26.951810945Z  at org.springframework.boot.web.servlet.ServletContextInitializerBeans.getOrderedBeansOfType(ServletContextInitializerBeans.java:202)
2023-12-23T02:24:26.951815319Z  at org.springframework.boot.web.servlet.ServletContextInitializerBeans.addServletContextInitializerBeans(ServletContextInitializerBeans.java:96)
2023-12-23T02:24:26.951820306Z  at org.springframework.boot.web.servlet.ServletContextInitializerBeans.<init>(ServletContextInitializerBeans.java:85)
2023-12-23T02:24:26.951825482Z  at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.getServletContextInitializerBeans(ServletWebServerApplicationContext.java:253)
2023-12-23T02:24:26.951829936Z  at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.selfInitialize(ServletWebServerApplicationContext.java:227)
2023-12-23T02:24:26.951834446Z  at org.springframework.boot.web.embedded.tomcat.TomcatStarter.onStartup(TomcatStarter.java:53)
2023-12-23T02:24:26.951838805Z  at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5135)
2023-12-23T02:24:26.951843095Z  at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
2023-12-23T02:24:26.951847518Z  at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
2023-12-23T02:24:26.951851895Z  at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
2023-12-23T02:24:26.951856214Z  at java.util.concurrent.FutureTask.run(FutureTask.java:266)
2023-12-23T02:24:26.951860556Z  at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
2023-12-23T02:24:26.951864865Z  at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:134)
2023-12-23T02:24:26.951869542Z  at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
2023-12-23T02:24:26.951874385Z  at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
2023-12-23T02:24:26.951878829Z  at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
2023-12-23T02:24:26.951883127Z  at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
2023-12-23T02:24:26.951888339Z  at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
2023-12-23T02:24:26.951894475Z  at java.util.concurrent.FutureTask.run(FutureTask.java:266)
2023-12-23T02:24:26.951904590Z  at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
2023-12-23T02:24:26.951909082Z  at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:134)
2023-12-23T02:24:26.951913157Z  at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
2023-12-23T02:24:26.951917384Z  at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
2023-12-23T02:24:26.951921956Z  at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
2023-12-23T02:24:26.951926355Z  at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
2023-12-23T02:24:26.951930675Z  at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
2023-12-23T02:24:26.951934819Z  at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:930)
2023-12-23T02:24:26.951939212Z  at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
2023-12-23T02:24:26.951943595Z  at org.apache.catalina.startup.Tomcat.start(Tomcat.java:459)
2023-12-23T02:24:26.951947849Z  at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.initialize(TomcatWebServer.java:105)
2023-12-23T02:24:26.951952271Z  at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.<init>(TomcatWebServer.java:86)
2023-12-23T02:24:26.951956888Z  at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getTomcatWebServer(TomcatServletWebServerFactory.java:416)
2023-12-23T02:24:26.951961536Z  at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getWebServer(TomcatServletWebServerFactory.java:180)
2023-12-23T02:24:26.951966162Z  at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.createWebServer(ServletWebServerApplicationContext.java:180)
2023-12-23T02:24:26.951970771Z  at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:153)
2023-12-23T02:24:26.951975421Z  at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:543)
2023-12-23T02:24:26.951980051Z  at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:141)
2023-12-23T02:24:26.951984757Z  at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:744)
2023-12-23T02:24:26.951989286Z  at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:391)
2023-12-23T02:24:26.951994634Z  at org.springframework.boot.SpringApplication.run(SpringApplication.java:312)
2023-12-23T02:24:26.951999098Z  at com.imanager.BizFlowableApp.main(BizFlowableApp.java:45)
2023-12-23T02:24:26.952003676Z  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2023-12-23T02:24:26.952008119Z  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
2023-12-23T02:24:26.952018075Z  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
2023-12-23T02:24:26.952022464Z  at java.lang.reflect.Method.invoke(Method.java:498)
2023-12-23T02:24:26.952027144Z  at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49)
2023-12-23T02:24:26.952031526Z  at org.springframework.boot.loader.Launcher.launch(Launcher.java:109)
2023-12-23T02:24:26.952036029Z  at org.springframework.boot.loader.Launcher.launch(Launcher.java:58)
2023-12-23T02:24:26.952040290Z  at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:88)
2023-12-23T02:24:26.952045191Z
2023-12-23T02:24:26.966740297Z [xx-flowable:172.18.163.161:8081] [,] 2023-12-23 10:24:26.966 ERROR 1 [main] org.springframework.boot.web.embedded.tomcat.TomcatStarter Error starting Tomcat context. Exception: org.springframework.beans.factory.BeanCreationException. Message: Error creating bean with name 'servletEndpointRegistrar' defined in class path resource [org/springframework/boot/actuate/autoconfigure/endpoint/web/ServletEndpointManagementContextConfiguration$WebMvcServletEndpointManagementContextConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.boot.actuate.endpoint.web.ServletEndpointRegistrar]: Factory method 'servletEndpointRegistrar' threw exception; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'processEngineEndpoint' defined in class path resource [org/flowable/spring/boot/EndpointAutoConfiguration.class]: Unsatisfied dependency expressed through method 'processEngineEndpoint' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngine': FactoryBean threw exception on object creation; nested exception is java.lang.NullPointerException
2023-12-23T02:24:27.016309686Z [xx-flowable:172.18.163.161:8081] [,] 2023-12-23 10:24:27.016 INFO 1 [main] org.apache.catalina.core.StandardService Stopping service [Tomcat]
2023-12-23T02:24:27.021136142Z [xx-flowable:172.18.163.161:8081] [,] 2023-12-23 10:24:27.020 WARN 1 [main] org.apache.catalina.loader.WebappClassLoaderBase The web application [ROOT] appears to have started a thread named [Druid-ConnectionPool-Create-205810452] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
2023-12-23T02:24:27.021164149Z  sun.misc.Unsafe.park(Native Method)
2023-12-23T02:24:27.021169607Z  java.util.concurrent.locks.LockSupport.park(LockSupport.java:175)
2023-12-23T02:24:27.021174002Z  java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2039)
2023-12-23T02:24:27.021178499Z  com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2443)
2023-12-23T02:24:27.021609106Z [xx-flowable:172.18.163.161:8081] [,] 2023-12-23 10:24:27.021 WARN 1 [main] org.apache.catalina.loader.WebappClassLoaderBase The web application [ROOT] appears to have started a thread named [Druid-ConnectionPool-Destroy-205810452] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
2023-12-23T02:24:27.021625540Z  java.lang.Thread.sleep(Native Method)
2023-12-23T02:24:27.021638845Z  com.alibaba.druid.pool.DruidDataSource$DestroyConnectionThread.run(DruidDataSource.java:2540)
2023-12-23T02:24:27.024457905Z [xx-flowable:172.18.163.161:8081] [,] 2023-12-23 10:24:27.024 WARN 1 [main] org.springframework.boot.web.servlet.context.AnnotationConfigServletWebServerApplicationContext Exception encountered during context initialization - cancelling refresh attempt: org.springframework.context.ApplicationContextException: Unable to start web server; nested exception is org.springframework.boot.web.server.WebServerException: Unable to start embedded Tomcat
2023-12-23T02:24:27.026641487Z [xx-flowable:172.18.163.161:8081] [,] 2023-12-23 10:24:27.026 INFO 1 [main] org.springframework.scheduling.concurrent.ThreadPoolTaskExecutor Shutting down ExecutorService 'taskExecutor'
2023-12-23T02:24:27.040963353Z [xx-flowable:172.18.163.161:8081] [,] 2023-12-23 10:24:27.040 INFO 1 [main] com.alibaba.druid.pool.DruidDataSource {dataSource-1} closed
2023-12-23T02:24:27.066510144Z [xx-flowable:172.18.163.161:8081] [,] 2023-12-23 10:24:27.066 INFO 1 [main] org.springframework.boot.autoconfigure.logging.ConditionEvaluationReportLoggingListener
2023-12-23T02:24:27.066538649Z
2023-12-23T02:24:27.066543682Z Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
2023-12-23T02:24:27.071839154Z [xx-flowable:172.18.163.161:8081] [,] 2023-12-23 10:24:27.071 ERROR 1 [main] org.springframework.boot.SpringApplication Application run failed
2023-12-23T02:24:27.071859692Z
2023-12-23T02:24:27.071863303Z org.springframework.context.ApplicationContextException: Unable to start web server; nested exception is org.springframework.boot.web.server.WebServerException: Unable to start embedded Tomcat
2023-12-23T02:24:27.071866975Z  at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:156)
2023-12-23T02:24:27.071870543Z  at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:543)
2023-12-23T02:24:27.071873600Z  at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:141)
2023-12-23T02:24:27.071876823Z  at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:744)
2023-12-23T02:24:27.071879820Z  at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:391)
2023-12-23T02:24:27.071882787Z  at org.springframework.boot.SpringApplication.run(SpringApplication.java:312)
2023-12-23T02:24:27.071885716Z  at com.imanager.BizFlowableApp.main(BizFlowableApp.java:45)
2023-12-23T02:24:27.071888624Z  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2023-12-23T02:24:27.071891642Z  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
2023-12-23T02:24:27.071894674Z  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
2023-12-23T02:24:27.071906027Z  at java.lang.reflect.Method.invoke(Method.java:498)
2023-12-23T02:24:27.071919896Z  at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49)
2023-12-23T02:24:27.071923077Z  at org.springframework.boot.loader.Launcher.launch(Launcher.java:109)
2023-12-23T02:24:27.071926045Z  at org.springframework.boot.loader.Launcher.launch(Launcher.java:58)
2023-12-23T02:24:27.071928949Z  at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:88)
2023-12-23T02:24:27.071931899Z Caused by: org.springframework.boot.web.server.WebServerException: Unable to start embedded Tomcat
2023-12-23T02:24:27.071934832Z  at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.initialize(TomcatWebServer.java:124)
2023-12-23T02:24:27.071937834Z  at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.<init>(TomcatWebServer.java:86)
2023-12-23T02:24:27.071941797Z  at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getTomcatWebServer(TomcatServletWebServerFactory.java:416)
2023-12-23T02:24:27.071944966Z  at org.springframework.boot.web.embedded.tomcat.TomcatServletWebServerFactory.getWebServer(TomcatServletWebServerFactory.java:180)
2023-12-23T02:24:27.071948044Z  at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.createWebServer(ServletWebServerApplicationContext.java:180)
2023-12-23T02:24:27.071951089Z  at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.onRefresh(ServletWebServerApplicationContext.java:153)
2023-12-23T02:24:27.071954118Z  ... 14 common frames omitted
2023-12-23T02:24:27.071957078Z Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'servletEndpointRegistrar' defined in class path resource [org/springframework/boot/actuate/autoconfigure/endpoint/web/ServletEndpointManagementContextConfiguration$WebMvcServletEndpointManagementContextConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.boot.actuate.endpoint.web.ServletEndpointRegistrar]: Factory method 'servletEndpointRegistrar' threw exception; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'processEngineEndpoint' defined in class path resource [org/flowable/spring/boot/EndpointAutoConfiguration.class]: Unsatisfied dependency expressed through method 'processEngineEndpoint' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngine': FactoryBean threw exception on object creation; nested exception is java.lang.NullPointerException
2023-12-23T02:24:27.071962490Z  at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:627)
2023-12-23T02:24:27.071965561Z  at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:607)
2023-12-23T02:24:27.071968569Z  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1320)
2023-12-23T02:24:27.071972038Z  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1159)
2023-12-23T02:24:27.071978543Z  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555)
2023-12-23T02:24:27.071981673Z  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:515)
2023-12-23T02:24:27.071984755Z  at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320)
2023-12-23T02:24:27.071987738Z  at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
2023-12-23T02:24:27.071990767Z  at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318)
2023-12-23T02:24:27.071993735Z  at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
2023-12-23T02:24:27.071996738Z  at org.springframework.boot.web.servlet.ServletContextInitializerBeans.getOrderedBeansOfType(ServletContextInitializerBeans.java:211)
2023-12-23T02:24:27.071999779Z  at org.springframework.boot.web.servlet.ServletContextInitializerBeans.getOrderedBeansOfType(ServletContextInitializerBeans.java:202)
2023-12-23T02:24:27.072002790Z  at org.springframework.boot.web.servlet.ServletContextInitializerBeans.addServletContextInitializerBeans(ServletContextInitializerBeans.java:96)
2023-12-23T02:24:27.072005836Z  at org.springframework.boot.web.servlet.ServletContextInitializerBeans.<init>(ServletContextInitializerBeans.java:85)
2023-12-23T02:24:27.072009069Z  at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.getServletContextInitializerBeans(ServletWebServerApplicationContext.java:253)
2023-12-23T02:24:27.072012170Z  at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.selfInitialize(ServletWebServerApplicationContext.java:227)
2023-12-23T02:24:27.072015242Z  at org.springframework.boot.web.embedded.tomcat.TomcatStarter.onStartup(TomcatStarter.java:53)
2023-12-23T02:24:27.072018240Z  at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5135)
2023-12-23T02:24:27.072021148Z  at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
2023-12-23T02:24:27.072024041Z  at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
2023-12-23T02:24:27.072027233Z  at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
2023-12-23T02:24:27.072030154Z  at java.util.concurrent.FutureTask.run(FutureTask.java:266)
2023-12-23T02:24:27.072033040Z  at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
2023-12-23T02:24:27.072036050Z  at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:134)
2023-12-23T02:24:27.072038992Z  at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
2023-12-23T02:24:27.072041888Z  at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
2023-12-23T02:24:27.072047962Z  at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
2023-12-23T02:24:27.072050949Z  at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
2023-12-23T02:24:27.072053898Z  at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
2023-12-23T02:24:27.072056791Z  at java.util.concurrent.FutureTask.run(FutureTask.java:266)
2023-12-23T02:24:27.072059653Z  at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
2023-12-23T02:24:27.072062608Z  at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:134)
2023-12-23T02:24:27.072065568Z  at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
2023-12-23T02:24:27.072068460Z  at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
2023-12-23T02:24:27.072071372Z  at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
2023-12-23T02:24:27.072074323Z  at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
2023-12-23T02:24:27.072077379Z  at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
2023-12-23T02:24:27.072080385Z  at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:930)
2023-12-23T02:24:27.072083366Z  at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
2023-12-23T02:24:27.072086453Z  at org.apache.catalina.startup.Tomcat.start(Tomcat.java:459)
2023-12-23T02:24:27.072089522Z  at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.initialize(TomcatWebServer.java:105)
2023-12-23T02:24:27.072092504Z  ... 19 common frames omitted
2023-12-23T02:24:27.072095872Z Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.boot.actuate.endpoint.web.ServletEndpointRegistrar]: Factory method 'servletEndpointRegistrar' threw exception; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'processEngineEndpoint' defined in class path resource [org/flowable/spring/boot/EndpointAutoConfiguration.class]: Unsatisfied dependency expressed through method 'processEngineEndpoint' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngine': FactoryBean threw exception on object creation; nested exception is java.lang.NullPointerException
2023-12-23T02:24:27.072100257Z  at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:185)
2023-12-23T02:24:27.072103406Z  at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:622)
2023-12-23T02:24:27.072106534Z  ... 59 common frames omitted
2023-12-23T02:24:27.072109610Z Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'processEngineEndpoint' defined in class path resource [org/flowable/spring/boot/EndpointAutoConfiguration.class]: Unsatisfied dependency expressed through method 'processEngineEndpoint' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngine': FactoryBean threw exception on object creation; nested exception is java.lang.NullPointerException
2023-12-23T02:24:27.072118037Z  at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:769)
2023-12-23T02:24:27.072121258Z  at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:509)
2023-12-23T02:24:27.072124508Z  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1320)
2023-12-23T02:24:27.072127629Z  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1159)
2023-12-23T02:24:27.072130718Z  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555)
2023-12-23T02:24:27.072133765Z  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:515)
2023-12-23T02:24:27.072136967Z  at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320)
2023-12-23T02:24:27.072139969Z  at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
2023-12-23T02:24:27.072142990Z  at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318)
2023-12-23T02:24:27.072145946Z  at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
2023-12-23T02:24:27.072148944Z  at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1105)
2023-12-23T02:24:27.072151914Z  at org.springframework.boot.actuate.endpoint.annotation.EndpointDiscoverer.createEndpointBean(EndpointDiscoverer.java:141)
2023-12-23T02:24:27.072154904Z  at org.springframework.boot.actuate.endpoint.annotation.EndpointDiscoverer.createEndpointBeans(EndpointDiscoverer.java:131)
2023-12-23T02:24:27.072157898Z  at org.springframework.boot.actuate.endpoint.annotation.EndpointDiscoverer.discoverEndpoints(EndpointDiscoverer.java:120)
2023-12-23T02:24:27.072160886Z  at org.springframework.boot.actuate.endpoint.annotation.EndpointDiscoverer.getEndpoints(EndpointDiscoverer.java:114)
2023-12-23T02:24:27.072163947Z  at org.springframework.boot.actuate.autoconfigure.endpoint.web.ServletEndpointManagementContextConfiguration$WebMvcServletEndpointManagementContextConfiguration.servletEndpointRegistrar(ServletEndpointManagementContextConfiguration.java:72)
2023-12-23T02:24:27.072167229Z  at org.springframework.boot.actuate.autoconfigure.endpoint.web.ServletEndpointManagementContextConfiguration$WebMvcServletEndpointManagementContextConfiguration$$EnhancerBySpringCGLIB$$44b10cac.CGLIB$servletEndpointRegistrar$0(<generated>)
2023-12-23T02:24:27.072170695Z  at org.springframework.boot.actuate.autoconfigure.endpoint.web.ServletEndpointManagementContextConfiguration$WebMvcServletEndpointManagementContextConfiguration$$EnhancerBySpringCGLIB$$44b10cac$$FastClassBySpringCGLIB$$7c9853e7.invoke(<generated>)
2023-12-23T02:24:27.072179558Z  at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:244)
2023-12-23T02:24:27.072182630Z  at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:363)
2023-12-23T02:24:27.072185952Z  at org.springframework.boot.actuate.autoconfigure.endpoint.web.ServletEndpointManagementContextConfiguration$WebMvcServletEndpointManagementContextConfiguration$$EnhancerBySpringCGLIB$$44b10cac.servletEndpointRegistrar(<generated>)
2023-12-23T02:24:27.072189255Z  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2023-12-23T02:24:27.072192177Z  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
2023-12-23T02:24:27.072195098Z  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
2023-12-23T02:24:27.072198040Z  at java.lang.reflect.Method.invoke(Method.java:498)
2023-12-23T02:24:27.072200921Z  at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:154)
2023-12-23T02:24:27.072203946Z  ... 60 common frames omitted
2023-12-23T02:24:27.072206803Z Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngine': FactoryBean threw exception on object creation; nested exception is java.lang.NullPointerException
2023-12-23T02:24:27.072209951Z  at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:178)
2023-12-23T02:24:27.072212980Z  at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:101)
2023-12-23T02:24:27.072216065Z  at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1674)
2023-12-23T02:24:27.072219104Z  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.getObjectForBeanInstance(AbstractAutowireCapableBeanFactory.java:1248)
2023-12-23T02:24:27.072222191Z  at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:330)
2023-12-23T02:24:27.072225191Z  at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
2023-12-23T02:24:27.072228154Z  at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:277)
2023-12-23T02:24:27.072231123Z  at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1255)
2023-12-23T02:24:27.072234139Z  at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1175)
2023-12-23T02:24:27.072237417Z  at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:857)
2023-12-23T02:24:27.072240424Z  at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:760)
2023-12-23T02:24:27.072246319Z  ... 85 common frames omitted
2023-12-23T02:24:27.072249232Z Caused by: java.lang.NullPointerException: null
2023-12-23T02:24:27.072252143Z  at org.flowable.engine.impl.db.ProcessDbSchemaManager.schemaUpdate(ProcessDbSchemaManager.java:185)
2023-12-23T02:24:27.072255115Z  at org.flowable.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:54)
2023-12-23T02:24:27.072258120Z  at org.flowable.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:28)
2023-12-23T02:24:27.072261143Z  at org.flowable.engine.impl.interceptor.CommandInvoker$1.run(CommandInvoker.java:51)
2023-12-23T02:24:27.072264090Z  at org.flowable.engine.impl.interceptor.CommandInvoker.executeOperation(CommandInvoker.java:93)
2023-12-23T02:24:27.072267028Z  at org.flowable.engine.impl.interceptor.CommandInvoker.executeOperations(CommandInvoker.java:72)
2023-12-23T02:24:27.072269968Z  at org.flowable.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:56)
2023-12-23T02:24:27.072298998Z  at org.flowable.engine.impl.interceptor.BpmnOverrideContextInterceptor.execute(BpmnOverrideContextInterceptor.java:25)
2023-12-23T02:24:27.072303139Z  at org.flowable.common.engine.impl.interceptor.TransactionContextInterceptor.execute(TransactionContextInterceptor.java:53)
2023-12-23T02:24:27.072306117Z  at org.flowable.common.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:71)
2023-12-23T02:24:27.072309133Z  at org.flowable.common.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:49)
2023-12-23T02:24:27.072312106Z  at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)
2023-12-23T02:24:27.072315071Z  at org.flowable.common.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:46)
2023-12-23T02:24:27.072318040Z  at org.flowable.common.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:30)
2023-12-23T02:24:27.072320960Z  at org.flowable.common.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:56)
2023-12-23T02:24:27.072323935Z  at org.flowable.engine.impl.ProcessEngineImpl.<init>(ProcessEngineImpl.java:78)
2023-12-23T02:24:27.072326992Z  at org.flowable.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:904)
2023-12-23T02:24:27.072330453Z  at org.flowable.spring.SpringProcessEngineConfiguration.buildProcessEngine(SpringProcessEngineConfiguration.java:72)
2023-12-23T02:24:27.072333550Z  at org.flowable.spring.ProcessEngineFactoryBean.getObject(ProcessEngineFactoryBean.java:60)
2023-12-23T02:24:27.072336494Z  at org.flowable.spring.ProcessEngineFactoryBean.getObject(ProcessEngineFactoryBean.java:32)
2023-12-23T02:24:27.072339429Z  at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:171)
2023-12-23T02:24:27.072349387Z  ... 95 common frames omitted

一系列检查后没有发现问题，后来想到发布环境的数据库表是用sql语句生成的，而不是由工作流工程自身生成的，于是删除数据库重新运行工程。
但重新运行还是报以下错误：

java.sql.SQLSyntaxErrorException: Table 'xx-flowable.ACT_ID_USER' doesn't exist

网上查了一下是因为没加nullCatalogMeansCurrent=true，加上后再次运行发现只生成了部分表，而且运行还是报以下错误：

java.sql.SQLSyntaxErrorException: Table 'xx-flowable.ACT_RE_PROCDEF' doesn't exist

然后又是漫长的调查，终于在这篇文章中看到这句话：“因为mysql使用schema标识库名而不是catalog，因此mysql会扫描所有的库来找表，如果其他库中有相同名称的表，activiti就以为找到了，本质上这个表在当前数据库中并不存在。”然后突然想到登陆的Mysql账户下还存在一个相同的工作流数据库，会不会是这个影响到了？于是修改工程中的Mysql登录账号，再次运行工程成功生成工作流数据库表，至此所有问题都解决了。