[06:24:22] 10Blocked-on-schema-change, 10DBA: Schema change for renaming name_title_timestamp on archive table - https://phabricator.wikimedia.org/T273359 (10Marostegui) Started on s3 master - will take around 15h [06:25:14] 10Blocked-on-schema-change, 10DBA: Schema change for renaming name_title_timestamp on archive table - https://phabricator.wikimedia.org/T273359 (10Ladsgroup) Thank you so much! [06:46:20] 10DBA, 10decommission-hardware, 10Patch-For-Review: decommission db1092.eqiad.wmnet - https://phabricator.wikimedia.org/T275019 (10Marostegui) [06:47:20] 10DBA, 10Data-Persistence-Backup, 10Data-Persistence: Drop unused database "bacula" from m1 - https://phabricator.wikimedia.org/T274809 (10Marostegui) p:05Triage→03Medium @jcrespo is this ready to be done anytime? [06:47:55] 10DBA: mariadb: Replication lag monitoring does not support circular replication - https://phabricator.wikimedia.org/T275497 (10Marostegui) p:05Triage→03Medium [06:53:16] 10DBA, 10SRE, 10Patch-For-Review: Productionize db1155-db1175 and refresh and decommission db1074-db1095 (22 servers) - https://phabricator.wikimedia.org/T258361 (10Marostegui) Transfer on-going from db1088 to db1168. I will also install 10.4.18 on db1168 [07:44:00] 10DBA, 10Data-Persistence-Backup, 10Data-Persistence: Drop unused database "bacula" from m1 - https://phabricator.wikimedia.org/T274809 (10jcrespo) Yes, I was waiting for your input/help. There was a backup of the "bacula" db created and sent to bacula. [07:50:55] 10DBA, 10Data-Persistence-Backup, 10Data-Persistence: Drop unused database "bacula" from m1 - https://phabricator.wikimedia.org/T274809 (10Marostegui) Let's drop it on Monday? [07:52:30] 10DBA, 10Data-Persistence-Backup, 10Data-Persistence: Drop unused database "bacula" from m1 - https://phabricator.wikimedia.org/T274809 (10jcrespo) Ok. [07:53:49] 10DBA, 10Data-Persistence-Backup, 10Data-Persistence: Drop unused database "bacula" from m1 - https://phabricator.wikimedia.org/T274809 (10Marostegui) We could also rename the tables first and leave it for a couple of days and then proceed with the final deletion. [09:38:05] 10DBA, 10SRE, 10Patch-For-Review: Productionize db1155-db1175 and refresh and decommission db1074-db1095 (22 servers) - https://phabricator.wikimedia.org/T258361 (10Marostegui) db1168 is now replicating. [09:54:54] kormat: looks like you didn;t get a resolution to yuo answer re lookup in functions. i would suggest perhaps knocking up a quick PoV of what you want to do using lookup and then ill be happy to take a look to see if there is a better none style breaking method [09:55:19] s/better/different/ :) [09:55:24] :D [09:55:31] alright, i'll sketch out something quick [09:55:37] ack [10:17:15] jbond42, joe_oblivian: truly awful pseudo-code: https://phabricator.wikimedia.org/P14478 [10:30:53] * jbond42 looking [10:31:02] <_joe_> kormat: so, that doesn't look too awful :) and good news is you can use a puppet function [10:31:38] <_joe_> jbond42: I think in this case having a lookup in a function is not introducing too much obscurity, similar to kafka_cluster_name [10:32:11] _joe_: i agree and i think in genral lookups are probably ok in functions [10:32:25] <_joe_> kormat: for bonus points, we could use the function to actually inject parameters in your profiles, so that all lookups are still clustered in a single place [10:32:49] <_joe_> uhm that wouldn't work sadly [10:32:55] <_joe_> nevermind :) [10:33:03] ok :) [10:34:18] kormat: bonus point if you make it work replacing unidir and circular with approriate emojis :-P [10:35:13] ah haha [10:40:53] <_joe_> volans: bonus point if you trick chris into adding emoji support to the puppet parser [10:43:12] _joe_, jbond42: thanks for the input <3 [10:46:33] np :) [11:39:50] 10DBA: Reimage db1134 to Buster and repool it - https://phabricator.wikimedia.org/T275343 (10Marostegui) Data looks good [11:39:58] 10DBA: Reimage db1134 to Buster and repool it - https://phabricator.wikimedia.org/T275343 (10Marostegui) [11:43:11] 10DBA: Reimage db1134 to Buster and repool it - https://phabricator.wikimedia.org/T275343 (10ops-monitoring-bot) Script wmf-auto-reimage was launched by marostegui on cumin1001.eqiad.wmnet for hosts: ` ['db1134.eqiad.wmnet'] ` The log can be found in `/var/log/wmf-auto-reimage/202102251143_marostegui_5186.log`. [12:02:29] 10DBA: Reimage db1134 to Buster and repool it - https://phabricator.wikimedia.org/T275343 (10ops-monitoring-bot) Completed auto-reimage of hosts: ` ['db1134.eqiad.wmnet'] ` and were **ALL** successful. [12:12:31] 10DBA: Reimage db1134 to Buster and repool it - https://phabricator.wikimedia.org/T275343 (10Marostegui) [12:15:41] 10DBA: Reimage db1134 to Buster and repool it - https://phabricator.wikimedia.org/T275343 (10Marostegui) Installed 10.4.18 here too [16:00:05] 10DBA, 10Orchestrator: orchestrator: Upgrade to v3.2.4 (ish) - https://phabricator.wikimedia.org/T275784 (10Kormat) [16:00:17] marostegui: ^ i hope you're happy :P [16:15:42] hahaha