Map of database maintenance

Here you can follow maintenance on our databases. This is useful to spot potential causes for issues in production or avoid interfering with another maintenance work.

A script parses dbctl SAL logs and add entries here. Furthermore, DBAs can add manual entries in this list by logging SAL. It is important that SAL must contain the word "dbmaint", a phabricator ticket id, a section name and name of the datacenter. For example: "!log dbmaint on s2@codfw (T12345)"

Yesterday (2022-06-10)

eqiad

Section	Work
s1	Fix mismatching field type of revision.rev_timestamp on wmf wikis (T298560) (ladsgroup)

Last seven days

eqiad

Section	Work
s1	Fix mismatching field type of revision.rev_timestamp on wmf wikis (T298560) (ladsgroup) Move db1128 from m1 (misc) to s1 (mediawiki) (T309303) (marostegui)
s2	Adjust the field type of cu_changes.cuc_timestamp to fixed binary and remove default on wmf wikis (T310011) (marostegui)
s4	Fix mismatching field type of revision.rev_timestamp on wmf wikis (T298560) (ladsgroup) Migrate a s4 DB host to mariadb 10.6 (T310114) (marostegui)
s5	Adjust the field type of cu_changes.cuc_timestamp to fixed binary and remove default on wmf wikis (T310011) (marostegui)
s6	Adjust the field type of cu_changes.cuc_timestamp to fixed binary and remove default on wmf wikis (T310011) (marostegui)
s7	Adjust the field type of cu_changes.cuc_timestamp to fixed binary and remove default on wmf wikis (T310011) (marostegui)
x1	Migrate a x1 DB host to mariadb 10.6 (T309679) (marostegui)

codfw

Section	Work
es2	es2031 crashed (es2) (T309977) (marostegui) es2031 crashed (es2) (T309977) (volans)