Add schema migration config for cu_useragent table
Closed, ResolvedPublic0.1 Estimated Story Points
Actions

Assigned To

Authored By

	Dreamy_Jazz
	Mar 27 2024, 11:59 PM

Description

A schema migration configuration value is needed to support a staged deployment for using the cu_useragent table.

Acceptance criteria

The schema migration is created with the value for the time being set to SCHEMA_COMPAT_OLD
The schema migration value should be pinned on all WMF wikis to SCHEMA_COMPAT_OLD

Details

Related Changes in Gerrit:

	Subject	Repo	Branch	Lines +/-
	Define $wgCheckUserUserAgentTableMigrationStage	mediawiki/extensions/CheckUser	master	+4 -0
	Pin $wgCheckUserUserAgentTableMigrationStage as SCHEMA_COMPAT_OLD	operations/mediawiki-config	master	+5 -0

Customize query in gerrit

Related Objects
Search...

Status	Assigned	Task
Resolved	• TBolliger	T120734 Epic ⚡️ Improve MediaWiki's blocking tools
Open	None	T146837 Add ability to search by user agent from CheckUser interface
Open	None	T249374 CU 2.0: Filter out exact UAs in the Compare tab
Open	None	T147894 Create index for agent_id columns in the CheckUser result tables
Resolved	Dreamy_Jazz	T305930 Normalize cu_changes table
Resolved	Dreamy_Jazz	T361139 Normalise the user agent column in CheckUser result tables
Resolved	Dreamy_Jazz	T361208 Remove agent columns from CheckUser result tables
Resolved	Dreamy_Jazz	T361206 Stop writing old for user agent schema migration on WMF wikis
Resolved	Dreamy_Jazz	T361205 Stop writing old for user agent schema migration
Resolved	Dreamy_Jazz	T361199 Set user agent schema migration config to read new on WMF wikis
Resolved	Dreamy_Jazz	T361201 Set user agent schema migration config to read new in extension.json
Resolved	Dreamy_Jazz	T361192 Read user agent strings from the cu_useragent table in Special:CheckUser
Resolved	Dreamy_Jazz	T361193 Read user agent strings from the cu_useragent table in the CheckUser API
Resolved	Dreamy_Jazz	T361195 Read user agent strings from the cu_useragent table in Special:Investigate
Resolved	Dreamy_Jazz	T413893 Read from the agent_id column in misc interfaces
Resolved	Dreamy_Jazz	T413868 Populate the cu_useragent table and agent_id columns on WMF wikis
Resolved	Dreamy_Jazz	T361198 Create a maintenance script to populate the cu_useragent table and agent_id columns with values from the agent columns
Resolved	Dreamy_Jazz	T361196 Write to the cu_useragent table and agent_id columns on WMF wikis
Resolved	Dreamy_Jazz	T361197 Write to the cu_useragent table and agent_id columns on by default in extension.json
Resolved	Dreamy_Jazz	T361172 Purge rows from cu_useragent
Resolved	Dreamy_Jazz	T413873 Update remaining code that writes to the CheckUser result tables to write to the agent_id columns
Resolved	Dreamy_Jazz	T361174 Write to agent_id columns in the CheckUserInsert service when migration configuration allows it
Resolved	Dreamy_Jazz	T361173 Add schema migration config for cu_useragent table
Resolved	Dreamy_Jazz	T361140 Add user agent ID column to each CheckUser result table
Resolved	Dreamy_Jazz	T359312 Create cu_useragent table
Resolved	Marostegui	T361631 Unable to create table cu_useragent on labtestwiki
Declined	None	T328289 update labtestwiki user and password
Resolved	Papaul	T369308 Decommission clouddb2002-dev.codfw.wmnet
Resolved	taavi	T378260 Retire labtestwiki
Resolved	Marostegui	T361673 Filter cu_useragent on sanitarium
Resolved	Snwachukwu	T361210 Changes to the cuc_agent column in the cu_changes table

Event Timeline

Dreamy_Jazz created this task.Mar 27 2024, 11:59 PM

Dreamy_Jazz mentioned this in T361174: Write to agent_id columns in the CheckUserInsert service when migration configuration allows it.Mar 28 2024, 12:04 AM

Dreamy_Jazz added a parent task: T361174: Write to agent_id columns in the CheckUserInsert service when migration configuration allows it.

Dreamy_Jazz removed a parent task: T361139: Normalise the user agent column in CheckUser result tables.

Dreamy_Jazz added a parent task: T361172: Purge rows from cu_useragent.Mar 28 2024, 9:31 AM

