[00:40:33] <wikibugs>	 10DBA, 10Data-Services, 10Dumps-Generation: Drop education program (ep_*) tables on all wikis - https://phabricator.wikimedia.org/T174802 (10Reedy)
[01:09:09] <wikibugs>	 10DBA, 10Data-Services, 10Dumps-Generation: Archive and drop education program (ep_*) tables on all wikis - https://phabricator.wikimedia.org/T174802 (10Reedy)
[01:10:35] <wikibugs>	 10DBA, 10Data-Services, 10Dumps-Generation: Archive and drop education program (ep_*) tables on all wikis - https://phabricator.wikimedia.org/T174802 (10Reedy) See also {T200391}  If we're going to make some archive... Should we be dumping stuff in NS 446 and 447 too?
[07:59:09] <marostegui>	 https://wikitech.wikimedia.org/wiki/MariaDB/Backups#Recovering_a_logical_backup
[07:59:20] <marostegui>	 What is the correct way to upgrade zarcillo DB with a new host (db1120)?
[08:01:52] <jynus>	 mm
[08:02:01] <jynus>	 so note this is all experimental
[08:02:07] <marostegui>	 sure
[08:02:12] <jynus>	 I have yet to write a script an all that
[08:02:14] <marostegui>	 but I wanted to get it updated :)
[08:02:22] <jynus>	 but 1) add the hard to servers
[08:02:30] <marostegui>	 servers table, right?
[08:02:34] <jynus>	 2) add the instance to instances
[08:02:38] <jynus>	 yes
[08:02:40] <marostegui>	 ok!
[08:02:52] <jynus>	 3) add the section to section_instances
[08:04:32] <marostegui>	 ok! Thanks!
[08:05:49] <jynus>	 if everthing is ok, section x1 should return the new instance
[08:06:26] <marostegui>	 great - thanks :)
[08:08:27] <jynus>	 BTW, if you used recover_section
[08:08:40] <jynus>	 be aware of the bug with empty databases and do a quick diff of show databases
[08:09:00] <marostegui>	 yeah - that is on my to-do for before pooling it
[08:09:22] <jynus>	 I think I will workaround it at the same time than I do the stats thing
[08:09:33] <jynus>	 as we will need to connect to mysql anyway
[15:05:28] <jynus>	 marostegui: I've created a new kibana dashboard, called DBError https://logstash.wikimedia.org/goto/9f36fec54060158a5241b368ff5fd17b
[15:05:51] <marostegui>	 Ahi, it groups everything we normally look for
[15:05:52] <marostegui>	 no?
[15:05:56] <jynus>	 yes
[15:06:00] <marostegui>	 <3
[15:06:02] <jynus>	 I wanted to add SlowTimer
[15:06:19] <jynus>	 but I cannot manage to edit the query in code mode to add a proper OR
[18:13:11] <wikibugs>	 10DBA, 10Operations, 10ops-eqiad: Degraded RAID on db1072 - https://phabricator.wikimedia.org/T199636 (10Marostegui) The disk has been swapped by Chris  ``` PD: 1 Information Enclosure Device ID: 32 Slot Number: 1 Drive's position: DiskGroup: 0, Span: 0, Arm: 1 Enclosure position: 1 Device Id: 1 WWN: 5000C50...
[19:18:06] <wikibugs>	 10DBA, 10Operations, 10ops-eqiad: Degraded RAID on db1072 - https://phabricator.wikimedia.org/T199636 (10Marostegui) 05Open>03Resolved ``` 19:17 < icinga-wm> RECOVERY - MegaRAID on db1072 is OK: OK: optimal, 1 logical, 2 physical, WriteBack policy...
[19:19:38] <wikibugs>	 10DBA, 10Operations, 10Traffic, 10Patch-For-Review: Framework to transfer files over the LAN - https://phabricator.wikimedia.org/T156462 (10Marostegui) @jcrespo how do you feel about closing this task as resolved?