| | Status | Subtype | Assigned | Task |
---|
| | Resolved | | Joe | T154658 Prepare and improve the datacenter switchover procedure |
| | Resolved | | None | T155099 Database maintenance scheduled while eqiad datacenter is non primary (after the DC switchover) |
| | Resolved | | Reedy | T157227 MediaWiki DB tables with columns which references other columns but have different type (tracking) |
| | Invalid | | None | T2384 [REPLACED BY TAG] PostgreSQL/pgsql support (tracking) |
| | Resolved | | None | T30193 Article::getContributors not DB agnostic |
| | Declined | | None | T28273 Database layer should automagically add GROUP BY columns on backends that need them (postgres) |
| | Duplicate | | None | T68111 watchlist needs a surrogate primary key |
| | Resolved | | None | T26782 API uses non-unique value for paging for some modules |
| | Stalled | | None | T108255 Enable MariaDB/MySQL's Strict Mode |
| | Resolved | | • RobLa-WMF | T112637 RFC: Increase the strictness of mediawiki SQL code and leverage database code blockers for scalability |
| | Declined | | None | T3268 Database replication lag issues (tracking) |
| | Declined | | Aklapper | T2659 The database did not find the text of a page that it should have found |
| | Resolved | | None | T2951 Watchlist fails to update |
| | Resolved | | None | T11628 Display replication lag on watchlist, contribs etc |
| | Resolved | | None | T3209 Newly created articles sometimes show up as empty |
| | Declined | | None | T3243 One article listed multiple times on Newpages, Recentchanges and Contributions |
| | Declined | | Aklapper | T3251 "Mail me a new password" does not work immediately |
| | Resolved | | None | T3266 Saving the content failes |
| | Resolved | | None | T3239 New page created, db lag, result in double entries in categories |
| | Resolved | | None | T3202 Clicking "Save page" on a new page multiple times creates the page multiple times |
| | Invalid | | None | T3286 Edits in articles omitted from history or contribs |
| | Resolved | | None | T3290 Getting not updated pages |
| | Resolved | | aaron | T19179 No user-visible lag reports when database slave server has stopped replication slave thread |
| | Stalled | Feature | None | T40945 Need a way to simulate replication lag to test replag issues |
| | Open | | None | T93047 Create vagrant role for master-slave DB setup |
| | Duplicate | | None | T59583 Make deployment prep have continuous replication lag |
| | Resolved | | None | T62058 implement master-slave DB for beta labs |
| | Declined | | jcrespo | T50628 Provide replication lag as a database function |
| | Resolved | | aaron | T95501 Fix causes of replica lag and get it to under 5 seconds at peak |
| | Resolved | | None | T109179 Migrate MySQLs to use ROW-based replication |
| | Resolved | | LSobanski | T17441 Some tables lack unique or primary keys, may allow confusing duplicate data |
| | Resolved | | None | T35638 Math table doesn't have a PK |
| | Declined | | None | T104314 Every Gather table should have a primary key |
| | Resolved | | daniel | T102992 [Task] Review WikidataQuality DB schema |
| | Resolved | | matthiasmullie | T109676 Add artificial primary key to flow_wiki_ref and flow_ext_ref |
| | Resolved | | jcrespo | T111084 Do backfill and final schema change for "Segregate Reference objects by source wiki." |
| | Duplicate | | None | T113778 Run patch-reference_wiki-phase5.sql in production |
| | Resolved | | jcrespo | T117787 Make ref_id of flow_wiki_ref and flow_ext_ref not null and PK (DBA phase 2) |
| | Resolved | | Catrope | T117786 Run maintenance/FlowPopulateRefId.php on all production wikis |
| | Resolved | | Catrope | T117785 Deploy artificial primary key reference change to all production wikis simultaneously |
| | Resolved | | jcrespo | T117783 Add ref_id to flow_wiki_ref and flow_ext_ref (DBA phase 1) |
| | Resolved | | TTO | T123225 change_tag doesn't have a primary key |
| | Resolved | | • Marostegui | T147166 Apply change_tag and tag_summary primary key schema change to Wikimedia wikis |
| | Stalled | | None | T146571 Add a primary key to querycache table |
| | Open | | None | T174513 Maintenance script to cleanup querycache |
| | Open | | None | T146585 Add a primary key to user_newtalk |
| | Open | | None | T146586 Add a primary key to querycachetwo table |
| | Resolved | | • Marostegui | T146591 Add a primary key to l10n_cache |
| | Resolved | | • Marostegui | T150306 truncate l10n_cache table on WMF wikis |
| | Resolved | | Reedy | T146570 Give user_properties a primary key |
| | Resolved | | Reedy | T172514 Add new PKs to tables.sql (mysql and sqlite) |
| | | | | Restricted Task |
| | Resolved | | • Marostegui | T149819 Add primary keys to remaining Flow tables |
| | Open | | None | T28741 Migrate file tables to a modern layout (image/oldimage; file/file_revision; add primary keys) |
| | Resolved | | Krinkle | T589 RFC: image and oldimage tables |
| | Resolved | | • Marostegui | T163912 Convert unique keys into primary keys for some wiki tables on s3-eqiad and s3-codfw |
| | Resolved | | • Marostegui | T163979 Convert unique keys into primary keys for some wiki tables on s6-eqiad and codfw |
| | Resolved | | • Marostegui | T164185 Convert unique keys into primary keys for some wiki tables on s1, s2, s4, s5 and s7 (eqiad) |
| | Resolved | | • Marostegui | T166204 Convert unique keys into primary keys for some wiki tables on s1 |
| | Resolved | | • Marostegui | T166205 Convert unique keys into primary keys for some wiki tables on s2 |
| | Resolved | | • Marostegui | T166206 Convert unique keys into primary keys for some wiki tables on s4 |
| | Resolved | | jcrespo | T166207 Convert unique keys into primary keys for some wiki tables on s5 |
| | Resolved | | • Marostegui | T166208 Convert unique keys into primary keys for some wiki tables on s7 |
| | Resolved | | • Marostegui | T164399 Convert unique keys into primary keys for some wiki tables on all s* shards (codfw) |
| | Resolved | | Reedy | T198811 Convert UNIQUE indexes to Primary Keys in MW Core Tables |
| | Resolved | | • Marostegui | T199368 Convert UNIQUE INDEX to PK in Production |
| | Resolved | Sep 9 2018 | • Marostegui | T189101 Deploy schema change for adding numeric primary key to wbqc_constraints table |
| | Resolved | | • Marostegui | T201011 Apply schema change to translate_reviews in WMF |
| | Duplicate | | None | T231946 user_newtalk table is missing a primary key |
| | Resolved | | DannyS712 | T243073 Add primary key to pagetriage_page_tags |
| | Resolved | | Umherirrender | T243985 Translate table `revtag` lacks a primary key |
| | Resolved | | DannyS712 | T243986 CloseWikis table `closedwikis` lacks a primary key |
| | Resolved | | DannyS712 | T243987 GlobalUsage table `globalimagelinks` lacks a primary key |
| | In Progress | | Diesel_kapasule | T312247 Add primary key for database table cx_suggestions |
| | Open | | None | T312263 Add primary key for database table translate_tmf |
| | Open | | None | T312281 Add primary key for database table securepoll_lists |
| | Resolved | | jcrespo | T120122 Perform a rolling restart of all MySQL slaves (masters too for those services with low traffic) |
| | Resolved | | • Cmjohnson | T120689 es1019 and its management interface are unresponsive |
| | Resolved | | jcrespo | T121207 Implement slave_run_triggers_for_rbr at sanitarium for labs filtering |
| | Resolved | | jcrespo | T122429 Batch updates create slave lag on s3 over WAN |
| | Resolved | | hoo | T125838 Implement usage tracking without eu_touched |
| | Resolved | | hoo | T124737 [RfC] Implement usage tracking without eu_touched |
| | Resolved | | Nikerabbit | T86385 Translate extension makes huge batch INSERTS |
| | Resolved | | aaron | T116425 Rename user creates lag on enwiki |
| | Resolved | | aaron | T109943 Long running query from LinksUpdate::incrTableUpdate job causing general lag |
| | Resolved | | Lydia_Pintscher | T123867 Repeated reports of wikidatawiki (s5) API going read only |
| | | | | Restricted Task |
| | Resolved | | aaron | T134613 updateNotificationTimestamp() should batch queries |
| | Resolved | | • Marostegui | T130067 Add wl_id to watchlist tables on production dbs |
| | Resolved | | jcrespo | T138810 Set databases as read-only or switchover to secondary datacenter |
| | Resolved | | Addshore | T125990 Add a wl_id field to the watchlist table |
| | Resolved | | Addshore | T160062 Allow setting the watchlist table to read-only on a per-wiki basis |
| | Declined | PRODUCTION ERROR | None | T135798 DBPerformance warning for "DELETE .. echo_email_batch" query from MWEchoEmailBatch |
| | Duplicate | | None | T141340 /* RenameUserJob::run */ of user Burgundo created >1000 seconds of lag on itwiki (db1036), impacting recentchanges, watchlist and log visualization of all s2 wikis |
| | Declined | | aaron | T142135 LoadBalancer::waitForAll ignores critical group-load-only servers like 'recentchanges' slaves |
| | Resolved | | aaron | T150124 Parsercache purging can create lag |
| | Resolved | | Krinkle | T163801 WikiPage::updateCategoryCounts caused 14 minutes of lag on enwiki |