Dreamy_Jazz mentioned this in T361196: Write to the cu_useragent table and agent_id columns on WMF wikis.Mar 28 2024, 10:00 AM

Dreamy_Jazz mentioned this in T361197: Write to the cu_useragent table and agent_id columns on by default in extension.json.

Dreamy_Jazz added a subtask: T361140: Add user agent ID column to each CheckUser result table.Mar 28 2024, 10:05 AM

Dreamy_Jazz mentioned this in T361199: Set user agent schema migration config to read new on WMF wikis.Mar 28 2024, 10:20 AM

Dreamy_Jazz mentioned this in T361201: Set user agent schema migration config to read new in extension.json.Mar 28 2024, 10:26 AM

Dreamy_Jazz updated the task description. (Show Details)

Dreamy_Jazz mentioned this in T361205: Stop writing old for user agent schema migration.Mar 28 2024, 10:33 AM

Dreamy_Jazz mentioned this in T361206: Stop writing old for user agent schema migration on WMF wikis.

Dreamy_Jazz closed subtask T361140: Add user agent ID column to each CheckUser result table as Resolved.Apr 4 2024, 2:20 PM

Dreamy_Jazz moved this task from Inbox to Engineering on the Trust and Safety Product Team board.Aug 6 2025, 12:24 PM

Dreamy_Jazz added a project: Trust and Safety Product Sprint.

Dreamy_Jazz moved this task from Backlog to Maintenance to triage on the Trust and Safety Product Sprint board.

Dreamy_Jazz set the point value for this task to 0.1.

Dreamy_Jazz added a project: Essential-Work.Aug 14 2025, 10:36 AM

OKryva-WMF edited projects, added Product Safety and Integrity; removed Trust and Safety Product Sprint.Sep 26 2025, 12:55 PM

OKryva-WMF moved this task from Inbox to Next sprint on the Product Safety and Integrity board.Sep 26 2025, 12:57 PM

OKryva-WMF removed a project: Trust and Safety Product Team.Oct 10 2025, 9:54 AM

Dreamy_Jazz moved this task from Next sprint to Essential Work Sprint (Dec 15th - Jan 9th) on the Product Safety and Integrity board.Nov 19 2025, 12:40 PM

Dreamy_Jazz edited projects, added Product Safety and Integrity (Essential Work Sprint (Dec 15th - Jan 9th)); removed Product Safety and Integrity.

OKryva-WMF moved this task from Backlog to Ready on the Product Safety and Integrity (Essential Work Sprint (Dec 15th - Jan 9th)) board.Dec 15 2025, 2:18 PM

Dreamy_Jazz claimed this task.Dec 16 2025, 1:08 PM

Dreamy_Jazz moved this task from Ready to In progress on the Product Safety and Integrity (Essential Work Sprint (Dec 15th - Jan 9th)) board.

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

[mediawiki/extensions/CheckUser@master] Define $wgCheckUserUserAgentTableMigrationStage

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

gerritbot added a project: Patch-For-Review.Dec 16 2025, 1:12 PM

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

[operations/mediawiki-config@master] Pin $wgCheckUserUserAgentTableMigrationStage as SCHEMA_COMPAT_OLD

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

Dreamy_Jazz moved this task from In progress to Needs review on the Product Safety and Integrity (Essential Work Sprint (Dec 15th - Jan 9th)) board.Dec 16 2025, 1:17 PM

Change #1218763 merged by jenkins-bot:

[operations/mediawiki-config@master] Pin $wgCheckUserUserAgentTableMigrationStage as SCHEMA_COMPAT_OLD

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

Mentioned in SAL (#wikimedia-operations) [2025-12-16T14:49:53Z] <dreamyjazz@deploy2002> Started scap sync-world: Backport for [[gerrit:1218763|Pin $wgCheckUserUserAgentTableMigrationStage as SCHEMA_COMPAT_OLD (T361173)]]

Mentioned in SAL (#wikimedia-operations) [2025-12-16T14:52:07Z] <dreamyjazz@deploy2002> dreamyjazz: Backport for [[gerrit:1218763|Pin $wgCheckUserUserAgentTableMigrationStage as SCHEMA_COMPAT_OLD (T361173)]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verified there.

Mentioned in SAL (#wikimedia-operations) [2025-12-16T14:56:48Z] <dreamyjazz@deploy2002> Finished scap sync-world: Backport for [[gerrit:1218763|Pin $wgCheckUserUserAgentTableMigrationStage as SCHEMA_COMPAT_OLD (T361173)]] (duration: 06m 55s)