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)
 
(133 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{/Header}}
{{/Header}}
== Today (2022-05-22) ==
== Today (2022-10-03) ==
== Yesterday (2022-10-02) ==
== Last seven days ==
{| class="wikitable"
{| class="wikitable"
|+ eqiad
|+ eqiad
Line 6: Line 8:
! Section !! Work
! Section !! Work
|-
|-
| s2 || [[phab:T298560|Fix mismatching field type of revision.rev_timestamp on wmf wikis (T298560)]] (ladsgroup)
| s1 || [[phab:T314041|Drop old templatelinks columns and indexes (T314041)]] (ladsgroup)
|-
| s4 || [[phab:T298555|Fix mismatching field type of logging.log_timestamp on wmf wikis (T298555)]] (ladsgroup)
|-
|-
|}
|}
== Yesterday (2022-05-21) ==
{| class="wikitable"
{| class="wikitable"
|+ eqiad
|+ codfw
|-
|-
! Section !! Work
! Section !! Work
|-
|-
| s1 || [[phab:T306560|Fix nullability of img_major_mime and oi_major_mime (T306560)]] (ladsgroup)
| s1 || [[phab:T314041|Drop old templatelinks columns and indexes (T314041)]] (ladsgroup)
|-
| s2 || [[phab:T298560|Fix mismatching field type of revision.rev_timestamp on wmf wikis (T298560)]] (ladsgroup)
|-
| s4 || [[phab:T298555|Fix mismatching field type of logging.log_timestamp on wmf wikis (T298555)]] (ladsgroup)
|-
| s7 || [[phab:T298555|Fix mismatching field type of logging.log_timestamp on wmf wikis (T298555)]] (ladsgroup)
|-
| s8 || [[phab:T303603|Add actor and comment columns to cu_changes (T303603)]] (ladsgroup)
|-
|}
== Last seven days ==
{| class="wikitable"
|+ eqiad
|-
! Section !! Work
|-
| s1 ||
* [[phab:T298554|Fix mismatching field type of archive.ar_timestamp on wmf wikis (T298554)]] (marostegui)
* [[phab:T298555|Fix mismatching field type of logging.log_timestamp on wmf wikis (T298555)]] (ladsgroup)
* [[phab:T298557|Fix mismatching field type of page.page_touched on wmf wikis (T298557)]] (marostegui)
* [[phab:T298560|Fix mismatching field type of revision.rev_timestamp on wmf wikis (T298560)]] (ladsgroup)
* [[phab:T298565|Fix mismatching field type of user table for columns user_email_authenticated, user_email_token, user_email_token_expires, user_newpass_time, user_registration, user_token, user_touched on wmf wikis (T298565)]] (ladsgroup)
* [[phab:T300381|Make page_props.pp_page unsigned on wmf wikis (T300381)]] (marostegui)
* [[phab:T300775|Add tl_target_id column to templatelinks (T300775)]] (marostegui)
* [[phab:T301312|Switchover s1 master (db1118 -> db1163) (T301312)]] (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)
|-
| s2 ||
* [[phab:T298560|Fix mismatching field type of revision.rev_timestamp on wmf wikis (T298560)]] (ladsgroup)
* [[phab:T300774|Drop fr_img_* columns (T300774)]] (ladsgroup)
|-
| s3 ||
* [[phab:T300774|Drop fr_img_* columns (T300774)]] (ladsgroup)
* [[phab:T303603|Add actor and comment columns to cu_changes (T303603)]] (ladsgroup)
|-
| s4 ||
* [[phab:T298555|Fix mismatching field type of logging.log_timestamp on wmf wikis (T298555)]] (ladsgroup)
* [[phab:T303603|Add actor and comment columns to cu_changes (T303603)]] (ladsgroup)
|-
| s5 ||
* [[phab:T298555|Fix mismatching field type of logging.log_timestamp on wmf wikis (T298555)]] (ladsgroup)
* [[phab:T298557|Fix mismatching field type of page.page_touched on wmf wikis (T298557)]] (marostegui)
* [[phab:T300774|Drop fr_img_* columns (T300774)]] (ladsgroup)
* [[phab:T303603|Add actor and comment columns to cu_changes (T303603)]] (ladsgroup)
|-
|-
| s6 ||  
| s4 || [[phab:T318886|Switchover s4 codfw master (db2110 -> db2140) (T318886)]] (marostegui)
* [[phab:T298555|Fix mismatching field type of logging.log_timestamp on wmf wikis (T298555)]] (ladsgroup)
* [[phab:T298557|Fix mismatching field type of page.page_touched on wmf wikis (T298557)]] (marostegui)
* [[phab:T303603|Add actor and comment columns to cu_changes (T303603)]] (ladsgroup)
|-
|-
| s7 ||  
| s7 || [[phab:T318888|Switchover s7 codfw master (db2110 -> db2118) (T318888)]] (marostegui)
* [[phab:T298555|Fix mismatching field type of logging.log_timestamp on wmf wikis (T298555)]] (ladsgroup)
* [[phab:T300774|Drop fr_img_* columns (T300774)]] (ladsgroup)
* [[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)
| s8 || [[phab:T318892|Switchover s8 codfw master (db2161 -> db2165) (T318892)]] (marostegui)
|-
|-
|}
|}
[[Category:MariaDB]]

Latest revision as of 00:00, 3 October 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-10-03)

Yesterday (2022-10-02)

Last seven days

eqiad
Section Work
s1 Drop old templatelinks columns and indexes (T314041) (ladsgroup)
codfw
Section Work
s1 Drop old templatelinks columns and indexes (T314041) (ladsgroup)
s4 Switchover s4 codfw master (db2110 -> db2140) (T318886) (marostegui)
s7 Switchover s7 codfw master (db2110 -> db2118) (T318888) (marostegui)
s8 Switchover s8 codfw master (db2161 -> db2165) (T318892) (marostegui)