Page MenuHomePhabricator
Create Task
Maniphest T361673

Filter cu_useragent on sanitarium
Closed, ResolvedPublic
Actions

Description

cu_useragent is meant to be private, so it needs to be included in the replication filters. This implies restarting mariadb instances on sanitarium hosts in both codfw and eqiad

  • db1154
  • db1155
  • db2186
  • db2187

Details

SubjectRepoBranchLines +/-
common.yaml: Add cu_useragent to private tablesoperations/puppetproduction+1 -0
Customize query in gerrit

Related Objects
Search...

StatusSubtypeAssignedTask
 OpenFeatureNoneT315926 Provide a way to search all of the XFF addresses listed in the XFF string
 OpenFeatureNoneT326379 Normalise the XFF and user agent columns
 Resolved• TBolligerT120734 Epic ⚡️ Improve MediaWiki's blocking tools
 OpenNoneT146837 Add ability to search by user agent from CheckUser interface
 OpenNoneT147894 Create index for agent_id columns in the CheckUser result tables
 OpenNoneT305930 Normalize cu_changes table
 OpenNoneT361139 Normalise the user agent column in CheckUser result tables
 OpenNoneT361208 Remove agent columns from CheckUser result tables
 OpenNoneT361206 Stop writing old for user agent schema migration on WMF wikis
 OpenNoneT361205 Stop writing old for user agent schema migration
 OpenNoneT361199 Set user agent schema migration config to read new on WMF wikis
 OpenNoneT361201 Set user agent schema migration config to read new in extension.json
 OpenNoneT361192 Read user agent strings from the cu_useragent table in Special:CheckUser
 OpenNoneT361193 Read user agent strings from the cu_useragent table in the CheckUser API
 OpenNoneT361195 Read user agent strings from the cu_useragent table in Special:Investigate
 OpenNoneT361198 Create a maintenance script to populate the cu_useragent table and agent_id columns with values from the agent columns
 OpenNoneT361196 Write to the cu_useragent table and agent_id columns on WMF wikis
 OpenNoneT361197 Write to the cu_useragent table and agent_id columns on by default in extension.json
 OpenNoneT361174 Write to agent_id columns in the CheckUserInsert service when migration configuration allows it
 OpenNoneT361172 Purge rows from cu_useragent
 OpenNoneT361173 Add schema migration config for cu_useragent table
 ResolvedDreamy_JazzT361140 Add user agent ID column to each CheckUser result table
 ResolvedDreamy_JazzT361928 Update mediawiki.org pages for schema changes made by adding the cu_useragent table
 ResolvedDreamy_JazzT359312 Create cu_useragent table
 ResolvedMarosteguiT361673 Filter cu_useragent on sanitarium

Event Timeline

Marostegui triaged this task as High priority.Wed, Apr 3, 7:44 AM
Marostegui created this task.
Marostegui moved this task from Triage to In progress on the DBA board.
gerritbot added a comment.Wed, Apr 3, 7:56 AM

Change #1016706 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] common.yaml: Add cu_useragent to private tables

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

gerritbot added a project: Patch-For-Review.Wed, Apr 3, 7:56 AM
Marostegui added a comment.Wed, Apr 3, 8:01 AM

@Dreamy_Jazz take a look at https://gerrit.wikimedia.org/r/c/operations/puppet/+/1016706 when you have a chance

gerritbot added a comment.Wed, Apr 3, 8:11 AM

Change #1016706 merged by Marostegui:

[operations/puppet@production] common.yaml: Add cu_useragent to private tables

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

Stashbot added a comment.Wed, Apr 3, 8:36 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-03T08:36:18Z] <marostegui> stop sanitarium codfw hosts T361673

Marostegui added a comment.Wed, Apr 3, 8:46 AM

Restarted on codfw and the table was correctly caught:

-- Non-public tables that are present:
DROP TABLE IF EXISTS `enwiki`.`cu_useragent`;

Starting to sanitize all the wikis

Marostegui updated the task description. (Show Details)Wed, Apr 3, 9:15 AM
Stashbot added a comment.Wed, Apr 3, 9:27 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-03T09:27:37Z] <marostegui> Restart sanitarium db1155 T361673

Marostegui updated the task description. (Show Details)Wed, Apr 3, 9:48 AM
Stashbot added a comment.Wed, Apr 3, 10:10 AM

Mentioned in SAL (#wikimedia-operations) [2024-04-03T10:10:29Z] <marostegui> Restart sanitarium db1154 T361673

Marostegui updated the task description. (Show Details)Wed, Apr 3, 10:11 AM
Marostegui updated the task description. (Show Details)Wed, Apr 3, 10:55 AM

This is done - I am running a quick check on the clouddb* hosts to make sure it is all clean.

Dreamy_Jazz added a comment.Wed, Apr 3, 10:55 AM

Thanks!

Marostegui closed this task as Resolved.Wed, Apr 3, 10:57 AM

All good

Maintenance_bot moved this task from In progress to Done on the DBA board.Wed, Apr 3, 11:29 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