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)
 
(168 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{/Header}}
{{/Header}}
== Today (2022-06-20) ==
== Today (2022-12-07) ==
== Yesterday (2022-06-19) ==
== Yesterday (2022-12-06) ==
== Last seven days ==
{| class="wikitable"
{| class="wikitable"
|+ eqiad
|+ eqiad
Line 8: Line 7:
! Section !! Work
! Section !! Work
|-
|-
| es1 || [[phab:T310485|Login (T310485)]] (marostegui)
| s5 || [[phab:T322618|Fix renamed indexes of flaggedrevs_tracking table in production (T322618)]] (ladsgroup)
|-
| s6 || [[phab:T323907|Make fr_user unsigned (T323907)]] (ladsgroup)
|-
|}
{| class="wikitable"
|+ codfw
|-
! Section !! Work
|-
| s5 || [[phab:T322618|Fix renamed indexes of flaggedrevs_tracking table in production (T322618)]] (ladsgroup)
|-
|-
| es2 || [[phab:T310485|Login (T310485)]] (marostegui)
| s6 || [[phab:T323907|Make fr_user unsigned (T323907)]] (ladsgroup)
|-
|-
| es3 || [[phab:T310485|Login (T310485)]] (marostegui)
|}
== Last seven days ==
{| class="wikitable"
|+ eqiad
|-
! Section !! Work
|-
|-
| s1 ||  
| s1 ||  
* [[phab:T298560|Fix mismatching field type of revision.rev_timestamp on wmf wikis (T298560)]] (ladsgroup)
* [[phab:T322618|Fix renamed indexes of flaggedrevs_tracking table in production (T322618)]] (ladsgroup)
* [[phab:T310011|Adjust the field type of cu_changes.cuc_timestamp to fixed binary and remove default on wmf wikis (T310011)]] (marostegui)
* [[phab:T323547|Switchover s1 master (db1163 -> db1118) (T323547)]] (ladsgroup)
|-
| s2 || [[phab:T323827|Finish timestamp schema changes in flaggedrevs (T323827)]] (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:T318605|Deploy new externallinks fields to production (T318605)]] (ladsgroup)
|-
|-
| s4 || [[phab:T310011|Adjust the field type of cu_changes.cuc_timestamp to fixed binary and remove default on wmf wikis (T310011)]] (marostegui)
| s5 ||  
* [[phab:T322618|Fix renamed indexes of flaggedrevs_tracking table in production (T322618)]] (ladsgroup)
* [[phab:T323907|Make fr_user unsigned (T323907)]] (ladsgroup)
|-
|-
| s6 ||  
| s6 ||  
* [[phab:T298560|Fix mismatching field type of revision.rev_timestamp on wmf wikis (T298560)]] (marostegui)
* [[phab:T318605|Deploy new externallinks fields to production (T318605)]] (ladsgroup)
* [[phab:T298563|Fix mismatching field type of column text.old_flags on wmf wikis (T298563)]] (marostegui)
* [[phab:T323907|Make fr_user unsigned (T323907)]] (ladsgroup)
* [[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:T302659|Adjust the field type of localuser.lu_attached_timestamp to fixed binary on wmf wikis (T302659)]] (marostegui)
| s7 || [[phab:T323907|Make fr_user unsigned (T323907)]] (ladsgroup)
|-
|-
|}
|}
Line 38: Line 52:
! Section !! Work
! Section !! Work
|-
|-
| es1 || [[phab:T310485|Login (T310485)]] (marostegui)
| s1 || [[phab:T322618|Fix renamed indexes of flaggedrevs_tracking table in production (T322618)]] (ladsgroup)
|-
|-
| es2 || [[phab:T310485|Login (T310485)]] (marostegui)
| s3 ||  
* [[phab:T312984|Adjust the field type of flaggedpages.fp_pending_since to fixed binary on wmf wikis (T312984)]] (ladsgroup)
* [[phab:T324180|Switchover s3 master (db2127 -> db2105) (T324180)]] (ladsgroup)
|-
|-
| es3 || [[phab:T310485|Login (T310485)]] (marostegui)
| s5 ||  
* [[phab:T322618|Fix renamed indexes of flaggedrevs_tracking table in production (T322618)]] (ladsgroup)
* [[phab:T323907|Make fr_user unsigned (T323907)]] (ladsgroup)
|-
|-
| es4 || [[phab:T310485|Login (T310485)]] (marostegui)
| s6 ||  
|-
* [[phab:T318605|Deploy new externallinks fields to production (T318605)]] (ladsgroup)
| es5 || [[phab:T310485|Login (T310485)]] (marostegui)
* [[phab:T323907|Make fr_user unsigned (T323907)]] (ladsgroup)
|-
|-
|}
|}
[[Category:MariaDB]]

Latest revision as of 00:01, 7 December 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-12-07)

Yesterday (2022-12-06)

eqiad
Section Work
s5 Fix renamed indexes of flaggedrevs_tracking table in production (T322618) (ladsgroup)
s6 Make fr_user unsigned (T323907) (ladsgroup)
codfw
Section Work
s5 Fix renamed indexes of flaggedrevs_tracking table in production (T322618) (ladsgroup)
s6 Make fr_user unsigned (T323907) (ladsgroup)

Last seven days

eqiad
Section Work
s1
s2 Finish timestamp schema changes in flaggedrevs (T323827) (ladsgroup)
s4 Deploy new externallinks fields to production (T318605) (ladsgroup)
s5
s6
s7 Make fr_user unsigned (T323907) (ladsgroup)
codfw
Section Work
s1 Fix renamed indexes of flaggedrevs_tracking table in production (T322618) (ladsgroup)
s3
s5
s6