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-06) ==
== Today (2022-05-18) ==
== Yesterday (2022-05-05) ==
== Yesterday (2022-05-17) ==
{| class="wikitable"
{| class="wikitable"
|+ eqiad
|+ eqiad
Line 7: Line 7:
! Section !! Work
! Section !! Work
|-
|-
| s3 || [[phab:T307525|Fix mismatching field type of user table for columns user_newpassword, user_password, user_email on wmf wikis (T307525)]] (ladsgroup)
| s1 || [[phab:T298555|Fix mismatching field type of logging.log_timestamp on wmf wikis (T298555)]] (ladsgroup)
|-
|-
| s6 || [[phab:T307525|Fix mismatching field type of user table for columns user_newpassword, user_password, user_email on wmf wikis (T307525)]] (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)
|-
|-
| s7 || [[phab:T307525|Fix mismatching field type of user table for columns user_newpassword, user_password, user_email on wmf wikis (T307525)]] (ladsgroup)
| s3 || [[phab:T300774|Drop fr_img_* columns (T300774)]] (ladsgroup)
|-
| s5 ||
* [[phab:T300774|Drop fr_img_* columns (T300774)]] (ladsgroup)
* [[phab:T303603|Add actor and comment columns to cu_changes (T303603)]] (ladsgroup)
|-
| s7 || [[phab:T300774|Drop fr_img_* columns (T300774)]] (ladsgroup)
|-
|-
|}
|}
Line 20: Line 28:
! Section !! Work
! Section !! Work
|-
|-
| s1 ||  
| s1 || [[phab:T298555|Fix mismatching field type of logging.log_timestamp on wmf wikis (T298555)]] (ladsgroup)
* [[phab:T301879|Test MariaDB 10.6 on Bullseye (T301879)]] (marostegui)
|-
* [[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 ||  
| s3 ||  
* [[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, user_newpassword, user_password, user_email on wmf wikis (T298565)]] (ladsgroup)
* [[phab:T300774|Drop fr_img_* columns (T300774)]] (ladsgroup)
* [[phab:T306560|Fix nullability of img_major_mime and oi_major_mime (T306560)]] (ladsgroup)
* [[phab:T308206|Slow query on echo_event table (T308206)]] (marostegui)
* [[phab:T307525|Fix mismatching field type of user table for columns user_newpassword, user_password, user_email on wmf wikis (T307525)]] (ladsgroup)
|-
|-
| s5 ||  
| s5 ||  
* [[phab:T298295|Fix length of columns page_restrictions.pr_level/pr_type on wmf wikis (T298295)]] (ladsgroup)
* [[phab:T300774|Drop fr_img_* columns (T300774)]] (ladsgroup)
* [[phab:T306560|Fix nullability of img_major_mime and oi_major_mime (T306560)]] (ladsgroup)
* [[phab:T303603|Add actor and comment columns to cu_changes (T303603)]] (ladsgroup)
* [[phab:T307525|Fix mismatching field type of user table for columns user_newpassword, user_password, user_email on wmf wikis (T307525)]] (ladsgroup)
|-
|-
| s6 ||  
| s6 || [[phab:T308206|Slow query on echo_event table (T308206)]] (marostegui)
* [[phab:T298563|Fix mismatching field type of column text.old_flags on wmf wikis (T298563)]] (ladsgroup)
* [[phab:T306560|Fix nullability of img_major_mime and oi_major_mime (T306560)]] (ladsgroup)
* [[phab:T307525|Fix mismatching field type of user table for columns user_newpassword, user_password, user_email on wmf wikis (T307525)]] (ladsgroup)
|-
|-
| s7 ||  
| s7 ||  
* [[phab:T306560|Fix nullability of img_major_mime and oi_major_mime (T306560)]] (ladsgroup)
* [[phab:T300774|Drop fr_img_* columns (T300774)]] (ladsgroup)
* [[phab:T307525|Fix mismatching field type of user table for columns user_newpassword, user_password, user_email on wmf wikis (T307525)]] (ladsgroup)
* [[phab:T308126|Migrate a s7 DB host to mariadb 10.6 (T308126)]] (marostegui)
|-
|-
|}
|}
Line 49: Line 54:
! Section !! Work
! Section !! Work
|-
|-
| s2 || [[phab:T303603|Add actor and comment columns to cu_changes (T303603)]] (kormat)
| s3 || [[phab:T308206|Slow query on echo_event table (T308206)]] (marostegui)
|-
| s4 || [[phab:T308202|db2140 broken storage (T308202)]] (marostegui)
|-
| s6 || [[phab:T308206|Slow query on echo_event table (T308206)]] (marostegui)
|-
| s7 ||
* [[phab:T307501|Adjust the field type of globalblocks timestamp columns to fixed binary on wmf wikis (T307501)]] (marostegui)
* [[phab:T308206|Slow query on echo_event table (T308206)]] (marostegui)
|-
|-
|}
|}

Revision as of 00:01, 18 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-18)

Yesterday (2022-05-17)

eqiad
Section Work
s1 Fix mismatching field type of logging.log_timestamp on wmf wikis (T298555) (ladsgroup)
s2
s3 Drop fr_img_* columns (T300774) (ladsgroup)
s5
s7 Drop fr_img_* columns (T300774) (ladsgroup)

Last seven days

eqiad
Section Work
s1 Fix mismatching field type of logging.log_timestamp on wmf wikis (T298555) (ladsgroup)
s2
s3
s5
s6 Slow query on echo_event table (T308206) (marostegui)
s7
codfw
Section Work
s3 Slow query on echo_event table (T308206) (marostegui)
s4 db2140 broken storage (T308202) (marostegui)
s6 Slow query on echo_event table (T308206) (marostegui)
s7