org.flowable.common.engine.api.FlowableException: couldn't upgrade db schema: alter table ACT_RU_ENTITYLINK add column HIERARCHY_TYPE_ varchar(255)
-- ============================================= -- 更新 Flowable 版本号脚本 -- 如果表已经创建，但 Flowable 启动时仍然尝试升级表结构，执行此脚本 -- ============================================= -- 更新版本号为 6.8.0.0，避免 Flowable 尝试升级表结构 UPDATE `ACT_GE_PROPERTY` SET `VALUE_` = '6.8.0.0', `REV_` = 1 WHERE `NAME_` = 'schema.version'; UPDATE `ACT_GE_PROPERTY` SET `VALUE_` = 'create(6.8.0.0)', `REV_` = 1 WHERE `NAME_` = 'schema.history'; -- 如果记录不存在，则插入 INSERT INTO `ACT_GE_PROPERTY` (`NAME_`, `VALUE_`, `REV_`) SELECT 'schema.version', '6.8.0.0', 1 WHERE NOT EXISTS (SELECT 1 FROM `ACT_GE_PROPERTY` WHERE `NAME_` = 'schema.version'); INSERT INTO `ACT_GE_PROPERTY` (`NAME_`, `VALUE_`, `REV_`) SELECT 'schema.history', 'create(6.8.0.0)', 1 WHERE NOT EXISTS (SELECT 1 FROM `ACT_GE_PROPERTY` WHERE `NAME_` = 'schema.history'); -- 提交事务 COMMIT; -- ============================================= -- 执行说明： -- 1. 执行此脚本后，Flowable 会认为表结构已经是 6.8.0.0 版本 -- 2. 重启应用，Flowable 不会再尝试升级表结构 -- =============================================
