mirror of
https://github.com/open-metadata/OpenMetadata.git
synced 2025-11-21 21:29:30 +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
28 lines
889 B
SQL
28 lines
889 B
SQL
-- Increase Flowable ACTIVITY_ID_ column size to support longer user-defined workflow node names
|
|
ALTER TABLE ACT_RU_EVENT_SUBSCR ALTER COLUMN ACTIVITY_ID_ TYPE varchar(255);
|
|
|
|
-- Update workflow settings with new job acquisition interval settings
|
|
UPDATE openmetadata_settings
|
|
SET json = jsonb_set(
|
|
jsonb_set(
|
|
json,
|
|
'{executorConfiguration,asyncJobAcquisitionInterval}',
|
|
'60000',
|
|
true
|
|
),
|
|
'{executorConfiguration,timerJobAcquisitionInterval}',
|
|
'60000',
|
|
true
|
|
)
|
|
WHERE configtype = 'workflowSettings'
|
|
AND 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; |