conductor-oss / conductor-oss/conductor

Delete Workflow Execution History via UI is causing duplicated execution of task in the future runs.

Open
#596 0 comments 1 reaction 0 assignees View on GitHub
bug ui
Dominant language
Java
Stars
32.2k
Forks
1k
Avg merge
2d
Merged PRs (30d)
33

Description

### Describe the bug

Currently we are running
Conductor UI : 3.21.14_amd64
and Conductor server : 3.21.14

After awhile, we want to clean up the execution history record and take the action via UI. After taking action, from UI, it is cleared. However in the future execution of workflow, we are seeing some task having duplicated execution which continues till the end of the workflow.

if you have workflow 1 - > 2 -> 3 -> 4
we have seen where at task 2, we are seeing twice so we see execution history of
1, 2, 2, 3, 3, 4, 4.

doing some investigation, I believe some of the tables are residual data that might be causing it so I tried to manually clean up those tables and that seems to resolve the issue.

SQL that I ran to clean up the residual data.
delete from  task_execution_logs;
delete from task_scheduled;
delete from  task_in_progress;
delete from  task_index;
delete from task;
delete from workflow;
delete from workflow_def_to_workflow;
delete from workflow_pending;
delete from workflow_index;
delete from workflow_to_task;

The api/ui interaction should be able to delete and not cause the issue of duplicated execution of task within a workflow.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.