Phabricator Link
|
Wiki Link
|
Status
|
Priority
|
Author
|
Assignee
|
Projects
|
Subtasks
|
Parent Tasks
|
T107610
|
T107610: Setup separate logical External Store for Flow in production
|
declined
|
High (red)
|
|
|
|
|
|
T111266
|
T111266: Make LoadBalancer slave lag check and read-only mode more robust (for example, using pt-heartbeat)
|
resolved
|
High (red)
|
|
|
|
|
|
T111654
|
T111654: Set up TLS for MariaDB replication
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T116557
|
T116557: AFComputedVariable::compute query timeouts
|
resolved
|
High (red)
|
|
|
|
|
|
T119567
|
T119567: Run Flow External Store migration in dry-run mode on Beta
|
resolved
|
High (red)
|
|
|
|
|
|
T119642
|
T119642: Create a Master-master topology between datacenters for easier failover (setup circular replication dallas -> eqiad for mysql databases)
|
resolved
|
High (red)
|
|
|
|
|
|
T119648
|
T119648: Fix getLagFromPtHeartbeat() to use the pt entry for the root master, not the immediate one
|
resolved
|
Low (yellow)
|
|
|
|
|
|
T120122
|
T120122: Perform a rolling restart of all MySQL slaves (masters too for those services with low traffic)
|
resolved
|
High (red)
|
|
|
|
|
|
T120242
|
T120242: Consistent MediaWiki state change events | MediaWiki events as source of truth
|
open
|
Medium (orange)
|
|
|
|
|
|
T124795
|
T124795: codfw is in read only according to mediawiki
|
resolved
|
High (red)
|
|
|
|
|
|
T129093
|
T129093: SHOW SLAVE STATUS as a health check should have a low timeout
|
open
|
Low (yellow)
|
|
|
|
|
|
T133385
|
T133385: Implement GTID replication on MariaDB 10 servers
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T133523
|
T133523: Decide how to improve parsercache replication, sharding and HA
|
open
|
Medium (orange)
|
|
|
|
|
|
T134809
|
T134809: Apache <=> mariadb SSL/TLS for cross-datacenter writes
|
stalled
|
Medium (orange)
|
|
|
|
|
|
T135027
|
T135027: MASTER_POS_WAIT() alternative that works cross-DC
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T138778
|
T138778: Upgrade mariadb in deployment-prep from Precise/MariaDB 5.5 to Jessie/MariaDB 5.10
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T149077
|
T149077: Certain ApiQueryRecentChanges::run api query is too slow, slowing down dewiki
|
declined
|
Medium (orange)
|
|
|
|
|
|
T151995
|
T151995: Rolling restart of external storage servers for TLS certificate update
|
resolved
|
High (red)
|
|
|
|
|
|
T152029
|
T152029: Rolling restart of parsercache servers for TLS certificate update
|
resolved
|
High (red)
|
|
|
|
|
|
T152188
|
T152188: Restart pending mysql hosts with old TLS cert
|
resolved
|
Low (yellow)
|
|
|
|
|
|
T152364
|
T152364: db1047 out of disk space, eventlogging_sync spam
|
resolved
|
Needs Triage (violet)
|
|
|
|
|
|
T152427
|
T152427: Create a check/calendar alert for MariaDB TLS certs
|
open
|
Medium (orange)
|
|
|
|
|
|
T152595
|
T152595: Implement TLS expiration/validation checking for MariaDB certificates
|
duplicate
|
Needs Triage (violet)
|
|
|
|
|
|
T153440
|
T153440: Create a full backup of all external storage records that would be easy to restore/setup a temporary delayed slave
|
resolved
|
High (red)
|
|
|
|
|
|
T156005
|
T156005: Reimage db1065 and db1066
|
resolved
|
High (red)
|
|
|
|
|
|
T157702
|
T157702: Followup for TLS MariaDB server roll-out
|
open
|
Medium (orange)
|
|
|
|
|
|
T160984
|
T160984: Reduce max execution time of interactive queries or a better detection and killing of bad query patterns
|
resolved
|
High (red)
|
|
|
|
|
|
T162138
|
T162138: How many revision comments are exactly the same? Get some stats.
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T163351
|
T163351: codfw API slaves overloaded during the 2017-04-19 codfw switch
|
resolved
|
High (red)
|
|
|
|
|
|
T163413
|
T163413: Pool new server db2071
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T164382
|
T164382: Evaluate the need for FORCE INDEX (ls_field_val) [now IGNORE INDEX (ls_log_id)], delete the index hint if not needed anymore
|
open
|
Low (yellow)
|
|
|
|
|
|
T166184
|
T166184: Run updateRestrictions.php on WMF wikis
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T166798
|
T166798: Decide whether back-compat views for upcoming major schema changes will be provided in the Labs replicas
|
resolved
|
Low (yellow)
|
|
|
|
|
|
T171071
|
T171071: Perform testing for TLS effect on connection rate
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T172497
|
T172497: Fix mediawiki heartbeat model, change pt-heartbeat model to not use super-user, avoid SPOF and switch automatically to the real master without puppet dependency
|
open
|
Medium (orange)
|
|
|
|
|
|
T174044
|
T174044: Deploy MCR storage layer
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T174569
|
T174569: Schema change for refactored comment storage
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T175672
|
T175672: Make apache/maintenance hosts TLS connections to mariadb work
|
open
|
Medium (orange)
|
|
|
|
|
|
T177778
|
T177778: Improve database application performance monitoring visibility
|
resolved
|
Low (yellow)
|
|
|
|
|
|
T183419
|
T183419: Determine how to update old compressed ExternalStore entries for T181555
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T183469
|
T183469: Setup newer machines and replace all old misc (m*) and x1 eqiad machines
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T183470
|
T183470: Setup newer machines and replace all old misc (m*) and x1 codfw machines
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T183486
|
T183486: MCR schema migration stage 0: create tables
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T184054
|
T184054: Decommission db1029 and db1031
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T184446
|
T184446: Configure Toolforge replica views and dumps for the new MCR tables
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T184703
|
T184703: Decommission db1011
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T184704
|
T184704: Setup tendril database monitoring on 2 new hosts, one on eqiad and one on codfw
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T187089
|
T187089: Fix WMF schemas to not break when comment store goes WRITE_NEW
|
resolved
|
High (red)
|
|
|
|
|
|
T187542
|
T187542: Decommission db1043
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T187543
|
T187543: Decommission db2012
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T187722
|
T187722: Replace db2030 from m5 with another host (WAS: Degraded RAID on db2030)
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T187768
|
T187768: Decommission db2030
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T187886
|
T187886: Decommission db2011
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T188299
|
T188299: Schema change for refactored actor storage
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T189005
|
T189005: Failover m5 master from db1009 to db1073
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T189216
|
T189216: Decommission db1009
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T189655
|
T189655: Switchover m1 master from db1016 to db1063
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T189656
|
T189656: Switchover m2 master from db1020 to db1051
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T189773
|
T189773: Decommission db1020
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T190148
|
T190148: Change DEFAULT 0 for rev_text_id on production DBs
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T190153
|
T190153: DROP unused 'slots' table (WAS: In the slots table, replace slot_inherited with slot_origin)
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T190179
|
T190179: Decommission db1016
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T190262
|
T190262: Decommission db1001
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T195792
|
T195792: Add support for setting individual query timeout in wikimedia/rdbms
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T196378
|
T196378: Investigate solutions for MySQL connection pooling
|
open
|
Medium (orange)
|
|
|
|
|
|
T196547
|
T196547: [Epic] Extension:JADE scalability concerns
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T197616
|
T197616: Create a production test wiki in group0 to parallel Wikimedia Commons
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T200297
|
T200297: Review Jade data storage and architecture proposal [RFC]
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T202596
|
T202596: Write our anticipated "phase two" schemas and submit for review
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T209031
|
T209031: Not able to scoop comment table in labs for mediawiki reconstruction process [EPIC}
|
resolved
|
High (red)
|
|
|
|
|
|
T209591
|
T209591: Drop table image_comment_temp on all wikis
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T210693
|
T210693: Create materialized views on Wiki Replica hosts for better query performance
|
resolved
|
High (red)
|
|
|
|
|
|
T210725
|
T210725: Replace parsercache keys to something more meaningful on db-XXXX.php
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T211613
|
T211613: rack/setup/install db11[26-38].eqiad.wmnet
|
resolved
|
High (red)
|
|
|
|
|
|
T211804
|
T211804: A huge spike on read rows for commonswiki
|
resolved
|
High (red)
|
|
|
|
|
|
T212154
|
T212154: Recommendation API exceeds max_user_connections in MySQL
|
resolved
|
Needs Triage (violet)
|
|
|
|
|
|
T216656
|
T216656: API problem with usercontribs using `rev_user_text` rather than `rev_user`: Only use 'contributions' replica if querying by user ID
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T218692
|
T218692: read only on mediawiki generates "LoadBalancer.php: Cannot access the database: Unknown error"
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T219374
|
T219374: Prepare and check storage layer for hi.wikisource
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T219493
|
T219493: Prepare to decommission 2 codfw x1 hosts db2033 and db2034
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T220170
|
T220170: Address Database hardware infrastructure blockers on datacenter switchover & multi-dc deployment
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T221159
|
T221159: FY18/19 TEC1.6 Q4: Improve or replace the usage of GTID_WAIT with pt-heartbeat in MW
|
declined
|
High (red)
|
|
|
|
|
|
T221458
|
T221458: Special:Log on commons -- entire web request took longer than 60 seconds and timed out
|
resolved
|
Unbreak Now! (pink)
|
|
|
|
|
|
T221533
|
T221533: Decommission old coredb machines (<=db2042)
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T222224
|
T222224: RFC: Normalize MediaWiki link tables
|
open
|
Medium (orange)
|
|
|
|
|
|
T222682
|
T222682: Productionize db11[26-38]
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T223151
|
T223151: Review special replica partitioning of certain tables by `xx_user`
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T224017
|
T224017: Slow query ApiQueryRevisions on enwiki
|
resolved
|
High (red)
|
|
|
|
|
|
T224852
|
T224852: Failover s4 primary master: db1068 to db1081
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T226358
|
T226358: Failover x1 master: db1069 to db1120 3rd July at 06:00 UTC
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T226952
|
T226952: Failover m2 master db1065 to db1132
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T227062
|
T227062: Failover s8 (wikidatawiki) db primary master db1071 to db1104 (read-only required)
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T228243
|
T228243: Switchover m3 (phabricator) master db1072 to db1128
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T229657
|
T229657: Switchover m5 primary master: db1073 to db1133: Tuesday 3rd Sept at 13:00 UTC
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T230106
|
T230106: Switchover codfw primary database masters to new hosts
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T230459
|
T230459: Replace db2044 with db2063
|
declined
|
Medium (orange)
|
|
|
|
|
|
T231598
|
T231598: Compose Count Queries
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T231599
|
T231599: Compose New History Queries
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T233135
|
T233135: Schema change for refactored actor and comment storage
|
resolved
|
Medium (orange)
|
|
|
|
|
|
T233579
|
T233579: Tracking task for mariadb optimizer misbehaviours
|
declined
|
Medium (orange)
|
|
|
|
|
|