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-05-23)

eqiad

Section	Work
s1	Upgrade s1 to MariaDB 10.6 (T364290) (arnaudb)
s4	Drop cl_collation_ext index from categorylinks in production (T356166) (marostegui) Switchover s4 master (db1238 -> db1160) (T363689) (arnaudb)
s8	Make rc_id a bigint (T364299) (marostegui)

codfw

Section	Work
s1	Upgrade s1 to MariaDB 10.6 (T364290) (arnaudb)
s6	Make rc_id a bigint (T364299) (marostegui)

Yesterday (2024-05-22)

eqiad

Section	Work
s1	Upgrade s1 to MariaDB 10.6 (T364290) (arnaudb)
s2	Fully format and reclone db1246 (T364552) (kormat)
s8	Make rc_id a bigint (T364299) (marostegui)

codfw

Section	Work
s1	Upgrade s1 to MariaDB 10.6 (T364290) (arnaudb)
s5	Gradually drop old pagelinks columns (T352010) (ladsgroup)
s7	Gradually drop old pagelinks columns (T352010) (ladsgroup)

Last seven days

eqiad

Section	Work
s1	Upgrade s1 to MariaDB 10.6 (T364290) (arnaudb)
s2	Upgrade s2 to MariaDB 10.6 (T361543) (marostegui) Fully format and reclone db1246 (T364552) (kormat)
s3	translate_reviews unsigned and revision big int (T365465) (marostegui)
s4	Drop cl_collation_ext index from categorylinks in production (T356166) (marostegui) Switchover s4 master (db1238 -> db1160) (T363689) (arnaudb) Stop referencing rev_id as signed int in revtag table to counter revision id overflow in wikidatawiki (T365352) (marostegui) translate_reviews unsigned and revision big int (T365465) (marostegui)
s5	Gradually drop old pagelinks columns (T352010) (ladsgroup) Stop referencing rev_id as signed int in revtag table to counter revision id overflow in wikidatawiki (T365352) (marostegui) translate_reviews unsigned and revision big int (T365465) (marostegui)
s6	Gradually drop old pagelinks columns (T352010) (ladsgroup)
s7	Stop referencing rev_id as signed int in revtag table to counter revision id overflow in wikidatawiki (T365352) (marostegui) translate_reviews unsigned and revision big int (T365465) (marostegui)
s8	Make rc_id a bigint (T364299) (marostegui) Stop referencing rev_id as signed int in revtag table to counter revision id overflow in wikidatawiki (T365352) (marostegui) translate_reviews unsigned and revision big int (T365465) (marostegui)
x1	Upgrade x1 to MariaDB 10.6 (T358642) (marostegui)

codfw

Section	Work
s1	Upgrade s1 to MariaDB 10.6 (T364290) (arnaudb)
s2	Upgrade s2 to MariaDB 10.6 (T361543) (marostegui)
s5	Gradually drop old pagelinks columns (T352010) (ladsgroup)
s6	Gradually drop old pagelinks columns (T352010) (ladsgroup) Make rc_id a bigint (T364299) (marostegui)
s7	Gradually drop old pagelinks columns (T352010) (ladsgroup) Stop referencing rev_id as signed int in revtag table to counter revision id overflow in wikidatawiki (T365352) (marostegui)
s8	Upgrade s8 to MariaDB 10.6 (T363792) (marostegui) Make rc_id a bigint (T364299) (marostegui) Switchover s8 master (db2161 -> db2165) (T365339) (marostegui)