Maniphest T341830

Create maintenance script to delete entries only for read old
Closed, ResolvedPublic2 Estimated Story Points
Actions

Assigned To

• Dreamy_Jazz

Authored By

	• Dreamy_Jazz
	Jul 13 2023, 8:07 PM

Tags

Referenced Files

None

Subscribers

• Dreamy_Jazz

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

Related Changes in Gerrit:

	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
				· · ·
	Resolved		• Dreamy_Jazz	T366546 Remove wgCheckUserEventTablesMigrationStage and related migration code
	Resolved		• Dreamy_Jazz	T366781 Run maintenance script to delete entries only for use when reading old on WMF wikis
	Resolved		• Dreamy_Jazz	T369539 Remove migration code from Hooks.php
	Resolved		• 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
	Resolved		• 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-Team 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-Team.May 14 2024, 4:16 PM

• Dreamy_Jazz added a project: Trust and Safety Product Sprint (Sprint Melodica (Jun 3 - Jun 14)).Jun 3 2024, 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 and related migration code.Jun 3 2024, 11:00 PM

• Dreamy_Jazz removed a subtask: T366546: Remove wgCheckUserEventTablesMigrationStage and related migration code.Jun 3 2024, 11:02 PM

• Dreamy_Jazz added a parent task: T366546: Remove wgCheckUserEventTablesMigrationStage and related migration code.

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.Jun 3 2024, 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.Jun 4 2024, 5:26 PM

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

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

• Dreamy_Jazz mentioned this in T366781: Run maintenance script to delete entries only for use when reading old on WMF wikis.Jun 6 2024, 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).Jun 17 2024, 4:00 PM

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

• Dreamy_Jazz edited projects, added Trust and Safety Product Sprint (Sprint Cajon (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 Cajon (Jun 24 - July 5)) board.

• Dreamy_Jazz closed subtask T360685: Stop writing old for event table migration on WMF wikis as Resolved.Jun 27 2024, 1:32 PM

• Dreamy_Jazz added a parent task: T366781: Run maintenance script to delete entries only for use when reading old on WMF wikis.Jun 28 2024, 10:19 AM

@Dreamy_Jazz I think this one could probably skip QA; if you agree, please resolve the task.

Change #1038870 merged by jenkins-bot:

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

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

ReleaseTaggerBot edited projects, added MW-1.43-notes (1.43.0-wmf.13; 2024-07-09); removed MW-1.43-notes (1.43.0-wmf.10; 2024-06-18).Jul 4 2024, 4:00 PM

• Dreamy_Jazz added a parent task: T369539: Remove migration code from Hooks.php.Jul 8 2024, 5:45 PM

Maintenance_bot removed a project: Patch-For-Review.Jul 9 2024, 7:53 PM

• Dreamy_Jazz closed this task as Resolved.Jul 10 2024, 9:33 AM

• Dreamy_Jazz moved this task from Needs QA to Done on the Trust and Safety Product Sprint (Sprint Cajon (Jun 24 - July 5)) board.