common-workflow-service icon indicating copy to clipboard operation
common-workflow-service copied to clipboard
verified publisher icon NASA-AMMOS

Need to Cleanup old rows in cws_sched_worker_proc_inst and cws_proc_inst_status

Open galenatjpl opened this issue 5 years ago • 1 comments

Cleanup these rows, based on the historyDaysToLive value

cws.cws_sched_worker_proc_inst rows | keep only last 2 weeks of data | DELETE FROM cws.cws_sched_worker_proc_inst WHERE created_time < now() - interval 14 DAY and status != 'pending'; | yes |

cws.cws_proc_inst_status | keep only last 2 weeks of data | DELETE FROM cws.cws_proc_inst_status WHERE end_time is not null and end_time < now() - interval 14 DAY;

galenatjpl avatar Mar 18 '21 21:03 galenatjpl

Criticality: low-medium (Project already has a workaround) Time estimate: 2 days

galenatjpl avatar Oct 05 '21 18:10 galenatjpl