[01:17:40] (03PS1) 10David Martin: Create schema for tracking WikiLambda APIs [schemas/event/secondary] - 10https://gerrit.wikimedia.org/r/1019138 (https://phabricator.wikimedia.org/T356228) [06:32:29] 10Data-Engineering (Q4 2024 April 1st - June 30th): Fix and validate browser report DAG and queries - https://phabricator.wikimedia.org/T362201#9709095 (10JAllemandou) [07:03:30] (03CR) 10Joal: "One global nit affecting all files: the `day` column should be renamed `date`. Since it's a reserved SQL keyword, you'll need to use backt" [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1018365 (owner: 10Aleksandar Mastilovic) [08:00:02] (03CR) 10Joal: "Some nits - good to go for me after those" [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1017161 (owner: 10Aleksandar Mastilovic) [08:00:31] (03CR) 10Joal: [C:03+1] "LGTM :)" [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1018331 (owner: 10Aleksandar Mastilovic) [09:25:29] 06Data-Engineering, 10Data-Platform-SRE (2024.03.25 - 2024.04.14), 13Patch-For-Review: Migrate matomo to Debian bullseye (or bookworm) - https://phabricator.wikimedia.org/T349397#9709376 (10ops-monitoring-bot) Icinga downtime and Alertmanager silence (ID=f352b90c-97fc-4393-81bf-02d23c551595) set by btullis@c... [10:32:54] (03CR) 10Joal: "A bunch of comments - Let's discuss them as you wish :)" [analytics/refinery/source] - 10https://gerrit.wikimedia.org/r/1015013 (https://phabricator.wikimedia.org/T358681) (owner: 10Mforns) [11:33:37] 06Data-Engineering, 10Data-Platform-SRE (2024.03.25 - 2024.04.14), 13Patch-For-Review: Migrate matomo to Debian bullseye (or bookworm) - https://phabricator.wikimedia.org/T349397#9709684 (10ops-monitoring-bot) Cookbook cookbooks.sre.hosts.reimage was started by btullis@cumin1002 for host matomo1003.eqiad.wmn... [11:59:36] (03CR) 10Milimetric: Clean up and parameterize SQL code for Common Impact Metrics. (031 comment) [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1016796 (https://phabricator.wikimedia.org/T358681) (owner: 10Xcollazo) [12:02:52] 06Data-Engineering, 10Data-Platform-SRE (2024.03.25 - 2024.04.14), 13Patch-For-Review: Migrate matomo to Debian bullseye (or bookworm) - https://phabricator.wikimedia.org/T349397#9709700 (10ops-monitoring-bot) Cookbook cookbooks.sre.hosts.reimage started by btullis@cumin1002 for host matomo1003.eqiad.wmnet w... [13:38:47] (03PS15) 10Xcollazo: Clean up and parameterize SQL code for Common Impact Metrics. [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1016796 (https://phabricator.wikimedia.org/T358681) [13:39:32] (03CR) 10Xcollazo: [V:03+2] Clean up and parameterize SQL code for Common Impact Metrics. (032 comments) [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1016796 (https://phabricator.wikimedia.org/T358681) (owner: 10Xcollazo) [14:02:53] (HiveServerHeapUsage) firing: Hive Server JVM Heap usage is above 80% on an-coord1003:10100 - https://wikitech.wikimedia.org/wiki/Analytics/Systems/Cluster/Hive/Alerts#Hive_Server_Heap_Usage - https://grafana.wikimedia.org/d/000000379/hive?panelId=7&fullscreen&orgId=1&var-instance=an-coord1003:10100 - https://alerts.wikimedia.org/?q=alertname%3DHiveServerHeapUsage [14:18:07] 06Data-Engineering, 10Data-Platform-SRE (2024.03.25 - 2024.04.14), 13Patch-For-Review: Migrate matomo to Debian bullseye (or bookworm) - https://phabricator.wikimedia.org/T349397#9710118 (10ops-monitoring-bot) Cookbook cookbooks.sre.hosts.reimage was started by btullis@cumin1002 for host matomo1003.eqiad.wmn... [14:59:26] 06Data-Engineering, 10Data-Platform-SRE (2024.03.25 - 2024.04.14), 13Patch-For-Review: Migrate matomo to Debian bullseye (or bookworm) - https://phabricator.wikimedia.org/T349397#9710269 (10ops-monitoring-bot) Cookbook cookbooks.sre.hosts.reimage started by btullis@cumin1002 for host matomo1003.eqiad.wmnet w... [15:02:32] 06Data-Engineering, 10Data-Platform-SRE (2024.03.25 - 2024.04.14), 13Patch-For-Review: Migrate matomo to Debian bullseye (or bookworm) - https://phabricator.wikimedia.org/T349397#9710272 (10ops-monitoring-bot) Cookbook cookbooks.sre.hosts.reimage was started by btullis@cumin1002 for host matomo1003.eqiad.wmn... [15:31:33] 06Data-Engineering, 10Data-Platform-SRE (2024.03.25 - 2024.04.14), 13Patch-For-Review: Migrate matomo to Debian bullseye (or bookworm) - https://phabricator.wikimedia.org/T349397#9710342 (10ops-monitoring-bot) Cookbook cookbooks.sre.hosts.reimage started by btullis@cumin1002 for host matomo1003.eqiad.wmnet w... [15:33:10] 06Data-Engineering, 10Data-Platform-SRE (2024.03.25 - 2024.04.14), 13Patch-For-Review: Migrate matomo to Debian bullseye (or bookworm) - https://phabricator.wikimedia.org/T349397#9710347 (10ops-monitoring-bot) Cookbook cookbooks.sre.hosts.reimage was started by btullis@cumin1002 for host matomo1003.eqiad.wmn... [16:19:50] 06Data-Engineering, 10Data-Platform-SRE (2024.03.25 - 2024.04.14), 13Patch-For-Review: Migrate matomo to Debian bullseye (or bookworm) - https://phabricator.wikimedia.org/T349397#9710513 (10ops-monitoring-bot) Cookbook cookbooks.sre.hosts.reimage started by btullis@cumin1002 for host matomo1003.eqiad.wmnet w... [17:20:11] (03CR) 10Hghani: [C:03+2] movement_metrics: Retire global_markets_pageviews [analytics/wmf-product/jobs] - 10https://gerrit.wikimedia.org/r/1018386 (https://phabricator.wikimedia.org/T359691) (owner: 10Neil Shah-Quinn (WMF)) [17:20:46] (03CR) 10Hghani: [V:03+2 C:03+2] movement_metrics: Retire global_markets_pageviews [analytics/wmf-product/jobs] - 10https://gerrit.wikimedia.org/r/1018386 (https://phabricator.wikimedia.org/T359691) (owner: 10Neil Shah-Quinn (WMF)) [18:02:53] (HiveServerHeapUsage) firing: Hive Server JVM Heap usage is above 80% on an-coord1003:10100 - https://wikitech.wikimedia.org/wiki/Analytics/Systems/Cluster/Hive/Alerts#Hive_Server_Heap_Usage - https://grafana.wikimedia.org/d/000000379/hive?panelId=7&fullscreen&orgId=1&var-instance=an-coord1003:10100 - https://alerts.wikimedia.org/?q=alertname%3DHiveServerHeapUsage [18:07:53] (HiveServerHeapUsage) resolved: Hive Server JVM Heap usage is above 80% on an-coord1003:10100 - https://wikitech.wikimedia.org/wiki/Analytics/Systems/Cluster/Hive/Alerts#Hive_Server_Heap_Usage - https://grafana.wikimedia.org/d/000000379/hive?panelId=7&fullscreen&orgId=1&var-instance=an-coord1003:10100 - https://alerts.wikimedia.org/?q=alertname%3DHiveServerHeapUsage [20:49:55] (03CR) 10Mforns: "Looks great! I'm so happy this is looking finished!" [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1016796 (https://phabricator.wikimedia.org/T358681) (owner: 10Xcollazo) [21:06:53] 10Data-Engineering (Q4 2024 April 1st - June 30th), 06Data-Platform, 13Patch-For-Review: Unique devices tables have missing or incorrect data for January and February 2024 - https://phabricator.wikimedia.org/T361242#9711013 (10Mayakp.wiki) > Observed results: >Querying the daily sum of unique devices across... [21:07:30] 10Data-Engineering (Q4 2024 April 1st - June 30th), 06Data-Platform, 13Patch-For-Review: Unique devices tables have missing or incorrect data for January and February 2024 - https://phabricator.wikimedia.org/T361242#9711014 (10Mayakp.wiki) [21:43:47] (03CR) 10Milimetric: Productionize CommonsCategoryGraphBuilder for CIM project (032 comments) [analytics/refinery/source] - 10https://gerrit.wikimedia.org/r/1015013 (https://phabricator.wikimedia.org/T358681) (owner: 10Mforns) [22:06:09] (03PS2) 10Aleksandar Mastilovic: Browser report queries updates [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1018365 [22:10:42] (03CR) 10Aleksandar Mastilovic: "Done! I've manually tested all of the queries, too - some were missing the INSERT INTO statements, some needed an identifier in ORDER BY i" [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1018365 (owner: 10Aleksandar Mastilovic) [22:58:08] (03PS3) 10Aleksandar Mastilovic: WMCS HQL scripts [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1017161 [22:58:08] (03PS2) 10Aleksandar Mastilovic: WMCS unpivoted data HQL script [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1018331 [22:58:08] (03PS1) 10Aleksandar Mastilovic: Corrected version of pingback's version.hql [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1019363 [22:59:21] (03CR) 10Aleksandar Mastilovic: [V:03+2 C:03+2] "Verified and approved. Added a corrected version of pingback's version.hql script, too." [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1019363 (owner: 10Aleksandar Mastilovic) [22:59:57] (03CR) 10Aleksandar Mastilovic: [V:03+2 C:03+2] WMCS unpivoted data HQL script [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1018331 (owner: 10Aleksandar Mastilovic) [23:53:59] 10Data-Engineering (Q4 2024 April 1st - June 30th), 06Data-Platform, 13Patch-For-Review: Unique devices tables have missing or incorrect data for January and February 2024 - https://phabricator.wikimedia.org/T361242#9711261 (10odimitrijevic) p:05Triage→03High