[06:03:34] 10DBA: Install 1 buster+10.4 host per section - https://phabricator.wikimedia.org/T246604 (10ops-monitoring-bot) Script wmf-auto-reimage was launched by marostegui on cumin1001.eqiad.wmnet for hosts: ` ['pc1008.eqiad.wmnet'] ` The log can be found in `/var/log/wmf-auto-reimage/202004100603_marostegui_235860.log`. [06:27:29] 10DBA: Install 1 buster+10.4 host per section - https://phabricator.wikimedia.org/T246604 (10ops-monitoring-bot) Completed auto-reimage of hosts: ` ['pc1008.eqiad.wmnet'] ` and were **ALL** successful. [09:29:12] 10DBA: Install 1 buster+10.4 host per section - https://phabricator.wikimedia.org/T246604 (10Marostegui) [11:02:05] 10DBA, 10Operations, 10Puppet, 10User-jbond: DB: perform rolling restart of mariadb daemons to pick up CA changes - https://phabricator.wikimedia.org/T239791 (10Marostegui) The pending hosts `root@cumin1001:/home/marostegui# for i in `mysql.py -hdb1115 -A zarcillo -e "select instance from masters where dc=... [16:37:55] marostegui: Hey, let me know when you're around please [16:43:31] Amir1: I'm out for the day, is there anything broken? [16:44:04] marostegui: nah, I just reworked my old schema drift script and got new results [16:44:07] it can wait [16:44:15] have a nice weekend! [16:44:50] Amir1: hahaha you've got the results somewhere? [16:45:25] we actually have a task for it somewhere [16:45:30] let me see if I can find ir [16:45:31] it [16:45:39] I have it already [16:45:48] https://phabricator.wikimedia.org/T104459 [16:46:00] I'm running it and it's not finished yet [16:46:09] once it's done I leave it for you :P [16:46:47] https://www.irccloud.com/pastebin/DihFXOJS/ [16:46:58] 50 ish cases in s8 and core [16:47:31] marostegui: ^ This is the first bit, I will collect and group them, what do you think? [16:47:49] yes, please do [16:47:58] I will analyze them [16:48:12] it can be useful to have such list per wiki/section [16:48:43] marostegui: do you have some extensions that make tables too for analyze? [16:48:52] Already included Wikibase [16:49:18] not sure I get your question [16:49:56] Is there any other extension that you want to check for drifts [16:50:08] right now it's only core and Wikibase [16:50:13] ah [16:50:23] no, that's the 99% of the things :-) [16:50:40] coolio [16:50:46] I'm sure we'd have plenty of work to fix those [16:50:54] although we already fixed a lot [16:51:10] but this will definitely help! [16:51:15] thank you so much [16:51:15] Looking at show tables, abusefilter, flagged revs and secure poll have lots of tables but they can wait [16:51:41] no worries, I'm happy to do this, it's public holiday here [16:52:59] yeah, those can wait [16:53:32] going back to the kitchen [16:53:37] thank you so much [16:53:49] Enjoy! [16:53:57] byeee [23:49:11] 10DBA, 10Datasets-General-or-Unknown, 10Patch-For-Review, 10Wikimedia-Incident, 10WorkType-NewFunctionality: Automate the check and fix of object, schema and data drifts between mediawiki HEAD, production masters and slaves - https://phabricator.wikimedia.org/T104459 (10Ladsgroup) Today I reworked my ori...