conductor-oss / conductor-oss/conductor
Delete Workflow Execution History via UI is causing duplicated execution of task in the future runs.
- 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
Assessment
This issue has not been assessed yet.