[06:38:31] 10DBA: Drop wb_terms in production from s4 (commonswiki, testcommonswiki), s3 (testwikidatawiki), s8 (wikidatawiki) - https://phabricator.wikimedia.org/T248086 (10Marostegui) No errors for `testwikidatawiki` after yesterday's rename. Let's see if the whole weekend goes clean! [07:30:22] 10DBA, 10Operations, 10Puppet, 10User-jbond: DB: perform rolling restart of mariadb daemons to pick up CA changes - https://phabricator.wikimedia.org/T239791 (10Marostegui) [07:30:55] 10DBA, 10Operations, 10Puppet, 10User-jbond: DB: perform rolling restart of mariadb daemons to pick up CA changes - https://phabricator.wikimedia.org/T239791 (10Marostegui) Only s1-s8 and x1 masters pending. [08:11:53] I've taken care of x1 snapshot purge [08:20:21] thanks [10:24:36] 10DBA, 10Data-Services, 10Quarry: Quarry query became work much slower - https://phabricator.wikimedia.org/T247978 (10Marostegui) Another thing we can also try is upgrading labsdb1011 to Buster and MariaDB 10.4 We recently had some CPU issues with wikidatawiki (after they all got InnoDB compressed - like our... [15:22:40] 10DBA: Remove grants for the old dbproxy hosts from the misc databases - https://phabricator.wikimedia.org/T231280 (10Papaul) [15:24:51] not a single restore since 2020-03-05 [15:25:34] I will do one next week, the last time I did one was a year ago I think [15:25:55] i know yout tried before [15:26:03] and know you can [15:26:08] not sure about others... [15:26:15] 10DBA, 10Operations: Decommission db1061-db1073 - https://phabricator.wikimedia.org/T217396 (10Papaul) [15:26:54] and others have excuse, eg. no backup needed [15:26:58] It is worth doing it again though :) [15:28:56] 10DBA, 10Operations: Decommission db1061-db1073 - https://phabricator.wikimedia.org/T217396 (10Papaul) [17:48:13] 10DBA, 10Beta-Cluster-Infrastructure, 10Continuous-Integration-Infrastructure, 10Wikimedia-Rdbms, 10Epic: Enable MariaDB/MySQL's Strict Mode - https://phabricator.wikimedia.org/T108255 (10Krinkle) [19:28:29] 10DBA, 10Data-Services, 10Quarry: Quarry: Lost connection to MySQL server during query - https://phabricator.wikimedia.org/T246970 (10Mike_Peel) I sort of have my query running on paws now (at https://paws.wmflabs.org/paws/user/Mike_Peel/notebooks/Query%20for%20Wikidata%20Infobox.ipynb if you can access that...