Page MenuHomePhabricator
Create Task
Maniphest T361199

Set user agent schema migration config to read new on WMF wikis
Closed, ResolvedPublic
Actions

Description

Once the subtasks are completed, it will be possible to start progressively reading new for the user agent string migration.

Acceptance criteria
  • The schema migration config added in T361173 should be set to SCHEMA_COMPAT_NEW | SCHEMA_COMPAT_WRITE_OLD on all WMF wikis
    • group0
    • group1
    • group2

Details

Related Changes in Gerrit:
SubjectRepoBranchLines +/-
CheckUser: Read new for user agent table migration everywhereoperations/mediawiki-configmaster+1 -3
CheckUser: Enable read new for user agent table migration on group1operations/mediawiki-configmaster+1 -0
CheckUser: Read new for user agent table migration on group0operations/mediawiki-configmaster+1 -0
Customize query in gerrit

Related Objects
Search...

StatusSubtypeAssignedTask
 Resolved• TBolligerT120734 Epic ⚡️ Improve MediaWiki's blocking tools
 OpenNoneT146837 Add ability to search by user agent from CheckUser interface
 OpenNoneT249374 CU 2.0: Filter out exact UAs in the Compare tab
 OpenNoneT147894 Create index for agent_id columns in the CheckUser result tables
 ResolvedDreamy_JazzT305930 Normalize cu_changes table
 ResolvedDreamy_JazzT361139 Normalise the user agent column in CheckUser result tables
 ResolvedDreamy_JazzT361208 Remove agent columns from CheckUser result tables
 ResolvedDreamy_JazzT361206 Stop writing old for user agent schema migration on WMF wikis
 ResolvedDreamy_JazzT361205 Stop writing old for user agent schema migration
 ResolvedDreamy_JazzT361199 Set user agent schema migration config to read new on WMF wikis
 ResolvedDreamy_JazzT361201 Set user agent schema migration config to read new in extension.json
 ResolvedDreamy_JazzT361192 Read user agent strings from the cu_useragent table in Special:CheckUser
 ResolvedDreamy_JazzT361193 Read user agent strings from the cu_useragent table in the CheckUser API
 ResolvedDreamy_JazzT361195 Read user agent strings from the cu_useragent table in Special:Investigate
 ResolvedDreamy_JazzT413893 Read from the agent_id column in misc interfaces
 ResolvedDreamy_JazzT413868 Populate the cu_useragent table and agent_id columns on WMF wikis
 ResolvedDreamy_JazzT361198 Create a maintenance script to populate the cu_useragent table and agent_id columns with values from the agent columns
 ResolvedDreamy_JazzT361196 Write to the cu_useragent table and agent_id columns on WMF wikis
 ResolvedDreamy_JazzT361197 Write to the cu_useragent table and agent_id columns on by default in extension.json
 ResolvedDreamy_JazzT361172 Purge rows from cu_useragent
 ResolvedDreamy_JazzT413873 Update remaining code that writes to the CheckUser result tables to write to the agent_id columns
 ResolvedDreamy_JazzT361174 Write to agent_id columns in the CheckUserInsert service when migration configuration allows it
 ResolvedDreamy_JazzT361173 Add schema migration config for cu_useragent table
 ResolvedDreamy_JazzT361140 Add user agent ID column to each CheckUser result table
 ResolvedDreamy_JazzT359312 Create cu_useragent table
 ResolvedMarosteguiT361631 Unable to create table cu_useragent on labtestwiki
 DeclinedNoneT328289 update labtestwiki user and password
 ResolvedPapaulT369308 Decommission clouddb2002-dev.codfw.wmnet
 ResolvedtaaviT378260 Retire labtestwiki
 ResolvedMarosteguiT361673 Filter cu_useragent on sanitarium
 ResolvedSnwachukwuT361210 Changes to the cuc_agent column in the cu_changes table

Event Timeline

Dreamy_Jazz created this task.Mar 28 2024, 10:20 AM
Dreamy_Jazz added a subtask: T361196: Write to the cu_useragent table and agent_id columns on WMF wikis.Mar 28 2024, 10:28 AM
Dreamy_Jazz mentioned this in T361205: Stop writing old for user agent schema migration.Mar 28 2024, 10:33 AM
Dreamy_Jazz added a parent task: T361205: Stop writing old for user agent schema migration.
Dreamy_Jazz mentioned this in T361210: Changes to the cuc_agent column in the cu_changes table.Mar 28 2024, 10:41 AM
Dreamy_Jazz moved this task from Inbox to Engineering on the Trust and Safety Product Team board.Aug 6 2025, 12:23 PM
Dreamy_Jazz added a project: Essential-Work.Aug 14 2025, 10:37 AM
OKryva-WMF edited projects, added Product Safety and Integrity; removed Trust and Safety Product Team.Oct 10 2025, 9:53 AM
OKryva-WMF moved this task from Inbox to Later sprints on the Product Safety and Integrity board.Oct 10 2025, 9:53 AM
Dreamy_Jazz updated the task description. (Show Details)Jan 6 2026, 11:19 AM
Dreamy_Jazz created subtask T413868: Populate the cu_useragent table and agent_id columns on WMF wikis.
Dreamy_Jazz closed subtask T361201: Set user agent schema migration config to read new in extension.json as Resolved.Jan 8 2026, 12:10 PM
Dreamy_Jazz closed subtask T361196: Write to the cu_useragent table and agent_id columns on WMF wikis as Resolved.Jan 19 2026, 1:49 PM
Dreamy_Jazz mentioned this in T361195: Read user agent strings from the cu_useragent table in Special:Investigate.Jan 19 2026, 4:22 PM
Dreamy_Jazz mentioned this in T361192: Read user agent strings from the cu_useragent table in Special:CheckUser.
Dreamy_Jazz closed subtask T413868: Populate the cu_useragent table and agent_id columns on WMF wikis as Resolved.Jan 22 2026, 12:55 PM
gerritbot added a comment.Jan 22 2026, 10:50 PM

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

