Page MenuHomePhabricator

Make gbw_id in global_block_whitelist table unsigned on WMF wikis
Closed, ResolvedPublic

Description

Deployment of changes to WMF wikis of update to gbw_id in global_block_whitelist for T381877: Older wikis with GlobalBlocking installed have an incorrect type for gb_id

  1. ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/extensions/GlobalBlocking/+/1148854/3/sql/mysql/patch-global_block_whitelist-modify-gbw_id-unsigned.sql
  2. Where to run those changes: all.dblist
  3. When to run those changes: At any time
  4. If the schema change is backwards compatible: Yes
  5. If the schema change has been tested already on some of the test/beta wikis: beta cluster will be running with the new schema shortly
  6. if the data should be made available on the labs replicas and/or dumps: no change of the existing rules

Progress

  • s1
  • s2
  • s3
  • s4
  • s5
  • s6
  • s7
  • s8

Details

Related Changes in GitLab:
TitleReferenceAuthorSource BranchDest Branch
change_gbw_id_T395335.py: New schema changerepos/sre/schema-changes!37marosteguiT395335main
Customize query in GitLab

Event Timeline

Marostegui triaged this task as Medium priority.
Marostegui moved this task from Triage to In progress on the DBA board.
Milimetric subscribed.

no impact on our pipelines, thanks!

Mentioned in SAL (#wikimedia-operations) [2025-05-29T12:15:19Z] <marostegui> Deploy schema change on s6 eqiad dbmaint with replication T395335

Mentioned in SAL (#wikimedia-operations) [2025-05-29T12:16:18Z] <marostegui> Deploy schema change on s2 eqiad dbmaint with replication T395335

Mentioned in SAL (#wikimedia-operations) [2025-05-29T12:18:38Z] <marostegui> Deploy schema change on s5 eqiad dbmaint with replication T395335

Mentioned in SAL (#wikimedia-operations) [2025-05-29T12:22:05Z] <marostegui> Deploy schema change on s8 eqiad dbmaint with replication T395335

Mentioned in SAL (#wikimedia-operations) [2025-05-29T12:22:48Z] <marostegui> Deploy schema change on s4 eqiad dbmaint with replication T395335

Mentioned in SAL (#wikimedia-operations) [2025-05-29T12:23:23Z] <marostegui> Deploy schema change on s1 eqiad dbmaint with replication T395335

Mentioned in SAL (#wikimedia-operations) [2025-05-29T12:36:37Z] <marostegui> Deploy schema change on s7 eqiad dbmaint with replication T395335

Mentioned in SAL (#wikimedia-operations) [2025-05-29T12:38:20Z] <marostegui> Deploy schema change on s3 eqiad dbmaint with replication T395335

Running the change in s3. It will take around 4 hours.

Marostegui updated the task description. (Show Details)

Complete