[03:39:12] Hi, puppet is failing on labs instances [03:39:15] 03:36 icinga2-wm: PROBLEM - puppet on gerrit-mysql.git.eqiad.wmflabs is CRITICAL: CRITICAL: Catalog fetch fail. Either compilation failed or puppetmaster has issues [03:41:06] hmm re running puppet fixes it. [12:54:49] !log tools puppet run with clush to ensure puppet is back to normal after being broken due to duplicated python3 declaration [12:54:54] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/SAL [13:57:05] (03PS1) 10Andrew Bogott: deploy to labweb hosts as well as californium [labs/striker/deploy] - 10https://gerrit.wikimedia.org/r/412703 [14:24:53] (03CR) 10Andrew Bogott: [C: 032] deploy to labweb hosts as well as californium [labs/striker/deploy] - 10https://gerrit.wikimedia.org/r/412703 (owner: 10Andrew Bogott) [14:25:09] (03Merged) 10jenkins-bot: deploy to labweb hosts as well as californium [labs/striker/deploy] - 10https://gerrit.wikimedia.org/r/412703 (owner: 10Andrew Bogott) [18:23:00] !log tools upgrade packages of tools-cron-01 from all channels (trusty-wikimedia, trusty-updates and trusty-tools) [18:23:05] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/SAL [18:49:39] Allow me to do a one time link spam for once and say that recursive Common Table Expressions (coming on MySQL 8.0 and MariaDB 10.2) for category-relate tools may be quite interesting: https://dbahire.com/mysql-8-0-new-features-in-real-life-applications-roles-and-recursive-ctes/ [18:49:52] the examples are with commons categories, so I hope it is relevant [19:02:01] !log tools move tools-services-01 from puppet3 to puppet4 (manual package upgrade). No issues detected. [19:02:06] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/SAL [19:13:43] !log tools upgrade all packages of tools-services-01 [19:13:47] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/SAL [20:49:37] nice blog post jynus. CTEs look interesting