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)"

Today (2024-07-27)

eqiad

Section	Work
s1	Gradually drop old pagelinks columns (T352010) (ladsgroup)

Yesterday (2024-07-26)

eqiad

Section	Work
s1	Gradually drop old pagelinks columns (T352010) (ladsgroup)
s4	Cleanup revision table schema (T367856) (marostegui)

codfw

Section	Work
s1	Cleanup revision table schema (T367856) (marostegui)

Last seven days

eqiad

Section	Work
s1	Gradually drop old pagelinks columns (T352010) (ladsgroup)
s4	Cleanup revision table schema (T367856) (marostegui)
x1	db1179 crashed - hardware issues (T369855) (ladsgroup) Exception caught inside exception handler: Wikimedia\Rdbms\DBUnexpectedError: Database servers in extension1 are overloaded. (T370304) (ladsgroup)

codfw

Section	Work
s1	Cleanup revision table schema (T367856) (marostegui)
s4	Cleanup revision table schema (T367856) (marostegui)