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

From Wikitech-static
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-05-27) ==
== Today (2022-05-28) ==
== Yesterday (2022-05-26) ==
{| class="wikitable"
{| class="wikitable"
|+ eqiad
|+ eqiad
Line 7: Line 6:
! Section !! Work
! Section !! Work
|-
|-
| es1 || [[phab:T309265|Migrate 4 DB ES hosts to 10.6 (T309265)]] (marostegui)
| s2 || [[phab:T309311|Make user_editcount unsigned in production (T309311)]] (ladsgroup)
|-
| s7 || [[phab:T298560|Fix mismatching field type of revision.rev_timestamp on wmf wikis (T298560)]] (ladsgroup)
|-
|}
== Yesterday (2022-05-27) ==
{| class="wikitable"
|+ eqiad
|-
! Section !! Work
|-
|-
| s1 ||  
| s2 || [[phab:T309311|Make user_editcount unsigned in production (T309311)]] (ladsgroup)
* [[phab:T298555|Fix mismatching field type of logging.log_timestamp on wmf wikis (T298555)]] (ladsgroup)
* [[phab:T309286|db1128 host (containing m1 databases) crashed (T309286)]] (marostegui)
|-
|-
| s3 || [[phab:T298560|Fix mismatching field type of revision.rev_timestamp on wmf wikis (T298560)]] (ladsgroup)
| s3 || [[phab:T298560|Fix mismatching field type of revision.rev_timestamp on wmf wikis (T298560)]] (ladsgroup)
|-
| s5 || [[phab:T60674|Drop page.page_restrictions column from Wikimedia wikis (T60674)]] (ladsgroup)
|-
| s6 || [[phab:T309311|Make user_editcount unsigned in production (T309311)]] (ladsgroup)
|-
| s7 || [[phab:T298560|Fix mismatching field type of revision.rev_timestamp on wmf wikis (T298560)]] (ladsgroup)
|-
|-
|}
|}
Line 28: Line 40:
* [[phab:T303171|Upgrade s1 to Bullseye (T303171)]] (ladsgroup)
* [[phab:T303171|Upgrade s1 to Bullseye (T303171)]] (ladsgroup)
* [[phab:T303603|Add actor and comment columns to cu_changes (T303603)]] (ladsgroup)
* [[phab:T303603|Add actor and comment columns to cu_changes (T303603)]] (ladsgroup)
* [[phab:T306560|Fix nullability of img_major_mime and oi_major_mime (T306560)]] (ladsgroup)
* [[phab:T309286|db1128 host (containing m1 databases) crashed (T309286)]] (marostegui)
* [[phab:T309286|db1128 host (containing m1 databases) crashed (T309286)]] (marostegui)
|-
|-
Line 35: Line 46:
* [[phab:T298560|Fix mismatching field type of revision.rev_timestamp on wmf wikis (T298560)]] (ladsgroup)
* [[phab:T298560|Fix mismatching field type of revision.rev_timestamp on wmf wikis (T298560)]] (ladsgroup)
* [[phab:T303603|Add actor and comment columns to cu_changes (T303603)]] (ladsgroup)
* [[phab:T303603|Add actor and comment columns to cu_changes (T303603)]] (ladsgroup)
* [[phab:T309311|Make user_editcount unsigned in production (T309311)]] (ladsgroup)
|-
|-
| s3 ||  
| s3 ||  
Line 44: Line 56:
* [[phab:T303603|Add actor and comment columns to cu_changes (T303603)]] (ladsgroup)
* [[phab:T303603|Add actor and comment columns to cu_changes (T303603)]] (ladsgroup)
|-
|-
| s5 || [[phab:T298560|Fix mismatching field type of revision.rev_timestamp on wmf wikis (T298560)]] (ladsgroup)
| s5 ||  
* [[phab:T298560|Fix mismatching field type of revision.rev_timestamp on wmf wikis (T298560)]] (ladsgroup)
* [[phab:T60674|Drop page.page_restrictions column from Wikimedia wikis (T60674)]] (ladsgroup)
|-
|-
| s6 || [[phab:T303603|Add actor and comment columns to cu_changes (T303603)]] (ladsgroup)
| s6 ||  
* [[phab:T303603|Add actor and comment columns to cu_changes (T303603)]] (ladsgroup)
* [[phab:T309311|Make user_editcount unsigned in production (T309311)]] (ladsgroup)
|-
|-
| s7 || [[phab:T298555|Fix mismatching field type of logging.log_timestamp on wmf wikis (T298555)]] (ladsgroup)
| s7 || [[phab:T298560|Fix mismatching field type of revision.rev_timestamp on wmf wikis (T298560)]] (ladsgroup)
|-
|-
| s8 || [[phab:T303603|Add actor and comment columns to cu_changes (T303603)]] (ladsgroup)
| s8 || [[phab:T303603|Add actor and comment columns to cu_changes (T303603)]] (ladsgroup)
|-
|-
|}
|}

Revision as of 00:30, 28 May 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)"

Today (2022-05-28)

eqiad
Section Work
s2 Make user_editcount unsigned in production (T309311) (ladsgroup)
s7 Fix mismatching field type of revision.rev_timestamp on wmf wikis (T298560) (ladsgroup)

Yesterday (2022-05-27)

eqiad
Section Work
s2 Make user_editcount unsigned in production (T309311) (ladsgroup)
s3 Fix mismatching field type of revision.rev_timestamp on wmf wikis (T298560) (ladsgroup)
s5 Drop page.page_restrictions column from Wikimedia wikis (T60674) (ladsgroup)
s6 Make user_editcount unsigned in production (T309311) (ladsgroup)
s7 Fix mismatching field type of revision.rev_timestamp on wmf wikis (T298560) (ladsgroup)

Last seven days

eqiad
Section Work
es1 Migrate 4 DB ES hosts to 10.6 (T309265) (marostegui)
s1
s2
s3
s4
s5
s6
s7 Fix mismatching field type of revision.rev_timestamp on wmf wikis (T298560) (ladsgroup)
s8 Add actor and comment columns to cu_changes (T303603) (ladsgroup)