Update gb_id to be unsigned in the globalblocks table on WMF production
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Dreamy_Jazz
	May 27 2025, 2:32 PM

Description

Deployment of T381877: Older wikis with GlobalBlocking installed have an incorrect type for gb_id to WMF wikis

ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/extensions/GlobalBlocking/+/1148847/2/sql/mysql/patch-globalblocks-modify-gb_id-unsigned.sql
Where to run those changes: centralauth DB only
When to run those changes: At any time
If the schema change is backwards compatible: Yes
If the schema change has been tested already on some of the test/beta wikis: beta cluster is running with the new schema
if the data should be made available on the labs replicas and/or dumps: no change of the existing rules

Related Objects
Search...

Status	Assigned	Task
Open	None	T313251 Collect and fix schema drifts of wmf-deployed extension tables in production
Resolved	Dreamy_Jazz	T381502 Fix GlobalBlocking database schema drifts in production
Resolved	Dreamy_Jazz	T381877 Older wikis with GlobalBlocking installed have an incorrect type for gb_id
Resolved	Marostegui	T395333 Update gb_id to be unsigned in the globalblocks table on WMF production

Event Timeline

Dreamy_Jazz created this task.May 27 2025, 2:32 PM

Restricted Application added a project: Data-Engineering. · View Herald TranscriptMay 27 2025, 2:32 PM

Marostegui claimed this task.May 27 2025, 2:32 PM

Mentioned in SAL (#wikimedia-operations) [2025-05-27T14:34:32Z] <marostegui> Deploy schema change on s7 eqiad dbmaint T395333

Done on the master with replication

cumin2024@db1236.eqiad.wmnet[centralauth]> ALTER TABLE /*_*/globalblocks
    ->   CHANGE gb_id gb_id INT UNSIGNED AUTO_INCREMENT NOT NULL;
Query OK, 63485 rows affected (1.322 sec)
Records: 63485  Duplicates: 0  Warnings: 0

Marostegui added a project: DBA.May 27 2025, 2:36 PM

Thanks for the quick deployment!

Update gb_id to be unsigned in the globalblocks table on WMF productionClosed, ResolvedPublicActions

Description

Related ObjectsSearch...

Event Timeline

Update gb_id to be unsigned in the globalblocks table on WMF production
Closed, ResolvedPublic
Actions

Related Objects
Search...