Page MenuHomePhabricator

Remove agent columns from CheckUser result tables
Closed, ResolvedPublic0.75 Estimated Story Points

Description

Once enough time has passed since T361206: Stop writing old for user agent schema migration on WMF wikis, the agent column (e.g. cuc_agent, cupe_agent) should be removed from the CheckUser result tables (e.g. cu_changes, cu_log_event).

Acceptance criteria
  • The $wgCheckUserUserAgentTableMigrationStage config is dropped, replacing all uses with an assumption of read and write new
  • The cuc_agent, cule_agent, and cupe_agent columns are removed from the cu_changes, cu_log_event and cu_private_event tables respectively in the master branch of CheckUser
  • A Schema-change-in-production ticket is filed to track applying the schema change to WMF wikis - T418465

Related Objects

StatusSubtypeAssignedTask
Resolved TBolliger
OpenNone
OpenNone
OpenNone
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedMarostegui
DeclinedNone
ResolvedPapaul
Resolvedtaavi
ResolvedMarostegui
InvalidDreamy_Jazz
ResolvedSnwachukwu

Event Timeline

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

[mediawiki/extensions/CheckUser@master] [WIP] Drop CheckUserUserAgentTableMigrationStage config

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

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

[mediawiki/extensions/CheckUser@master] Drop old support for cu_useragent table migration in user interfaces

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

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

[mediawiki/extensions/CheckUser@master] Drop cupe_agent from the cu_private_event table

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

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

[mediawiki/extensions/CheckUser@master] Drop cuc_agent from the cu_changes table

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

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

[mediawiki/extensions/CheckUser@master] Drop cule_agent from the cu_log_event table

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

Change #1238746 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@master] Drop old support for cu_useragent table migration in user interfaces

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

Change #1238743 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@master] Drop CheckUserUserAgentTableMigrationStage config

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

Dreamy_Jazz changed the point value for this task from 0.5 to 0.75.Feb 20 2026, 11:07 AM

Change #1238758 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@master] Drop cupe_agent from the cu_private_event table

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

Change #1238761 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@master] Drop cuc_agent from the cu_changes table

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

Change #1238763 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@master] Drop cule_agent from the cu_log_event table

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