mirror of
https://github.com/open-metadata/OpenMetadata.git
synced 2025-11-22 05:36:11 +00:00
e831c7dd2a
* Revert deleting Old Deployments for Periodic batch Workflows * Revert "Revert deleting Old Deployments for Periodic batch Workflows" This reverts commit 7bd1be5a813c209ff9493eedfdb68c918fa68706. * TRUNCATE FLOWABLE history tables in both 1.10.5 and 1.10.7 migrations * TRUNCATE FLOWABLE history tables in both 1.10.5 and 1.10.7 migrations
22 lines
824 B
SQL
22 lines
824 B
SQL
-- Increase Flowable ACTIVITY_ID_ column size to support longer user-defined workflow node names
|
|
ALTER TABLE ACT_RU_EVENT_SUBSCR MODIFY ACTIVITY_ID_ varchar(255);
|
|
|
|
-- Update workflow settings with new job acquisition interval settings
|
|
UPDATE openmetadata_settings
|
|
SET json = JSON_SET(
|
|
json,
|
|
'$.executorConfiguration.asyncJobAcquisitionInterval', 60000,
|
|
'$.executorConfiguration.timerJobAcquisitionInterval', 60000
|
|
)
|
|
WHERE configType = 'workflowSettings'
|
|
AND JSON_EXTRACT(json, '$.executorConfiguration') IS NOT NULL;
|
|
|
|
-- TRUNCATE FLOWABLE HISTORY TABLES
|
|
TRUNCATE TABLE ACT_HI_PROCINST;
|
|
TRUNCATE TABLE ACT_HI_ACTINST;
|
|
TRUNCATE TABLE ACT_HI_TASKINST;
|
|
TRUNCATE TABLE ACT_HI_VARINST;
|
|
TRUNCATE TABLE ACT_HI_DETAIL;
|
|
TRUNCATE TABLE ACT_HI_COMMENT;
|
|
TRUNCATE TABLE ACT_HI_ATTACHMENT;
|
|
TRUNCATE TABLE ACT_HI_IDENTITYLINK; |