As part of the efforts to remove very old drafts from the CX database (T183890), manual runs of the script created in T189087 are needed.
We want to run multiple iterations of the manual script until we clean the backog, in order to automate the process next (T189091).
Considering that every week, ~1000 drafts are created we need to make sure that the manual iterations are frequent enough to effectively reduce the backlog.
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | KartikMistry | T216509 Complete manual rounds of unpublished draft purge script until the backlog is clean | |||
| Resolved | KartikMistry | T216470 Fifth manual run of unpublished draft purge script | |||
| Resolved | KartikMistry | T216983 Run unpublished draft purge script for CX (Week of 24/02) | |||
| Resolved | KartikMistry | T217310 Run unpublished draft purge script for CX (Week of 03/03) | |||
| Resolved | KartikMistry | T217818 Run unpublished draft purge script for CX (Week of 03/10) | |||
| Resolved | KartikMistry | T203059 Fourth manual run of unpublished draft purge script | |||
| Resolved | KartikMistry | T201895 Third manual run of unpublished draft purge script | |||
| Resolved | KartikMistry | T218279 Run unpublished draft purge script for CX (Week of 03/17) |
With removal of drafts older than 420 days (1 year + 2 months) aim, we have 57973 unpublished drafts to purge. With approx 3000 drafts are purged in one run, we need 19 such runs. We can do 3 to 4 runs per week and it would take approx 5 weeks to purge all drafts.
I'll be weekly task to finish remaining script runs. Scheduled 3 runs this week (Tue, Wed, Thu) and we will adjust runs from next week. I'll update my analysis every week here once draft purge run is over.