Make gemm_mentee_is_active a mwtinyint in the per-wiki x1 databases
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Urbanecm_WMF
	Jan 20 2025, 8:09 AM

Description

ALTER TABLEs to run: ALTER TABLE /*_*/growthexperiments_mentor_mentee CHANGE gemm_mentee_is_active gemm_mentee_is_active TINYINT DEFAULT 1 NOT NULL; (commit)
Where to run those changes: growthexperiments.dblist, per-wiki x1 databases
When to run those changes: At any time; low-priority (change is made to ensure Postgres compatibility)
If the schema change is backwards compatible: Yes
If the schema change has been tested already on some of the test/beta wikis: Deployed to beta wikis, no issues seen.
If the data should be made available on the labs replicas and/or dumps: Not applicable.
Is this schema change blocking a feature rollout?: No.

		Status	Subtype	Assigned	Task
		Resolved		Urbanecm_WMF	T383778 The `growthexperiments_mentor_mentee.gemm_mentee_is_active` DB column usees the "boolean" type, which is not supported with postgres
		Resolved		Marostegui	T384176 Make gemm_mentee_is_active a mwtinyint in the per-wiki x1 databases

Restricted Application added a subscriber: Aklapper. · View Herald Transcript

Urbanecm_WMF moved this task from Inbox to Tracking on the Growth-Team board.

They look pretty small so I will deploy this directly on the master with replication and some sleeps between databases.

Mentioned in SAL (#wikimedia-operations) [2025-01-20T08:15:25Z] <marostegui> Deploy schema change on x1 codfw master db2196 with replication dbmaint T384176

This is running, it will take a few hours.

Done