[08:13:50] 10DBA, 10Patch-For-Review: Productionize dbproxy101[2-7].eqiad.wmnet and dbproxy200[1-4] - https://phabricator.wikimedia.org/T202367 (10Marostegui) [08:18:06] 10DBA, 10Patch-For-Review: Productionize dbproxy101[2-7].eqiad.wmnet and dbproxy200[1-4] - https://phabricator.wikimedia.org/T202367 (10Marostegui) [08:57:20] 10DBA, 10Operations, 10ops-eqiad: Upgrade db1100 firmware and BIOS - https://phabricator.wikimedia.org/T228732 (10Marostegui) [09:00:14] 10DBA, 10Operations: Reboot, upgrade firmware and kernel of db1096-db1106, db2071-db2092 - https://phabricator.wikimedia.org/T216240 (10Marostegui) [09:51:28] 10DBA, 10AbuseFilter: Drop abuse_filter_log.afl_log_id in production - https://phabricator.wikimedia.org/T226851 (10Marostegui) I am going to start dropping this column on s6 (starting with codfw first). I have double checked that there are rows where `afl_log_id` isn't NULL on all the s6 wikis (frwiki, jawiki... [09:52:09] 10DBA, 10AbuseFilter: Drop abuse_filter_log.afl_log_id in production - https://phabricator.wikimedia.org/T226851 (10Marostegui) [10:00:54] 10DBA, 10AbuseFilter: Drop abuse_filter_log.afl_log_id in production - https://phabricator.wikimedia.org/T226851 (10Marostegui) [10:18:19] 10DBA, 10AbuseFilter, 10Stewards-and-global-tools, 10Patch-For-Review, 10User-Daimona: Addition of last hit date to Special:AbuseFilter table - https://phabricator.wikimedia.org/T93564 (10Daimona) a:05Daimona→03None Unlicking the cookie, I'm not currently on this. [10:23:40] 10DBA, 10AbuseFilter: Drop abuse_filter_log.afl_log_id in production - https://phabricator.wikimedia.org/T226851 (10Marostegui) s6 eqiad progress [] labsdb1012 [] labsdb1011 [] labsdb1010 [] labsdb1009 [x] dbstore1005 [x] db1139 [] db1131 [] db1125 [] db1113 [] db1098 [x] db1096 [] db1093 [] db1088 [] db1085... [10:23:55] 10DBA, 10AbuseFilter: Drop abuse_filter_log.afl_log_id in production - https://phabricator.wikimedia.org/T226851 (10Marostegui) [13:01:36] 10DBA, 10AbuseFilter: Drop abuse_filter_log.afl_log_id in production - https://phabricator.wikimedia.org/T226851 (10Marostegui) [13:16:40] 10DBA, 10AbuseFilter: Drop abuse_filter_log.afl_log_id in production - https://phabricator.wikimedia.org/T226851 (10Marostegui) [13:47:09] 10DBA, 10AbuseFilter: Drop abuse_filter_log.afl_log_id in production - https://phabricator.wikimedia.org/T226851 (10Marostegui) s8 eqiad progress [] labsdb1012 [] labsdb1011 [] labsdb1010 [] labsdb1009 [x] dbstore1005 [] db1126 [] db1124 [x] db1116 [] db1109 [] db1104 [] db1101 [x] db1099 [] db1092 [] db1087... [13:47:24] 10DBA, 10AbuseFilter: Drop abuse_filter_log.afl_log_id in production - https://phabricator.wikimedia.org/T226851 (10Marostegui) [13:57:37] 10DBA, 10Operations, 10ops-eqiad: Upgrade db1100 firmware and BIOS - https://phabricator.wikimedia.org/T228732 (10herron) p:05Triage→03Normal [16:29:46] 10DBA, 10Operations, 10ops-codfw, 10Goal: rack/setup/install db21[21-30].codfw.wmnet - https://phabricator.wikimedia.org/T227113 (10Papaul) [16:53:02] 10DBA, 10Operations, 10ops-codfw, 10Goal: rack/setup/install db21[21-30].codfw.wmnet - https://phabricator.wikimedia.org/T227113 (10Papaul) [16:58:43] 10DBA, 10Core Platform Team, 10MediaWiki-Database, 10Core Platform Team Backlog (Watching / External), and 5 others: FY18/19 TEC1.6 Q4: Improve or replace the usage of GTID_WAIT with pt-heartbeat in MW - https://phabricator.wikimedia.org/T221159 (10Krinkle) [17:02:39] 10DBA, 10MediaWiki-Database, 10Core Platform Team Backlog (Watching / External), 10Goal, and 4 others: FY18/19 TEC1.6 Q4: Improve or replace the usage of GTID_WAIT with pt-heartbeat in MW - https://phabricator.wikimedia.org/T221159 (10Krinkle) [17:16:24] 10DBA, 10Operations, 10ops-codfw, 10Goal: rack/setup/install db21[21-30].codfw.wmnet - https://phabricator.wikimedia.org/T227113 (10Papaul) [17:30:50] 10DBA, 10MediaWiki-Database, 10Core Platform Team Backlog (Watching / External), 10Performance-Team (Radar), and 2 others: Fix mediawiki heartbeat model, change pt-heartbeat model to not use super-user, avoid SPOF and switch automatically to the real master without... - https://phabricator.wikimedia.org/T172497 [17:32:12] 10DBA, 10Core Platform Team, 10MediaWiki-Database, 10Performance-Team (Radar): SHOW SLAVE STATUS as a health check should have a low timeout - https://phabricator.wikimedia.org/T129093 (10Krinkle) [17:39:50] 10DBA, 10Beta-Cluster-Infrastructure, 10Continuous-Integration-Infrastructure, 10MediaWiki-Database, 10Epic: Enable MariaDB/MySQL's Strict Mode - https://phabricator.wikimedia.org/T108255 (10Krinkle) [17:39:58] 10DBA, 10Beta-Cluster-Infrastructure, 10Continuous-Integration-Infrastructure, 10MediaWiki-Database, 10Epic: Enable MariaDB/MySQL's Strict Mode - https://phabricator.wikimedia.org/T108255 (10Krinkle) [17:46:50] 10DBA, 10Core Platform Team, 10MediaWiki-Debug-Logger, 10Wikimedia-Rdbms: Log the query that caused a lock timeout - https://phabricator.wikimedia.org/T198755 (10Krinkle) p:05Triage→03Low [17:46:55] 10DBA, 10MediaWiki-Debug-Logger, 10Wikimedia-Rdbms: Log the query that caused a lock timeout - https://phabricator.wikimedia.org/T198755 (10Krinkle) [18:14:26] 10DBA, 10Wikimedia-Rdbms, 10Core Platform Team (Security, stability, performance and scalability (TEC1)), 10Performance-Team (Radar): SHOW SLAVE STATUS as a health check should have a low timeout - https://phabricator.wikimedia.org/T129093 (10Anomie) Adding @aaron as the person most familiar with that code. [20:40:40] 10DBA, 10Growth-Team, 10MediaWiki-Watchlist, 10TechCom-RFC, 10Schema-change: RFC: Proposal to add wl_addedtimestamp attribute to the watchlist table - https://phabricator.wikimedia.org/T209773 (10JTannerWMF) It appears this is a task for #techcom [23:49:27] 10DBA, 10Operations, 10ops-codfw, 10Goal: rack/setup/install db21[21-30].codfw.wmnet - https://phabricator.wikimedia.org/T227113 (10Papaul)