Make growthexperiments_link_recommendations.gelr_data nullable in the per-wiki x1 databases
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Urbanecm_WMF
	Jan 20 2025, 8:17 AM

Description

ALTER TABLEs to run: ALTER TABLE /*_*/growthexperiments_link_recommendations CHANGE gelr_data gelr_data MEDIUMBLOB DEFAULT NULL; (commit)
Where to run those changes: growthexperiments.dblist, per-wiki x1 databases
When to run those changes: As soon as possible.
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?: Yes, blocks T382270: Store the fact that Add Link did not generate any recommendation for a page, don't try again

Details

Related Changes in GitLab:

	Title	Reference	Author	Source Branch	Dest Branch
	change_growthexperiments_link_recommendations_T384177: New schema change	repos/sre/schema-changes!31	marostegui	T384177	main

Customize query in GitLab

Related Objects
Search...

Status	Assigned	Task
Resolved	KStoller-WMF	T368187 [EPIC] Constructive activation experimentation (Growth work related to Wiki Experiences 1.2)
Open	None	T360489 [EPIC] Generate and present edit suggestions at scale
Resolved	KStoller-WMF	T362584 [EPIC] Surface Structured Tasks to new editors (FY24/25: WE1.2.3 & WE1.2.6 & WE1.2.9)
Resolved	Michael	T382270 Store the fact that Add Link did not generate any recommendation for a page, don't try again
Resolved	Urbanecm_WMF	T383864 Make growthexperiments_link_recommendations.gelr_data nullable in GrowthExperiments
Resolved	Marostegui	T384177 Make growthexperiments_link_recommendations.gelr_data nullable in the per-wiki x1 databases

Event Timeline

Urbanecm_WMF created this task.Jan 20 2025, 8:17 AM

Restricted Application added a project: Data-Engineering. · View Herald TranscriptJan 20 2025, 8:17 AM

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

Urbanecm_WMF moved this task from Inbox to Tracking on the Growth-Team board.Jan 20 2025, 8:18 AM

Marostegui claimed this task.Jan 20 2025, 11:13 AM

Most of these tables are small enough that I think I can run this in the master with replication a a decent sleep, but I will send the gitlab merge request so it is tracked.

marostegui opened https://gitlab.wikimedia.org/repos/sre/schema-changes/-/merge_requests/31

change_growthexperiments_link_recommendations_T384177: New schema change

Marostegui triaged this task as Medium priority.Jan 20 2025, 4:22 PM

Marostegui moved this task from Triage to In progress on the DBA board.

Marostegui mentioned this in rSCHCH795cb46fcbed: change_growthexperiments_link_recommendations_T384177: New schema change.Jan 20 2025, 4:33 PM

KStoller-WMF subscribed.Jan 20 2025, 5:37 PM