Maniphest T199658

Second manual run of unpublished draft purge script
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	KartikMistry
	Jul 16 2018, 6:40 AM

Description

After first run (T189088), we will do next run of scripts/purge-unpublished-drafts.php script.

age-in-days: 1150
number of drafts to purge = ~1040
schedule: https://wikitech.wikimedia.org/wiki/Deployments#Thursday,_July_19

Related Objects
Search...

Status	Assigned	Task
Open	None	T183485 Please consider purging/moving the cx_corpora table at x1
Resolved	Pginer-WMF	T183890 Remove very old translation drafts from CX database
Resolved	KartikMistry	T199658 Second manual run of unpublished draft purge script

Event Timeline

KartikMistry created this task.Jul 16 2018, 6:40 AM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJul 16 2018, 6:40 AM

KartikMistry moved this task from Backlog to Maintenance backlog on the Language-2018-July-September board.Jul 16 2018, 6:40 AM

Bencemac added a subscriber: Bencemac.Jul 16 2018, 6:54 AM

KartikMistry triaged this task as Medium priority.Jul 16 2018, 11:34 AM

KartikMistry updated the task description. (Show Details)

I am just curious: circa how many free space will we get?

In T199658#4427202, @Bencemac wrote:

I am just curious: circa how many free space will we get?

Very less at this point, but advantage of this script run is: It will free those articles and make them available for translation for other users.

In T199658#4427399, @KartikMistry wrote:

In T199658#4427202, @Bencemac wrote:

I am just curious: circa how many free space will we get?

Very less at this point, but advantage of this script run is: It will free those articles and make them available for translation for other users.

Whoa, I did not know that a draft blocks the others and they cannot translate the page. Good to know. :)

Back to the task, 1150 days is not a little too big? Based on the Hungarian Wikipedia's statistics, I would say that there are many more drafts which are not affected by this deleting.

In T199658#4427576, @Bencemac wrote:

Back to the task, 1150 days is not a little too big? Based on the Hungarian Wikipedia's statistics, I would say that there are many more drafts which are not affected by this deleting.

We're going slow. In sometime, this will be converted into cron that will purge draft automatically which are older than 1 year. See: T189088 and T183890

KartikMistry renamed this task from Manual run unpublished draft purge script to Second manual run of unpublished draft purge script.Jul 16 2018, 2:16 PM

KartikMistry added a parent task: T183890: Remove very old translation drafts from CX database.

KartikMistry updated the task description. (Show Details)Jul 17 2018, 3:15 AM

KartikMistry updated the task description. (Show Details)Jul 18 2018, 3:51 PM

KartikMistry moved this task from Maintenance backlog to In Progress on the Language-2018-July-September board.Jul 19 2018, 4:09 AM

Mentioned in SAL (#wikimedia-operations) [2018-07-19T04:12:17Z] <kart_> Finished ContentTranslation draft purge script on mwmaint1001 (T199658)

KartikMistry updated the task description. (Show Details)Jul 19 2018, 4:16 AM

KartikMistry moved this task from In Progress to Done on the Language-2018-July-September board.

KartikMistry mentioned this in T199960: Draft purge script should not fail when sending notification is failed.Jul 19 2018, 4:22 AM

Pginer-WMF moved this task from Needs Triage to CX2 on the ContentTranslation board.Jul 20 2018, 9:31 AM

KartikMistry closed this task as Resolved.Jul 23 2018, 12:40 PM

KartikMistry mentioned this in T201895: Third manual run of unpublished draft purge script.Aug 14 2018, 5:39 AM

KartikMistry mentioned this in T203059: Fourth manual run of unpublished draft purge script.Aug 29 2018, 6:23 AM