You are browsing a read-only backup copy of Wikitech. The live site can be found at wikitech.wikimedia.org
Map of database maintenance: Difference between revisions
Jump to navigation
Jump to search
imported>Dexbot m (Bot: Updating the report) |
imported>Dexbot m (Bot: Updating the report) |
||
| Line 1: | Line 1: | ||
{{/Header}} | {{/Header}} | ||
== Today (2022-06-14) == | == Today (2022-06-15) == | ||
== Yesterday (2022-06-14) == | |||
{| class="wikitable" | {| class="wikitable" | ||
|+ eqiad | |+ eqiad | ||
| Line 6: | Line 7: | ||
! Section !! Work | ! Section !! Work | ||
|- | |- | ||
| | | s1 || [[phab:T298560|Fix mismatching field type of revision.rev_timestamp on wmf wikis (T298560)]] (ladsgroup) | ||
|- | |- | ||
| s3 || [[phab:T310011|Adjust the field type of cu_changes.cuc_timestamp to fixed binary and remove default on wmf wikis (T310011)]] (marostegui) | |||
| | |||
|- | |- | ||
| s4 || [[phab:T310011|Adjust the field type of cu_changes.cuc_timestamp to fixed binary and remove default on wmf wikis (T310011)]] (marostegui) | | s4 || [[phab:T310011|Adjust the field type of cu_changes.cuc_timestamp to fixed binary and remove default on wmf wikis (T310011)]] (marostegui) | ||
|- | |- | ||
| | | s6 || | ||
| | * [[phab:T298560|Fix mismatching field type of revision.rev_timestamp on wmf wikis (T298560)]] (marostegui) | ||
| | * [[phab:T298563|Fix mismatching field type of column text.old_flags on wmf wikis (T298563)]] (marostegui) | ||
* [[phab:T300381|Make page_props.pp_page unsigned on wmf wikis (T300381)]] (marostegui) | |||
* [[phab:T300471|Switchover s6 master (db1173 -> db1131) (T300471)]] (marostegui) | |||
* [[phab:T309311|Make user_editcount unsigned in production (T309311)]] (marostegui) | |||
* [[phab:T60674|Drop page.page_restrictions column from Wikimedia wikis (T60674)]] (marostegui) | |||
|- | |- | ||
|} | |} | ||
| Line 32: | Line 30: | ||
| s1 || [[phab:T298560|Fix mismatching field type of revision.rev_timestamp on wmf wikis (T298560)]] (ladsgroup) | | s1 || [[phab:T298560|Fix mismatching field type of revision.rev_timestamp on wmf wikis (T298560)]] (ladsgroup) | ||
|- | |- | ||
| | | s3 || [[phab:T310011|Adjust the field type of cu_changes.cuc_timestamp to fixed binary and remove default on wmf wikis (T310011)]] (marostegui) | ||
|- | |- | ||
| s4 || | | s4 || | ||
| Line 38: | Line 36: | ||
* [[phab:T310114|Migrate a s4 DB host to mariadb 10.6 (T310114)]] (marostegui) | * [[phab:T310114|Migrate a s4 DB host to mariadb 10.6 (T310114)]] (marostegui) | ||
|- | |- | ||
| | | s6 || | ||
* [[phab:T298560|Fix mismatching field type of revision.rev_timestamp on wmf wikis (T298560)]] (marostegui) | |||
* [[phab:T298563|Fix mismatching field type of column text.old_flags on wmf wikis (T298563)]] (marostegui) | |||
* [[phab:T300381|Make page_props.pp_page unsigned on wmf wikis (T300381)]] (marostegui) | |||
* [[phab:T300471|Switchover s6 master (db1173 -> db1131) (T300471)]] (marostegui) | |||
* [[phab:T309311|Make user_editcount unsigned in production (T309311)]] (marostegui) | |||
* [[phab:T60674|Drop page.page_restrictions column from Wikimedia wikis (T60674)]] (marostegui) | |||
|- | |- | ||
| s7 || [[phab:T310011|Adjust the field type of cu_changes.cuc_timestamp to fixed binary and remove default on wmf wikis (T310011)]] (marostegui) | | s7 || [[phab:T310011|Adjust the field type of cu_changes.cuc_timestamp to fixed binary and remove default on wmf wikis (T310011)]] (marostegui) | ||
Revision as of 00:02, 15 June 2022
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)"