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 (2022-11-30)

eqiad

Section	Work
s2	Make fr_user unsigned (T323907) (ladsgroup)

codfw

Section	Work
s1	Add column 'cul_actor' and index cul_actor_time to cu_log on wmf wikis (T321126) (marostegui)

Yesterday (2022-11-29)

eqiad

Section	Work
s1	Add column 'cul_actor' and index cul_actor_time to cu_log on wmf wikis (T321126) (marostegui)
s2	Make fr_user unsigned (T323907) (ladsgroup)
s3	Fix renamed indexes of flaggedrevs_tracking table in production (T322618) (ladsgroup) Switchover s3 master (db1123 -> db1157) (T323546) (ladsgroup)
s7	Make fr_user unsigned (T323907) (ladsgroup)

codfw

Section	Work
s1	Add column 'cul_actor' and index cul_actor_time to cu_log on wmf wikis (T321126) (marostegui)
s3	Fix renamed indexes of flaggedrevs_tracking table in production (T322618) (ladsgroup) Make fr_user unsigned (T323907) (ladsgroup)
s4	Add column 'cul_actor' and index cul_actor_time to cu_log on wmf wikis (T321126) (marostegui)
s7	Make fr_user unsigned (T323907) (ladsgroup)

Last seven days

eqiad

Section	Work
s1	Add column 'cul_actor' and index cul_actor_time to cu_log on wmf wikis (T321126) (marostegui)
s2	Finish timestamp schema changes in flaggedrevs (T323827) (ladsgroup) Make fr_user unsigned (T323907) (ladsgroup)
s3	Add column 'cul_actor' and index cul_actor_time to cu_log on wmf wikis (T321126) (marostegui) Fix renamed indexes of flaggedrevs_tracking table in production (T322618) (ladsgroup) Switchover s3 master (db1123 -> db1157) (T323546) (ladsgroup) Finish timestamp schema changes in flaggedrevs (T323827) (ladsgroup) Make fr_user unsigned (T323907) (ladsgroup)
s4	Add column 'cul_actor' and index cul_actor_time to cu_log on wmf wikis (T321126) (marostegui)
s6	Fix unsigned drifts in flaggedrevs caused by 4c0b3c7b9b0 (T323214) (ladsgroup)
s7	Fix renamed indexes of flaggedrevs_tracking table in production (T322618) (ladsgroup) Switchover s7 master (db1181 -> db1136) (T323117) (ladsgroup) Finish timestamp schema changes in flaggedrevs (T323827) (ladsgroup) Make fr_user unsigned (T323907) (ladsgroup)
s8	Add column 'cul_actor' and index cul_actor_time to cu_log on wmf wikis (T321126) (marostegui)

codfw

Section	Work
s1	Add column 'cul_actor' and index cul_actor_time to cu_log on wmf wikis (T321126) (marostegui)
s2	Finish timestamp schema changes in flaggedrevs (T323827) (ladsgroup)
s3	Add column 'cul_actor' and index cul_actor_time to cu_log on wmf wikis (T321126) (marostegui) Fix renamed indexes of flaggedrevs_tracking table in production (T322618) (ladsgroup) Finish timestamp schema changes in flaggedrevs (T323827) (ladsgroup) Make fr_user unsigned (T323907) (ladsgroup)
s4	Add column 'cul_actor' and index cul_actor_time to cu_log on wmf wikis (T321126) (marostegui)
s6	Fix unsigned drifts in flaggedrevs caused by 4c0b3c7b9b0 (T323214) (ladsgroup)
s7	Add column 'cul_actor' and index cul_actor_time to cu_log on wmf wikis (T321126) (marostegui) Make fr_user unsigned (T323907) (ladsgroup)
s8	Add column 'cul_actor' and index cul_actor_time to cu_log on wmf wikis (T321126) (marostegui)