[07:14:00] 10DBA, 10Operations, 10Wikimedia-Site-requests: Global rename of Idh0854 → Garam: supervision needed - https://phabricator.wikimedia.org/T167031#3347033 (10Marostegui) @MarcoAurelio just ping me when you want to do this. We did (T167597) Monday morning (European morning) and we had no issues, so maybe around... [08:05:59] 10DBA, 10Patch-For-Review: Migrate parsercache hosts to file per table - https://phabricator.wikimedia.org/T167567#3347078 (10jcrespo) a:03jcrespo [08:10:37] 10DBA, 10Operations, 10Patch-For-Review: eqiad rack/setup 11 new DB servers - https://phabricator.wikimedia.org/T162233#3347081 (10jcrespo) [08:11:05] 10DBA, 10Operations, 10Patch-For-Review: eqiad rack/setup 11 new DB servers - https://phabricator.wikimedia.org/T162233#3156297 (10jcrespo) Taking db1096 for T167567 [08:11:40] 10DBA, 10Operations, 10Patch-For-Review: eqiad rack/setup 11 new DB servers - https://phabricator.wikimedia.org/T162233#3347085 (10jcrespo) [08:17:01] 10DBA, 10Patch-For-Review: Migrate parsercache hosts to file per table - https://phabricator.wikimedia.org/T167567#3347086 (10jcrespo) Taking db1096 & db2072 (current spare hosts originally intended for s8) as a temporary measure to failover pc hosts. [08:47:14] 10DBA: DROP OAI-related tables - https://phabricator.wikimedia.org/T139342#3347162 (10Marostegui) [08:47:43] 10DBA, 10Epic, 10Tracking: Database tables to be dropped on Wikimedia wikis and other WMF databases (tracking) - https://phabricator.wikimedia.org/T54921#3347165 (10Marostegui) [08:47:45] 10DBA: DROP OAI-related tables - https://phabricator.wikimedia.org/T139342#2428747 (10Marostegui) 05Open>03Resolved All shards done. [09:16:26] 10DBA, 10Schema-change: Drop titlekey table from all wmf databases - https://phabricator.wikimedia.org/T164949#3252028 (10Marostegui) Current status of this unused table: s1: ``` root@db1052:/srv/sqldata/enwiki# find . -name titlekey.ibd | xargs ls -lh -rw-rw---- 1 mysql mysql 4.8G Nov 19 2014 ./titlekey.ibd... [09:46:12] 10DBA, 10Schema-change: Drop titlekey table from all wmf databases - https://phabricator.wikimedia.org/T164949#3347334 (10Marostegui) I have backup'ed all the tables under: ``` dbstore1001:/srv/tmp/T164949 root@dbstore1001:/srv/tmp/T164949# du -sh . 3.9G . ``` [09:48:25] 10DBA, 10Schema-change: Drop titlekey table from all wmf databases - https://phabricator.wikimedia.org/T164949#3347337 (10Marostegui) Before dropping the tables, I have renamed it on `db1089` on `enwiki` to see if any issues arise: ``` root@db1089[enwiki]> set session sql_log_bin=0; Query OK, 0 rows affected (... [09:48:53] 10DBA, 10Schema-change: Drop titlekey table from all wmf databases - https://phabricator.wikimedia.org/T164949#3347338 (10Marostegui) a:03Marostegui [10:39:25] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Convert unique keys into primary keys for some wiki tables on s4 - https://phabricator.wikimedia.org/T166206#3347411 (10Marostegui) db1095 is done (as this is sanitarium2, some tables will not exist): ``` root@neodymium:/home/marostegui# for i in `cat s4... [10:40:51] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Convert unique keys into primary keys for some wiki tables on s4 - https://phabricator.wikimedia.org/T166206#3347413 (10Marostegui) [14:41:00] 10DBA, 10Operations, 10Wikimedia-Site-requests: Global rename of Idh0854 → Garam: supervision needed - https://phabricator.wikimedia.org/T167031#3348220 (10alanajjar) @MarcoAurelio please see the comment of the user in Meta! [15:04:57] 10DBA, 10Beta-Cluster-Infrastructure, 10Operations, 10Patch-For-Review, 10Release-Engineering-Team (Backlog): Better mysql command prompt info for Beta - https://phabricator.wikimedia.org/T157714#3348386 (10hashar) 05Open>03Resolved Solved via https://gerrit.wikimedia.org/r/#/c/336964/ / 35098e1e363e... [15:34:07] 10DBA, 10Patch-For-Review: Migrate parsercache hosts to file per table - https://phabricator.wikimedia.org/T167567#3348566 (10jcrespo) [15:41:28] I am going to put down pc1004 and pc2004 and start either importing or deleting stuff [15:44:01] jynus: sounds good, kill the script if you want [15:44:39] yes [15:45:05] I may also start to replicate from the current hosts [15:45:25] but first I have to decide what is to be kept and what is to be left out [15:45:41] anomie just told me how to differenciate old-style and new-style hashes [15:45:52] good [15:46:35] the good thing about caches is that we do not need to spend much time on having perfect results [16:04:03] 10DBA, 10Operations, 10ops-codfw: Degraded RAID on db2070 - https://phabricator.wikimedia.org/T167667#3348651 (10Papaul) Dear Mr Papaul Tshibamba, Hewlett Packard Enterprise Reference Number: 5320469389 STATUS: Customer Self Repair Part has been shipped Part/s shipped: 765867-001 Part description: SPS-DRV... [16:06:24] 10DBA, 10MediaWiki-Platform-Team, 10MediaWiki-extensions-Linter, 10Wikimedia-Extension-setup, and 3 others: Review and deploy Linter extension to Wikimedia wikis - https://phabricator.wikimedia.org/T148609#3348655 (10Elitre) @Legoktm I'm assuming you still don't need anything from CLs since I haven't heard... [16:07:57] 10DBA, 10Operations, 10Wikimedia-Site-requests: Global rename of Idh0854 → Garam: supervision needed - https://phabricator.wikimedia.org/T167031#3348668 (10Aklapper) @alanajjar: Which one and where exactly? Clear links welcome for statements, to avoid misunderstandings. :) [16:09:58] 10DBA, 10MediaWiki-Platform-Team, 10MediaWiki-extensions-Linter, 10Wikimedia-Extension-setup, and 3 others: Review and deploy Linter extension to Wikimedia wikis - https://phabricator.wikimedia.org/T148609#3348672 (10ssastry) >>! In T148609#3348655, @Elitre wrote: > @Legoktm I'm assuming you still don't ne... [16:32:23] 10DBA, 10Operations, 10ops-codfw: Degraded RAID on db2070 - https://phabricator.wikimedia.org/T167667#3348738 (10Marostegui) Oh nice - you got it in the end. Thanks for handling it! [17:37:30] 10DBA, 10Schema-change: Drop titlekey table from all wmf databases - https://phabricator.wikimedia.org/T164949#3348939 (10demon) Awesome progress, thanks! [17:47:57] 10DBA, 10Operations, 10Wikimedia-Site-requests: Global rename of Idh0854 → Garam: supervision needed - https://phabricator.wikimedia.org/T167031#3348985 (10alanajjar) @Aklapper of course I talked about the comment by Idh0854 on Steward requests/Username changes. [[ https://meta.wikimedia.org/w/index.php?titl... [18:42:33] 10DBA, 10MediaWiki-Database, 10MediaWiki-Logging, 10Performance-Team, 10Schema-change: Logging needs an index to optimize searching by log_title - https://phabricator.wikimedia.org/T68961#3349191 (10Krinkle) [21:01:52] 10DBA, 10Epic, 10Tracking: Database tables to be dropped on Wikimedia wikis and other WMF databases (tracking) - https://phabricator.wikimedia.org/T54921#3349798 (10demon) [22:16:22] 10DBA, 10Labs: Prepare and check storage layer for atjwiki - https://phabricator.wikimedia.org/T167715#3350090 (10Reedy) Wiki has been created! [22:46:57] 10DBA, 10Labs: Prepare and check storage layer for atjwiki - https://phabricator.wikimedia.org/T167715#3350169 (10Benoit_Rochon) Youppiii. Lol. Thanks a lot Reedy. Is the content from incubator will follow? [22:49:46] 10DBA, 10Labs: Prepare and check storage layer for atjwiki - https://phabricator.wikimedia.org/T167715#3350177 (10Reedy) >>! In T167715#3350169, @Benoit_Rochon wrote: > Is the content from incubator will follow? "we" don't usually do that. Usually the incubator guys do, so MF-Warburg or SPQRobin will do it as...