Maniphest T341830

Create maintenance script to delete entries only for read old
Open, Needs TriagePublic2 Estimated Story Points
Actions

Description

A maintenance script should be created that deletes entries that are only for use when reading old, that will be run once the event table migration config has been removed (and thus reading and writing is stable to the new tables).

Details

	Subject	Repo	Branch	Lines +/-
	Add deleteReadOldRowsInCuChanges.php to update.php	mediawiki/extensions/CheckUser	master	+17 -1
	Add a maintenance script to delete read old rows in cu_changes	mediawiki/extensions/CheckUser	master	+290 -1

Customize query in gerrit

Related Objects
Search...

View Standalone Graph

This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.

	Status	Subtype	Assigned	Task
				· · ·
	Open		None	T366546 Remove wgCheckUserEventTablesMigrationStage
	Open		Dreamy_Jazz	T341830 Create maintenance script to delete entries only for read old
	Resolved		Dreamy_Jazz	T341586 Allow write old and new for event table migration
	Open		Dreamy_Jazz	T360685 Stop writing old for event table migration on WMF wikis
				· · ·

Event Timeline

Dreamy_Jazz created this task.Jul 13 2023, 8:07 PM

Dreamy_Jazz added a subtask: T341586: Allow write old and new for event table migration.

Dreamy_Jazz updated the task description. (Show Details)Jul 13 2023, 8:14 PM

Dreamy_Jazz moved this task from Untriaged to CheckUser on the Anti-Harassment board.Jul 22 2023, 5:46 PM

Tchanders closed subtask T341586: Allow write old and new for event table migration as Resolved.Aug 14 2023, 10:21 AM

Dreamy_Jazz added a parent task: T360685: Stop writing old for event table migration on WMF wikis.Mar 28 2024, 9:49 AM

Dreamy_Jazz removed a parent task: T360685: Stop writing old for event table migration on WMF wikis.

Dreamy_Jazz added a subtask: T360685: Stop writing old for event table migration on WMF wikis.

TAdeleye_WMF edited projects, added Trust and Safety Product Team; removed Anti-Harassment.May 14 2024, 4:16 PM

Dreamy_Jazz added a project: Trust and Safety Product Sprint (Sprint Melodica (Jun 3 - Jun 14)).Mon, Jun 3, 10:53 PM

Dreamy_Jazz set the point value for this task to 2.

Dreamy_Jazz moved this task from Priority Backlog to In Progress on the Trust and Safety Product Sprint (Sprint Melodica (Jun 3 - Jun 14)) board.

Dreamy_Jazz mentioned this in T366546: Remove wgCheckUserEventTablesMigrationStage.Mon, Jun 3, 11:00 PM

Dreamy_Jazz removed a subtask: T366546: Remove wgCheckUserEventTablesMigrationStage.Mon, Jun 3, 11:02 PM

Dreamy_Jazz added a parent task: T366546: Remove wgCheckUserEventTablesMigrationStage.

Change #1038448 had a related patch set uploaded (by Dreamy Jazz; author: Dreamy Jazz):

[mediawiki/extensions/CheckUser@master] [WIP] Add a maintenance script to delete read old rows in cu_changes

https://gerrit.wikimedia.org/r/1038448

gerritbot added a project: Patch-For-Review.Mon, Jun 3, 11:36 PM

Change #1038870 had a related patch set uploaded (by Dreamy Jazz; author: Dreamy Jazz):

[mediawiki/extensions/CheckUser@master] Add deleteReadOldRowsInCuChanges.php to update.php

https://gerrit.wikimedia.org/r/1038870

Dreamy_Jazz moved this task from In Progress to Needs Review on the Trust and Safety Product Sprint (Sprint Melodica (Jun 3 - Jun 14)) board.Tue, Jun 4, 5:26 PM

Dreamy_Jazz mentioned this in T324907: Create separate tables for log events in CheckUser.Tue, Jun 4, 5:43 PM

Dreamy_Jazz removed a parent task: T324907: Create separate tables for log events in CheckUser.Wed, Jun 5, 4:45 PM

Dreamy_Jazz mentioned this in T366781: Run maintenance script to delete entries only for use when reading old on WMF wikis.Thu, Jun 6, 9:36 AM

Change #1038448 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@master] Add a maintenance script to delete read old rows in cu_changes

https://gerrit.wikimedia.org/r/1038448

ReleaseTaggerBot added a project: MW-1.43-notes (1.43.0-wmf.10; 2024-06-18).Mon, Jun 17, 4:00 PM

Dreamy_Jazz moved this task from Sprint Melodica (Jun 3 - Jun 14) to Sprint 12 (Jun 24 - July 5) on the Trust and Safety Product Sprint board.Tue, Jun 25, 10:42 AM

Dreamy_Jazz edited projects, added Trust and Safety Product Sprint (Sprint 12 (Jun 24 - July 5)); removed Trust and Safety Product Sprint (Sprint Melodica (Jun 3 - Jun 14)).

Dreamy_Jazz moved this task from Priority Backlog to Needs Review on the Trust and Safety Product Sprint (Sprint 12 (Jun 24 - July 5)) board.