[operations/mediawiki-config@master] CheckUser: Read new for user agent table migration on group0

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

gerritbot added a project: Patch-For-Review.Jan 22 2026, 10:50 PM

Change #1230488 merged by jenkins-bot:

[operations/mediawiki-config@master] CheckUser: Read new for user agent table migration on group0

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

Stashbot added a comment.Jan 22 2026, 10:51 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-22T22:51:54Z] <dreamyjazz@deploy2002> Started scap sync-world: Backport for [[gerrit:1230488|CheckUser: Read new for user agent table migration on group0 (T361199)]]

Stashbot added a comment.Jan 22 2026, 10:53 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-22T22:53:58Z] <dreamyjazz@deploy2002> dreamyjazz: Backport for [[gerrit:1230488|CheckUser: Read new for user agent table migration on group0 (T361199)]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verified there.

Stashbot added a comment.Jan 22 2026, 11:01 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-22T23:01:33Z] <dreamyjazz@deploy2002> Finished scap sync-world: Backport for [[gerrit:1230488|CheckUser: Read new for user agent table migration on group0 (T361199)]] (duration: 09m 39s)

Maintenance_bot removed a project: Patch-For-Review.Jan 22 2026, 11:31 PM
Dreamy_Jazz edited projects, added Product Safety and Integrity (Sprint Daffodil (Jan 19 - Feb 6)); removed Product Safety and Integrity.Jan 23 2026, 10:06 AM
Dreamy_Jazz updated the task description. (Show Details)Jan 23 2026, 12:22 PM
Dreamy_Jazz updated the task description. (Show Details)
Dreamy_Jazz claimed this task.Jan 23 2026, 2:13 PM
Dreamy_Jazz moved this task from Backlog to In progress on the Product Safety and Integrity (Sprint Daffodil (Jan 19 - Feb 6)) board.
gerritbot added a comment.Jan 27 2026, 1:52 PM

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

[operations/mediawiki-config@master] CheckUser: Enable read new for user agent table migration on group1

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

gerritbot added a project: Patch-For-Review.Jan 27 2026, 1:52 PM
gerritbot added a comment.Jan 27 2026, 1:56 PM

Change #1233706 merged by jenkins-bot:

[operations/mediawiki-config@master] CheckUser: Enable read new for user agent table migration on group1

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

Stashbot added a comment.Jan 27 2026, 1:57 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-27T13:57:30Z] <dreamyjazz@deploy2002> Started scap sync-world: Backport for [[gerrit:1233706|CheckUser: Enable read new for user agent table migration on group1 (T361199)]]

Stashbot added a comment.Jan 27 2026, 1:59 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-27T13:59:38Z] <dreamyjazz@deploy2002> dreamyjazz: Backport for [[gerrit:1233706|CheckUser: Enable read new for user agent table migration on group1 (T361199)]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verified there.

Stashbot added a comment.Jan 27 2026, 2:08 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-27T14:08:47Z] <dreamyjazz@deploy2002> Finished scap sync-world: Backport for [[gerrit:1233706|CheckUser: Enable read new for user agent table migration on group1 (T361199)]] (duration: 11m 16s)

Dreamy_Jazz updated the task description. (Show Details)Jan 27 2026, 2:29 PM
Maintenance_bot removed a project: Patch-For-Review.Jan 27 2026, 2:32 PM
gerritbot added a comment.Jan 27 2026, 4:19 PM

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

[operations/mediawiki-config@master] CheckUser: Read new for user agent table migration everywhere

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

gerritbot added a project: Patch-For-Review.Jan 27 2026, 4:19 PM
gerritbot added a comment.Jan 28 2026, 2:54 PM

Change #1233752 merged by jenkins-bot:

[operations/mediawiki-config@master] CheckUser: Read new for user agent table migration everywhere

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

Stashbot added a comment.Jan 28 2026, 2:54 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-28T14:54:31Z] <dreamyjazz@deploy2002> Started scap sync-world: Backport for [[gerrit:1233752|CheckUser: Read new for user agent table migration everywhere (T361199)]]

Stashbot added a comment.Jan 28 2026, 2:56 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-28T14:56:53Z] <dreamyjazz@deploy2002> dreamyjazz: Backport for [[gerrit:1233752|CheckUser: Read new for user agent table migration everywhere (T361199)]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verified there.

Stashbot added a comment.Jan 28 2026, 3:04 PM

Mentioned in SAL (#wikimedia-operations) [2026-01-28T15:04:30Z] <dreamyjazz@deploy2002> Finished scap sync-world: Backport for [[gerrit:1233752|CheckUser: Read new for user agent table migration everywhere (T361199)]] (duration: 09m 58s)

Dreamy_Jazz closed this task as Resolved.Jan 28 2026, 3:07 PM
Dreamy_Jazz updated the task description. (Show Details)
Dreamy_Jazz moved this task from In progress to Done on the Product Safety and Integrity (Sprint Daffodil (Jan 19 - Feb 6)) board.
Maintenance_bot removed a project: Patch-For-Review.Jan 28 2026, 3:34 PM
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