Page MenuHomePhabricator

Create a maintenance script for populating the cuci_temp_edit and cuci_user tables
Closed, ResolvedPublic2 Estimated Story Points

Description

Technical background

In T368151 we added two central tables, cuci_temp_edit and cuci_user, to keep track of which wikis have been recently edited by a temporary user from a particular IP address and to keep track of which wikis have edited by a given user respectively.

Both tables hold a timestamp column, and then a few other columns which make each row unique.

Before we can start to use this table for GUC / global autoblocks, we will need to populate it with existing data. CheckUser already has some maintenance scripts for populating other tables (see CheckUser/maintenance directory).

This work can only start once T371788 is complete, to ensure that no entries are lost. Therefore, this script should also be able to handle cases where the data to be populated matches the data already in the table.

It may be desired to create two maintenance scripts if we are ready to use it on one table but not the other table.

What needs doing
  • Create a maintenance script for adding temporary user edits to the cuci_temp_edit and cuci_user tables
  • Add this maintenance script to update.php
  • Run this maintenance script on all wikis

Related Objects

StatusSubtypeAssignedTask
Resolvedkostajh
DeclinedNone
ResolvedNiharika
ResolvedMadalina
OpenNone
ResolvedDreamy_Jazz
OpenNone
OpenNone
OpenNone
OpenNone
ResolvedSTran
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz

Event Timeline

Dreamy_Jazz renamed this task from Create a maintenance script for populating the cuci_edit_temp table to Create a maintenance script for populating the cuci_temp_edit and cuci_user tables.Aug 21 2024, 12:24 PM
Dreamy_Jazz updated the task description. (Show Details)
Dreamy_Jazz updated the task description. (Show Details)
Dreamy_Jazz updated the task description. (Show Details)
JayCano set the point value for this task to 2.Aug 26 2024, 10:18 AM

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

[mediawiki/extensions/CheckUser@master] Add a maintenance script to populate central index tables

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

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

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

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

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

[mediawiki/core@master] Clarify documentation of Maintenance::runChild

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

Change #1069142 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@master] Add a maintenance script to populate central index tables

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

Change #1070038 merged by jenkins-bot:

[mediawiki/core@master] Clarify documentation of Maintenance::runChild

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

Change #1069143 merged by jenkins-bot:

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

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

dom_walden subscribed.

I ran the maintenance script populateCentralCheckUserIndexTables on my local wikis and compared the data in the cu_* tables with those in cuci_user and cuci_temp_edit tables.

Users who don't have a global ID will not be imported, such as those who have been globally deleted.