[12:46:35] Hi everybody [12:50:05] for https://phabricator.wikimedia.org/T174386 we (analytics) have executed some UPDATE queries on two EL tables on db1108 [12:50:40] I am about to perform the same on db1107, just wanted to give you a heads up [14:17:46] 10DBA: Faster backups by archiving and unarchiving databases in parallel - https://phabricator.wikimedia.org/T189383#4040473 (10jcrespo) a:03jcrespo [14:18:37] luca, thanks for the heads up, I can see the scheduled maintanance [16:16:06] 10DBA: Drop flaggedrevs tables from mediawikiwiki - https://phabricator.wikimedia.org/T186865#4081119 (10demon) Yep, those are the ones. [17:26:19] 10DBA, 10Operations, 10Goal: Convert all sanitarium hosts to multi-instance and increase its reliability/redundancy - https://phabricator.wikimedia.org/T190704#4081506 (10jcrespo) p:05Triage>03Normal [17:26:49] 10DBA, 10Operations, 10Goal: Convert all sanitarium hosts to multi-instance and increase its reliability/redundancy - https://phabricator.wikimedia.org/T190704#4081518 (10jcrespo) p:05Normal>03High [17:28:07] 10DBA, 10Operations, 10Goal: Convert all sanitarium hosts to multi-instance and increase its reliability/redundancy - https://phabricator.wikimedia.org/T190704#4081506 (10jcrespo) [17:39:34] jynus: why high? [17:39:57] because goal? [17:40:03] I can put it as normal [17:40:07] goals aren't necessarily high priority I think [17:40:11] ok [17:40:22] yeah "normal" [17:40:31] we just have a lot of those and choose to work on this one now ;) [17:40:33] to be fair, high for us is almost normal [17:40:36] hehe [17:40:37] normal is low [17:40:45] i guess to capture it properly we'd need a few more levels [17:40:49] normal-high ;p [17:40:49] and low is "we will never work on it" [17:40:53] sadly [17:41:05] actually I thought about proposing to create very high [17:41:17] for pure psycological reasons [17:41:27] people gets worried when low gets used [17:41:31] so it is never used [17:41:32] hehe [17:41:45] reminds me of formula 1 [17:41:48] they have tires [17:41:54] hard, medium, soft, super soft [17:41:59] then created ultrasoft [17:42:03] and then needed even softer... [17:42:11] hypersoft [17:42:21] it gets tricky doesn't it [17:42:31] 10DBA, 10Operations, 10Goal: Convert all sanitarium hosts to multi-instance and increase its reliability/redundancy - https://phabricator.wikimedia.org/T190704#4081606 (10jcrespo) p:05High>03Normal [17:43:20] so you actually read phabricator updates... [17:46:45] no i was just glancing in this channel [17:46:46] :) [17:46:51] 10DBA, 10Data-Services, 10Patch-For-Review: LabsDB infrastructure pending work - https://phabricator.wikimedia.org/T153058#4081629 (10jcrespo) Except for labsdb multi-instance/GTID and custom tables this is feature-complete, so this and T140788 can be closed and use individual subtickets for the few pending... [19:51:03] 10DBA, 10Cloud-Services, 10Cloud-VPS, 10Epic, 10Tracking: Labs databases rearchitecture (tracking) - https://phabricator.wikimedia.org/T140788#4082087 (10jcrespo) 05Open>03Resolved a:03jcrespo From the DBA side, labsdb rearchitecture with the new servers is completed, only thing left is this quarte... [19:51:59] 10DBA, 10Cloud-Services, 10Cloud-VPS, 10Epic, 10Tracking: Labs databases rearchitecture (tracking) - https://phabricator.wikimedia.org/T140788#4082101 (10jcrespo) [19:52:03] 10DBA, 10Data-Services, 10Patch-For-Review: LabsDB infrastructure pending work - https://phabricator.wikimedia.org/T153058#4082096 (10jcrespo) 05Open>03Resolved a:03jcrespo Everthing except T59617 is done. [19:58:32] 10DBA, 10Epic: Meta ticket: Migrate multi-source database hosts to multi-instance - https://phabricator.wikimedia.org/T159423#4082128 (10jcrespo) [19:58:34] 10DBA: convert dbstore1001 to multi-instance + InnoDB compressed by importing db shards to it - https://phabricator.wikimedia.org/T159430#4082127 (10jcrespo) [19:58:41] 10DBA, 10Epic: Meta ticket: Migrate multi-source database hosts to multi-instance - https://phabricator.wikimedia.org/T159423#3067139 (10jcrespo) [19:58:44] 10DBA: convert dbstore1001 to multi-instance + InnoDB compressed by importing db shards to it - https://phabricator.wikimedia.org/T159430#3067264 (10jcrespo) [19:59:15] 10DBA, 10Epic: Meta ticket: Migrate multi-source database hosts to multi-instance - https://phabricator.wikimedia.org/T159423#3067139 (10jcrespo) [19:59:21] 10DBA, 10Cloud-Services, 10Patch-For-Review: Add and sanitize s2, s4, s5, s6 and s7 to sanitarium2 and new labsdb hosts - https://phabricator.wikimedia.org/T153743#4082132 (10jcrespo) [19:59:34] 10DBA, 10Epic: Meta ticket: Migrate multi-source database hosts to multi-instance - https://phabricator.wikimedia.org/T159423#3067139 (10jcrespo) [19:59:40] 10DBA, 10Cloud-Services, 10Patch-For-Review: Add and sanitize s2, s4, s5, s6 and s7 to sanitarium2 and new labsdb hosts - https://phabricator.wikimedia.org/T153743#3403475 (10jcrespo) [20:02:58] 10DBA, 10Epic: Meta ticket: Migrate multi-source database hosts to multi-instance - https://phabricator.wikimedia.org/T159423#4082148 (10jcrespo) [20:09:47] 10DBA, 10MediaWiki-Database, 10Tracking: Duplicate key errors (tracking) - https://phabricator.wikimedia.org/T106854#4082193 (10jcrespo) p:05High>03Normal I can only see 11 entries in the last month: Normal or low. [20:11:52] 10DBA, 10MediaWiki-Database, 10Tracking: Duplicate key errors (tracking) - https://phabricator.wikimedia.org/T106854#4082219 (10jcrespo) p:05Normal>03Low Actually, we had 0 in the last month, I searched for duplicate key and got unrelated errors for "on duplicate key" syntax. [20:22:47] 10DBA, 10Epic, 10Tracking: Database tables to be dropped on Wikimedia wikis and other WMF databases (tracking) - https://phabricator.wikimedia.org/T54921#4082251 (10jcrespo) We got a report of stale data on langlinks table on fawiki T190667. Is it possible there is stale data on those table but they are othe... [22:40:07] 10DBA, 10Epic, 10Tracking: Database tables to be dropped on Wikimedia wikis and other WMF databases (tracking) - https://phabricator.wikimedia.org/T54921#4082872 (10demon) I know nothing about langlinks. [23:42:12] 10DBA, 10MediaWiki-Logging, 10MediaWiki-Patrolling, 10Wikidata-Ministry-Of-Magic: Run deleteAutopatrolLogs script for Wikidata (WMF) - https://phabricator.wikimedia.org/T189596#4083013 (10Krinkle)