You are browsing a read-only backup copy of Wikitech. The primary 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-08-11) ==
== Today (2022-08-12) ==
== Yesterday (2022-08-10) ==
{| class="wikitable"
{| class="wikitable"
|+ eqiad
|+ eqiad
Line 10: Line 9:
|-
|-
|}
|}
== Last seven days ==
== Yesterday (2022-08-11) ==
{| class="wikitable"
{| class="wikitable"
|+ eqiad
|+ eqiad
Line 16: Line 15:
! Section !! Work
! Section !! Work
|-
|-
| s4 || [[phab:T312863|Schema change to change primary key of templatelinks (T312863)]] (ladsgroup)
| s2 ||  
|-
* [[phab:T298555|Fix mismatching field type of logging.log_timestamp on wmf wikis (T298555)]] (ladsgroup)
| s5 ||  
* [[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:T309311|Make user_editcount unsigned in production (T309311)]] (ladsgroup)
* [[phab:T310011|Adjust the field type of cu_changes.cuc_timestamp to fixed binary and remove default on wmf wikis (T310011)]] (ladsgroup)
* [[phab:T310011|Adjust the field type of cu_changes.cuc_timestamp to fixed binary and remove default on wmf wikis (T310011)]] (ladsgroup)
* [[phab:T310485|Login (T310485)]] (ladsgroup)
* [[phab:T310485|Login (T310485)]] (ladsgroup)
* [[phab:T312863|Schema change to change primary key of templatelinks (T312863)]] (ladsgroup)
* [[phab:T312863|Schema change to change primary key of templatelinks (T312863)]] (ladsgroup)
* [[phab:T312984|Adjust the field type of flaggedpages.fp_pending_since to fixed binary on wmf wikis (T312984)]] (ladsgroup)
* [[phab:T314368|Switchover s2 master (db1162 -> db1122) (T314368)]] (ladsgroup)
* [[phab:T314370|Switchover s5 master (db1130 -> db1100) (T314370)]] (ladsgroup)
* [[phab:T60674|Drop page.page_restrictions column from Wikimedia wikis (T60674)]] (ladsgroup)
|-
| s4 || [[phab:T312863|Schema change to change primary key of templatelinks (T312863)]] (ladsgroup)
|-
|-
|}
|}
== Last seven days ==
{| class="wikitable"
{| class="wikitable"
|+ codfw
|+ eqiad
|-
|-
! Section !! Work
! Section !! Work
|-
| s2 ||
* [[phab:T298555|Fix mismatching field type of logging.log_timestamp on wmf wikis (T298555)]] (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:T309311|Make user_editcount unsigned in production (T309311)]] (ladsgroup)
* [[phab:T310011|Adjust the field type of cu_changes.cuc_timestamp to fixed binary and remove default on wmf wikis (T310011)]] (ladsgroup)
* [[phab:T310485|Login (T310485)]] (ladsgroup)
* [[phab:T312863|Schema change to change primary key of templatelinks (T312863)]] (ladsgroup)
* [[phab:T314368|Switchover s2 master (db1162 -> db1122) (T314368)]] (ladsgroup)
* [[phab:T60674|Drop page.page_restrictions column from Wikimedia wikis (T60674)]] (ladsgroup)
|-
|-
| s4 || [[phab:T312863|Schema change to change primary key of templatelinks (T312863)]] (ladsgroup)
| s4 || [[phab:T312863|Schema change to change primary key of templatelinks (T312863)]] (ladsgroup)
|-
|-
| s7 || [[phab:T310146|(Need By:TBD) rack/setup/install row D new PDUs (T310146)]] (ladsgroup)
| s5 ||  
* [[phab:T310011|Adjust the field type of cu_changes.cuc_timestamp to fixed binary and remove default on wmf wikis (T310011)]] (ladsgroup)
* [[phab:T310485|Login (T310485)]] (ladsgroup)
* [[phab:T312863|Schema change to change primary key of templatelinks (T312863)]] (ladsgroup)
* [[phab:T312984|Adjust the field type of flaggedpages.fp_pending_since to fixed binary on wmf wikis (T312984)]] (ladsgroup)
* [[phab:T314370|Switchover s5 master (db1130 -> db1100) (T314370)]] (ladsgroup)
|-
|-
|}
|}

Revision as of 00:19, 12 August 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-08-12)

eqiad
Section Work
s4 Schema change to change primary key of templatelinks (T312863) (ladsgroup)

Yesterday (2022-08-11)

eqiad
Section Work
s2
s4 Schema change to change primary key of templatelinks (T312863) (ladsgroup)

Last seven days

eqiad
Section Work
s2
s4 Schema change to change primary key of templatelinks (T312863) (ladsgroup)
s5