[10:12:33] 06Data-Engineering, 06Data-Platform-SRE, 06Discovery-Search, 07IPv6: Some Search clusters have inconsistent AAAA DNS records for the primary IPv6 of the hosts - https://phabricator.wikimedia.org/T312555#10017468 (10BTullis) For the dumpsdata and snapshot hosts, there is now only one host of each type in th... [10:17:16] 06Data-Engineering, 06Data-Platform-SRE, 06DC-Ops, 10ops-eqiad, 06SRE: Degraded RAID on dumpsdata1007 - https://phabricator.wikimedia.org/T369829#10017476 (10BTullis) Hi @Jclark-ctr - Yes, this drive can be replaced at any time. Thanks. [12:56:02] 06Data-Engineering, 03Discovery-Search (Current work), 10MW-1.43-notes (1.43.0-wmf.14; 2024-07-16), 07Wikimedia-production-error: '.event.pageViewId' should be string, '.event.subTest' should be string, '.event.searchSessionId' should be string - https://phabricator.wikimedia.org/T286814#10017766 (10pfische... [13:42:29] 10Data-Engineering (Q1 2024 July 1st - September 30th), 06Data Products, 10Metrics Platform Backlog: [MPIC] Analyse risk of potential performance issues with static approach to stream configuration - https://phabricator.wikimedia.org/T366627#10017828 (10VirginiaPoundstone) > Queries filtering for a small exp... [14:38:05] (03PS1) 10Dreamy Jazz: Don't select cuc_actiontext from cu_changes for sqoop [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1057221 (https://phabricator.wikimedia.org/T324907) [14:41:05] 07Analytics-Data-Problem: No longer use removed cuc_actiontext column in analytics/refinery - https://phabricator.wikimedia.org/T371099 (10Dreamy_Jazz) 03NEW [14:42:49] (03PS2) 10Dreamy Jazz: Don't select cuc_actiontext from cu_changes for sqoop [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1057221 (https://phabricator.wikimedia.org/T371099) [14:42:50] 07Analytics-Data-Problem: No longer use removed cuc_actiontext column in analytics/refinery - https://phabricator.wikimedia.org/T371099#10018090 (10Dreamy_Jazz) [14:46:47] 06Data-Engineering, 13Patch-For-Review: No longer use removed cuc_actiontext column in analytics/refinery - https://phabricator.wikimedia.org/T371099#10018119 (10Dreamy_Jazz) [14:47:35] 06Data-Engineering, 10CheckUser, 06Data Products, 06DBA, 07Schema-change-in-production: Remove cuc_actiontext, cuc_only_for_read_old, and cuc_private from cu_changes on WMF wikis - https://phabricator.wikimedia.org/T370903#10018115 (10Dreamy_Jazz) I'm not sure if T371099 needs to be resolved before this... [14:49:23] 06Data-Engineering, 13Patch-For-Review, 10Trust and Safety Product Sprint (Sprint Koto (July 15 - July 26)): No longer use removed cuc_actiontext column in analytics/refinery - https://phabricator.wikimedia.org/T371099#10018142 (10Dreamy_Jazz) [14:50:47] 06Data-Engineering, 13Patch-For-Review, 10Trust and Safety Product Sprint (Sprint Koto (July 15 - July 26)): No longer use removed cuc_actiontext column in analytics/refinery - https://phabricator.wikimedia.org/T371099#10018146 (10Dreamy_Jazz) [16:10:17] 06Data-Engineering: service-utils helper for trace header propagation - https://phabricator.wikimedia.org/T371120 (10CDanis) 03NEW [16:10:33] 06Data-Engineering: service-utils helper for trace header propagation - https://phabricator.wikimedia.org/T371120#10018626 (10CDanis) [16:10:43] 06Data-Engineering, 10Observability-Tracing: service-utils helper for trace header propagation - https://phabricator.wikimedia.org/T371120#10018628 (10CDanis) [16:12:55] 06Data-Engineering, 06Data Products, 10Pageviews-API: Missed pageview data over API - https://phabricator.wikimedia.org/T370108#10018633 (10VirginiaPoundstone) @Mayakp.wiki have you seen any other similar edge cases? [16:14:07] 06Data-Engineering, 06DBA, 07Schema-change-in-production: Drop gb_by from globalblocks table - https://phabricator.wikimedia.org/T370394#10018655 (10VirginiaPoundstone) Thank you @Milimetric for reviewing. I will untag Data Products since there seem to be no dependencies for us. [16:17:33] 06Data-Engineering, 10CheckUser, 06Data Products, 06DBA, 07Schema-change-in-production: Remove cuc_actiontext, cuc_only_for_read_old, and cuc_private from cu_changes on WMF wikis - https://phabricator.wikimedia.org/T370903#10018675 (10VirginiaPoundstone) @Ottomata any dependencies for data platform on th... [16:30:25] 06Data-Engineering, 06Data-Platform-SRE: request for new matomo site - https://phabricator.wikimedia.org/T371124 (10CDanis) 03NEW [16:30:41] 06Data-Engineering, 06Data-Platform-SRE: request for new matomo site - https://phabricator.wikimedia.org/T371124#10018755 (10CDanis) [16:39:20] 10Data-Engineering (Q1 2024 July 1st - September 30th): Replace service runner with a simplified library to better support metrics and debugging: service-utils - https://phabricator.wikimedia.org/T360924#10018790 (10CDanis) [16:39:21] 06Data-Engineering, 10Observability-Tracing: service-utils helper for trace header propagation - https://phabricator.wikimedia.org/T371120#10018789 (10CDanis) [17:52:39] 06Data-Engineering, 06Data-Platform-SRE, 06DC-Ops, 10ops-eqiad, 06SRE: Degraded RAID on dumpsdata1007 - https://phabricator.wikimedia.org/T369829#10019010 (10Jclark-ctr) 05Open→03Resolved Replaced Failed Drive [18:16:03] 06Data-Engineering, 10Observability-Tracing: service-utils helper for trace header propagation - https://phabricator.wikimedia.org/T371120#10019050 (10CDanis) [18:16:25] 10Data-Engineering (Q1 2024 July 1st - September 30th), 06Data Products, 10Metrics Platform Backlog: [MPIC] Analyse risk of potential performance issues with static approach to stream configuration - https://phabricator.wikimedia.org/T366627#10019052 (10Ottomata) > it adds 4 seconds on top of an existing bas... [18:17:11] 10Data-Engineering (Q1 2024 July 1st - September 30th), 06Data Products, 10Metrics Platform Backlog: [MPIC] Analyse risk of potential performance issues with static approach to stream configuration - https://phabricator.wikimedia.org/T366627#10019054 (10Ottomata) > I'm looking for an estimated total times.... [18:21:46] 14Data-Engineering (Q4 2024 April 1st - June 30th), 10Wikidata, 10Wikidata Analytics: [Bug?] Can't find wikidatawiki on wmf.mediawiki_wikitext_history - https://phabricator.wikimedia.org/T364045#10019074 (10Milimetric) Ok, this ended up being very involved. I believe the root of all the confusion is that al... [18:23:12] 10Data-Engineering (Q1 2024 July 1st - September 30th), 06Data Products, 10Metrics Platform Backlog: [MPIC] Analyse risk of potential performance issues with static approach to stream configuration - https://phabricator.wikimedia.org/T366627#10019077 (10Ottomata) Hm, I wonder if filtering on a [[ https://med... [18:30:12] 14Data-Engineering (Q4 2024 April 1st - June 30th), 10Wikidata, 10Wikidata Analytics: [Bug?] Can't find wikidatawiki on wmf.mediawiki_wikitext_history - https://phabricator.wikimedia.org/T364045#10019104 (10Milimetric) manually running this in a screen on an-launcher1002: ` sudo -u analytics kerberos-run-co... [19:16:09] 10Data-Engineering (Q1 2024 July 1st - September 30th), 06Data Products, 10Metrics Platform Backlog: [MPIC] Analyse risk of potential performance issues with static approach to stream configuration - https://phabricator.wikimedia.org/T366627#10019310 (10Ottomata) I just tried the same queries on a unified ta...