Page MenuHomePhabricator
Create Task
Maniphest T366781

Run maintenance script to delete entries only for use when reading old on WMF wikis
Closed, ResolvedPublic2 Estimated Story Points
Actions

Description

Once T366546: Remove wgCheckUserEventTablesMigrationStage and related migration code is complete, and therefore the migration stage is set to read and write new only permanently, we can run the script to remove entries from cu_changes that are only for use when reading old that was added in T341830: Create maintenance script to delete entries only for read old on WMF wikis.

Acceptance criteria
  • Run deleteReadOldRowsInCuChanges.php on testwiki
  • Run deleteReadOldRowsInCuChanges.php on group0 wikis
  • Run deleteReadOldRowsInCuChanges.php on group1 wikis
  • Run deleteReadOldRowsInCuChanges.php on group2 wikis

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.
StatusSubtypeAssignedTask
· · ·
DeclinedNoneT366783 Remove remaining code related to event tables migration
ResolvedDreamy_JazzT366546 Remove wgCheckUserEventTablesMigrationStage and related migration code
ResolvedDreamy_JazzT366781 Run maintenance script to delete entries only for use when reading old on WMF wikis
ResolvedDreamy_JazzT341830 Create maintenance script to delete entries only for read old
· · ·

Event Timeline

Dreamy_Jazz created this task.Jun 6 2024, 9:36 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJun 6 2024, 9:36 AM
Dreamy_Jazz added a subtask: T366546: Remove wgCheckUserEventTablesMigrationStage and related migration code.Jun 6 2024, 9:36 AM
Dreamy_Jazz added a project: CheckUser.Jun 6 2024, 9:43 AM
Dreamy_Jazz removed Dreamy_Jazz as the assignee of this task.Jun 6 2024, 9:47 AM
Dreamy_Jazz mentioned this in T366783: Remove remaining code related to event tables migration.
Dreamy_Jazz added a parent task: T366783: Remove remaining code related to event tables migration.
Dreamy_Jazz mentioned this in T366546: Remove wgCheckUserEventTablesMigrationStage and related migration code.Jun 6 2024, 9:50 AM
Dreamy_Jazz merged a task: T368419: Run deleteReadOldRowsInCuChanges.php on WMF wikis.Jun 25 2024, 3:23 PM
Dreamy_Jazz updated the task description. (Show Details)
Stashbot added a comment.Jun 25 2024, 3:31 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-25T15:31:25Z] <Dreamy_Jazz> Ran mwscript extensions/CheckUser/maintenance/deleteReadOldRowsInCuChanges.php --wiki=testwiki for T366781

Dreamy_Jazz claimed this task.Jun 25 2024, 3:58 PM
Stashbot added a comment.Jun 27 2024, 11:05 PM

Mentioned in SAL (#wikimedia-operations) [2024-06-27T23:05:32Z] <Dreamy_Jazz> Running foreachwikiindblist group0.dblist extensions/CheckUser/maintenance/deleteReadOldRowsInCuChanges.php for T366781

Dreamy_Jazz updated the task description. (Show Details)Jun 27 2024, 11:09 PM
Dreamy_Jazz removed a subtask: T366546: Remove wgCheckUserEventTablesMigrationStage and related migration code.Jun 28 2024, 10:18 AM
Dreamy_Jazz added a parent task: T366546: Remove wgCheckUserEventTablesMigrationStage and related migration code.
Dreamy_Jazz added a subtask: T341830: Create maintenance script to delete entries only for read old.
Dreamy_Jazz removed a parent task: T324907: Create separate tables for log events in CheckUser.Jun 28 2024, 10:22 AM
Dreamy_Jazz mentioned this in T324907: Create separate tables for log events in CheckUser.
Dreamy_Jazz added a project: Trust and Safety Product Sprint (Sprint Cajon (Jun 24 - July 5)).Jun 28 2024, 10:44 AM
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 Cajon (Jun 24 - July 5)) board.
Stashbot added a comment.Jun 28 2024, 11:13 AM

Mentioned in SAL (#wikimedia-operations) [2024-06-28T11:13:16Z] <Dreamy_Jazz> Running foreachwikiindblist medium.dblist extensions/CheckUser/maintenance/deleteReadOldRowsInCuChanges.php --batch-size=200 for T366781. medium.dblist does not include loginwiki or metawiki (which are to be done later).

Dreamy_Jazz added a comment.Jul 8 2024, 8:54 AM

Started foreachwikiindblist group1.dblist extensions/CheckUser/maintenance/deleteReadOldRowsInCuChanges.php --batch-size=200 in a tmux session.

Dreamy_Jazz mentioned this in T369539: Remove migration code from Hooks.php.Jul 8 2024, 5:37 PM
Dreamy_Jazz updated the task description. (Show Details)Jul 9 2024, 6:54 AM
Dreamy_Jazz added a comment.Jul 9 2024, 6:56 AM

Started foreachwikiindblist group2.dblist extensions/CheckUser/maintenance/deleteReadOldRowsInCuChanges.php --batch-size=300 in a tmux session

Stashbot added a comment.Jul 9 2024, 10:37 AM

Mentioned in SAL (#wikimedia-operations) [2024-07-09T10:37:12Z] <Dreamy_Jazz> Finished running maintenance scripts for T366781

Dreamy_Jazz updated the task description. (Show Details)Jul 9 2024, 10:37 AM
Dreamy_Jazz closed this task as Resolved.Jul 9 2024, 10:40 AM
Dreamy_Jazz moved this task from In Progress to Done on the Trust and Safety Product Sprint (Sprint Cajon (Jun 24 - July 5)) board.
Dreamy_Jazz closed subtask T341830: Create maintenance script to delete entries only for read old as Resolved.Jul 10 2024, 9:33 AM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits