Page MenuHomePhabricator

Remove default value from gb_by_wiki in globalblocks table on WMF wikis
Closed, ResolvedPublic

Description

  1. ALTERs to run:
ALTER TABLE /*_*/globalblocks
  CHANGE gb_by_wiki gb_by_wiki VARBINARY(255) NOT NULL;
  1. Where to run those changes: centralauth DB
  2. When to run those changes: When DBA has time, very low priority
  3. If the schema change is backwards compatible: Yes
  4. If the schema change has been tested already on some of the test/beta wikis: The beta wikis do not have a default set for gb_by_wiki
  5. If the data should be made available on the labs replicas and/or dumps: Yes, no changes to existing rules needed

As detailed in T381502: Fix GlobalBlocking database schema drifts in production, the gb_by_wiki column has a default set on WMF wikis but the GlobalBlocking extension schema has this without a default set. Looking further, it seems that there was no default set in the SQL that was defined before the conversion to an abstract schema, so it seems that we shouldn't need a patch to GlobalBlocking to address this.

Acceptance criteria

  • The default value on gb_by_wiki is removed from the globalblocks table on the centralauth DB

Event Timeline

Dreamy_Jazz renamed this task from Remove default value from gb_by_wiki to Remove default value from gb_by_wiki on WMF wikis.Jan 9 2026, 11:27 AM
Dreamy_Jazz renamed this task from Remove default value from gb_by_wiki on WMF wikis to Remove default value from gb_by_wiki in globalblocks table on WMF wikis.Jan 9 2026, 11:31 AM
Dreamy_Jazz updated the task description. (Show Details)
Dreamy_Jazz updated the task description. (Show Details)

Mentioned in SAL (#wikimedia-operations) [2026-01-09T12:16:24Z] <marostegui> Deploy schema change on s7 primary master T414178

Marostegui claimed this task.

Done on the master with replication:

cumin2024@db2218.codfw.wmnet[centralauth]> ALTER TABLE /*_*/globalblocks
    ->   CHANGE gb_by_wiki gb_by_wiki VARBINARY(255) NOT NULL;
Query OK, 0 rows affected (0.118 sec)
Records: 0  Duplicates: 0  Warnings: 0

cumin2024@db2218.codfw.wmnet[centralauth]>