Maniphest T423841

Add section-level locking to scripts and cookbooks
Open, MediumPublic
Actions

Assigned To

Authored By

	FCeratto-WMF
	Apr 20 2026, 8:09 AM

Project Tags

Referenced Files

None

Subscribers

Description

Implement dc+section granularity lock in zarcillo and zarclient

Cookbooks:

Scripts:

Schema change helper
rolling_restart.py

Add ability to skip locking and to override locks using higher priority

Details

Related Changes in Gerrit:

	Subject	Author	Repo	Branch	Lines +/-
	cumin: Install pydantic and httpx packages	Federico Ceratto	operations/puppet	production	+5 -3

Customize query in gerrit

Related Changes in GitLab:

	Title	Reference	Author	Source Branch	Dest Branch
	schema_change_helper: lock sections on one DC only	repos/sre/schema-changes!64	fceratto	T423841	main
	Add zarclient	repos/sre/wmfmariadbpy!23	fceratto	T416301-2	main
	rolling_restart: add zarcillo locking	repos/data_persistence/dbtools/scripts!14	fceratto	T423841-2	main

Customize query in GitLab

Related Objects
Search...

		Status	Subtype	Assigned	Task
		Open		FCeratto-WMF	T423841 Add section-level locking to scripts and cookbooks
		Open		FCeratto-WMF	T239814 Automate DB upgrades
		Resolved		None	T374191 upgrade clone cookbook
		Declined		ABran-WMF	T376712 mysql_legacy: SQL query quote escape
		Resolved		ABran-WMF	T376701 mysql_legacy data_directory getter
		Resolved		ABran-WMF	T377129 mariadb: systemctl status accessor in mysql_legacy

Event Timeline

FCeratto-WMF created this task.Apr 20 2026, 8:09 AM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptApr 20 2026, 8:09 AM

FCeratto-WMF moved this task from Triage to Ready on the DBA board.Apr 20 2026, 8:09 AM

Marostegui triaged this task as Medium priority.Apr 20 2026, 12:26 PM

FCeratto-WMF updated the task description. (Show Details)Apr 20 2026, 12:36 PM

fceratto opened https://gitlab.wikimedia.org/repos/data_persistence/dbtools/scripts/-/merge_requests/14

rolling_restart: add zarcillo locking

FCeratto-WMF mentioned this in rOSMDf20c4985550c: Add zarclient.Apr 30 2026, 6:21 PM

FCeratto-WMF moved this task from Ready to In progress on the DBA board.May 4 2026, 1:33 PM

fceratto opened https://gitlab.wikimedia.org/repos/sre/wmfmariadbpy/-/merge_requests/23

Add zarclient

FCeratto-WMF mentioned this in rOSMDe22352c7ccd9: Add zarclient.May 4 2026, 2:29 PM

FCeratto-WMF mentioned this in rSCHCH11ad4789cce3: schema_change_helper: lock sections on one DC only.May 7 2026, 8:22 AM

fceratto opened https://gitlab.wikimedia.org/repos/sre/schema-changes/-/merge_requests/64

schema_change_helper: lock sections on one DC only

Change #1287378 had a related patch set uploaded (by Federico Ceratto; author: Federico Ceratto):

[operations/puppet@production] cumin: Install pydantic and httpx packages

https://gerrit.wikimedia.org/r/1287378

FCeratto-WMF updated the task description. (Show Details)May 14 2026, 3:10 PM

FCeratto-WMF added a subtask: T239814: Automate DB upgrades.

FCeratto-WMF updated the task description. (Show Details)

fceratto merged https://gitlab.wikimedia.org/repos/data_persistence/dbtools/scripts/-/merge_requests/13

Reflow code into functions

fceratto merged https://gitlab.wikimedia.org/repos/data_persistence/dbtools/scripts/-/merge_requests/14

rolling_restart: add zarcillo locking

FCeratto-WMF updated the task description. (Show Details)Jul 16 2026, 1:58 PM

FCeratto-WMF mentioned this in rSCHCH399f28228da6: schema_change_helper: lock sections on one DC only.Jul 21 2026, 9:25 AM

Change #1287378 abandoned by Federico Ceratto:

[operations/puppet@production] cumin: Install pydantic and httpx packages

Reason:

pydantic was installed in a different CR, httpx is not high priority now

https://gerrit.wikimedia.org/r/1287378