[00:37:01] 10DBA, 10Cloud-Services, 10Operations, 10Patch-For-Review: m5-master overloaded by idle connections to the nova database - https://phabricator.wikimedia.org/T188589 (10Bstorm) [05:58:12] 10DBA: Remove partitions from revision table - https://phabricator.wikimedia.org/T239453 (10Marostegui) [06:14:42] 10DBA, 10Operations, 10ops-codfw: (Needed By 31st January) codfw: rack/setup/install es202[0-5].codfw.wmnet - https://phabricator.wikimedia.org/T241336 (10Marostegui) [06:19:03] 10DBA, 10Operations, 10Puppet, 10User-jbond: DB: perform rolling restart of mariadb deamons to pick up CA changes - https://phabricator.wikimedia.org/T239791 (10Marostegui) [06:23:16] 10DBA, 10Core Platform Team, 10MediaWiki-Page-derived-data, 10TechCom-RFC, and 2 others: Normalize MediaWiki link tables - https://phabricator.wikimedia.org/T222224 (10DannyS712) [06:28:21] 10DBA, 10Operations, 10Puppet, 10User-jbond: DB: perform rolling restart of mariadb deamons to pick up CA changes - https://phabricator.wikimedia.org/T239791 (10Marostegui) [09:09:18] 10DBA, 10Schema-change: Drop `echo_notification_user_hash_timestamp` index where it exists - https://phabricator.wikimedia.org/T242749 (10Marostegui) a:03Marostegui [09:25:43] 10DBA, 10Schema-change: Drop `echo_notification_user_hash_timestamp` index where it exists - https://phabricator.wikimedia.org/T242749 (10Marostegui) [09:28:59] 10DBA, 10Schema-change: Drop `echo_notification_user_hash_timestamp` index where it exists - https://phabricator.wikimedia.org/T242749 (10Marostegui) x1 eqiad progress [] dbstore1005 [] db1140 [] db1137 [] db1127 [] db1120 [09:39:45] 10DBA, 10Schema-change: Drop `echo_notification_user_hash_timestamp` index where it exists - https://phabricator.wikimedia.org/T242749 (10Marostegui) [09:39:57] 10DBA, 10Schema-change: Drop `echo_notification_user_hash_timestamp` index where it exists - https://phabricator.wikimedia.org/T242749 (10Marostegui) 05Open→03Resolved All done! [11:17:44] 10DBA, 10Operations, 10ops-codfw, 10Patch-For-Review: d-i fails to install on servers with BRCM 2P 1G BT + 2P 10G SFP NDC - https://phabricator.wikimedia.org/T242481 (10MoritzMuehlenhoff) [11:58:18] 10DBA, 10Operations, 10ops-codfw, 10Patch-For-Review: d-i fails to install on servers with BRCM 2P 1G BT + 2P 10G SFP NDC - https://phabricator.wikimedia.org/T242481 (10MoritzMuehlenhoff) This install error is caused by the fact that these servers have a dual port NIC with 1G and 10G interfaces, but only t... [12:01:53] 10DBA, 10Operations, 10ops-codfw, 10Patch-For-Review: d-i fails to install on servers with BRCM 2P 1G BT + 2P 10G SFP NDC - https://phabricator.wikimedia.org/T242481 (10Marostegui) I like option 3 indeed. There is one more option which is a bit more painful, which is to live hack pxelinux and set the MAC... [18:33:31] 10DBA, 10Product-Infrastructure-Team-Backlog, 10Release-Engineering-Team-TODO: Drop DB tables for now-deleted zerowiki from production - https://phabricator.wikimedia.org/T227717 (10Jdforrester-WMF) Truncating should be fine. [18:40:34] 10DBA, 10Product-Infrastructure-Team-Backlog, 10Release-Engineering-Team-TODO: Drop DB tables for now-deleted zerowiki from production - https://phabricator.wikimedia.org/T227717 (10Marostegui) That's way easier then. We should still get a full logical dump before attempting to do so.