[06:05:53] 06Data-Engineering (Q4 FS25/26 April 1st - June 30st): dbt-jobs backfill: all base models for moderator actions - https://phabricator.wikimedia.org/T429995#12088685 (10JMonton-WMF) After https://gitlab.wikimedia.org/repos/data-engineering/dbt-jobs/-/merge_requests/130 I'm running now: ` start_date=2020-07-01 su... [07:04:14] 06Data-Engineering (Q4 FS25/26 April 1st - June 30st), 10Event-Platform: Relative Trending - Milestone 3 - K8s resources - https://phabricator.wikimedia.org/T430136#12088753 (10brouberol) [07:07:38] 06Data-Engineering (Q4 FS25/26 April 1st - June 30st), 10DPE-MediaWiki-Incremental-History: Review remaining 90-day windows in MWHistoryDeltaWriter - https://phabricator.wikimedia.org/T428961#12088756 (10APizzata-WMF) Here are the results without the bound 2: ` +--------------------------------+--------+-----... [07:49:55] 06Data-Engineering, 06Machine-Learning-Team: EventStreams - Expose mediawiki.page_outlink_topic_prediction_change.v1 stream - https://phabricator.wikimedia.org/T427416#12088882 (10isarantopoulos) [07:50:30] 06Data-Engineering, 06Data-Engineering-Radar, 06Machine-Learning-Team, 10Event-Platform: Add Multilingual RevertRisk predictions to mediawiki.page_revert_risk_prediction_change - https://phabricator.wikimedia.org/T415892#12088892 (10isarantopoulos) [07:53:25] (03CR) 10Joal: [C:03+1] "One non blocking nit :)" [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1306491 (https://phabricator.wikimedia.org/T430020) (owner: 10KCVelaga) [08:02:52] 06Data-Engineering, 06Product-Analytics: Add cache_status to pageview_actor table - https://phabricator.wikimedia.org/T431246 (10KCVelaga_WMF) 03NEW [08:03:12] 06Data-Engineering, 06Product-Analytics: Add cache_status to pageview_actor table - https://phabricator.wikimedia.org/T431246#12088991 (10KCVelaga_WMF) [08:06:33] (03PS3) 10KCVelaga: DDL for wmf_traffic.user_agents_info table. [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1306491 (https://phabricator.wikimedia.org/T430020) [08:11:51] (03CR) 10KCVelaga: DDL for wmf_traffic.user_agents_info table. (031 comment) [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1306491 (https://phabricator.wikimedia.org/T430020) (owner: 10KCVelaga) [08:13:55] 06Data-Engineering, 10Dumps-Generation: Missing XML / Content File Exports July 2026 - https://phabricator.wikimedia.org/T431189#12089021 (10jberkel) The content file export link is now available, the old location (https://dumps.wikimedia.org/enwiktionary/20260701/) is not. [08:17:07] 06Data-Engineering: Add user_agent raw string to pageview_actor and pageview_hourly - https://phabricator.wikimedia.org/T431249 (10KCVelaga_WMF) 03NEW [08:20:07] 06Data-Engineering, 06SRE, 06Data-Platform-SRE (2026-07-03 - 2026-07-31), 07Sustainability (Incident Followup): The webrequest_sampled_live data pipeline and its query tools have become mission-critical and require re-engineering for resilience - https://phabricator.wikimedia.org/T431112#12089050 (10Gehel)... [08:51:07] 06Data-Engineering, 06SRE, 06Data-Platform-SRE (2026-07-03 - 2026-07-31), 07Sustainability (Incident Followup): The webrequest_sampled_live data pipeline and its query tools have become mission-critical and require re-engineering for resilience - https://phabricator.wikimedia.org/T431112#12089173 (10elukey... [09:04:26] 06Data-Engineering: Add user_agent raw string to pageview_actor and pageview_hourly - https://phabricator.wikimedia.org/T431249#12089206 (10GGoncalves-WMF) Can you please expand on the "track activity" part? I'd like to understand what we need to measure here so we can find the best table(s) to create and change... [09:30:04] 06Data-Engineering (Q4 FS25/26 April 1st - June 30st), 06Traffic: Add X-Provene - https://phabricator.wikimedia.org/T431256 (10JAllemandou) 03NEW [09:32:33] 06Data-Engineering (Q1 FS26/27 July 1st - September 30th), 06Traffic: Add X-Provenance to `wmf.webrequest` - https://phabricator.wikimedia.org/T431256#12089320 (10JAllemandou) [09:32:46] 06Data-Engineering (Q1 FS26/27 July 1st - September 30th), 06Traffic: Add X-Provenance to `wmf.webrequest` - https://phabricator.wikimedia.org/T431256#12089324 (10JAllemandou) a:05Ahoelzl→03JAllemandou [10:28:27] 06Data-Engineering, 10Dumps-Generation, 10Wikidata: No wikidata dumps this week (20250630) - https://phabricator.wikimedia.org/T398756#12089636 (10brouberol) [10:28:50] 06Data-Engineering, 06Data-Platform-SRE, 10Dumps-Generation: wikidatawiki.dump_remaining never completes in time - https://phabricator.wikimedia.org/T431267#12089639 (10brouberol) [10:36:11] 06Data-Engineering, 06Data-Platform-SRE, 10Dumps-Generation: wikidatawiki.dump_remaining never completes in time - https://phabricator.wikimedia.org/T431267#12089674 (10brouberol) [10:36:15] 06Data-Engineering, 06Data-Platform-SRE, 10Dumps-Generation: wikidatawiki.dump_remaining never completes in time - https://phabricator.wikimedia.org/T431267#12089675 (10brouberol) [10:37:21] !log Test Kitchen experiment (poll 144773) - adds: none; removes: none; fields: we-1-8-tempuser-post-edit, we-1-8-tempuser-post-edit, we-1-8-tempuser-post-edit - TK tips at https://w.wiki/_cvdP [10:37:24] Logged the message at https://www.mediawiki.org/wiki/Analytics/Server_Admin_Log [11:41:53] 06Data-Engineering, 06Product-Analytics: Dbt backfill: signal_driven_handling_bad_faith_accounts - https://phabricator.wikimedia.org/T431279 (10cchen) 03NEW [11:52:37] 06Data-Engineering, 10Dumps-Generation, 06Data-Platform-SRE (2026-07-03 - 2026-07-31): wikidatawiki.dump_remaining never completes in time - https://phabricator.wikimedia.org/T431267#12089972 (10brouberol) [11:52:38] 06Data-Engineering, 10Dumps-Generation, 06Data-Platform-SRE (2026-07-03 - 2026-07-31): wikidatawiki.dump_remaining never completes in time - https://phabricator.wikimedia.org/T431267#12089973 (10brouberol) 05Open→03In progress [13:28:51] 06Data-Engineering, 10Dumps-Generation, 06Data-Platform-SRE (2026-07-03 - 2026-07-31): wikidatawiki.dump_remaining never completes in time - https://phabricator.wikimedia.org/T431267#12090425 (10brouberol) The patch has been deployed. We'll need to wait until the `wikidatawiki.dump_remaining` task starts to... [14:44:41] 06Data-Engineering (Q4 FS25/26 April 1st - June 30st): WE5.3.3b: Contributor Count Per Page [Attribution API] - https://phabricator.wikimedia.org/T426316#12090815 (10AKhatun_WMF) [14:54:12] 06Data-Engineering, 06SRE, 06Data-Platform-SRE (2026-07-03 - 2026-07-31), 07Sustainability (Incident Followup): The webrequest_sampled_live data pipeline and its query tools have become mission-critical and require re-engineering for resilience - https://phabricator.wikimedia.org/T431112#12090840 (10BTullis... [16:08:40] 06Data-Engineering, 06SRE, 06Data-Platform-SRE (2026-07-03 - 2026-07-31), 07Sustainability (Incident Followup): The webrequest_sampled_live data pipeline and its query tools have become mission-critical and require re-engineering for resilience - https://phabricator.wikimedia.org/T431112#12091106 (10elukey... [16:17:12] 06Data-Engineering, 06SRE, 06Data-Platform-SRE (2026-07-03 - 2026-07-31), 07Sustainability (Incident Followup): The webrequest_sampled_live data pipeline and its query tools have become mission-critical and require re-engineering for resilience - https://phabricator.wikimedia.org/T431112#12091128 (10CDanis... [16:21:36] 06Data-Engineering (Q4 FS25/26 April 1st - June 30st): Dbt backfill: editor_month and base_account_registration - https://phabricator.wikimedia.org/T430602#12091142 (10amastilovic) @nshahquinn-wmf yes, if the model table already exists then we run into problems. I'll check what happened today and re-submit the b... [16:28:07] 06Data-Engineering: Productionize the updates to the wmf_traffic.browser_info table - https://phabricator.wikimedia.org/T431317 (10mforns) 03NEW [16:28:26] 06Data-Engineering: Productionize the updates to the wmf_traffic.browser_info table - https://phabricator.wikimedia.org/T431317#12091170 (10mforns) [16:28:30] 10Data-Engineering-Roadmap, 07Epic: [Epic] KAPOW: The next generation of bot detection in the Data Platform. - https://phabricator.wikimedia.org/T425661#12091171 (10mforns) [16:58:04] 06Data-Engineering, 10Dumps-Generation: Missing XML / Content File Exports July 2026 - https://phabricator.wikimedia.org/T431189#12091228 (10jberkel) 05Open→03Resolved a:03jberkel both are now present [17:13:41] 06Data-Engineering (Q1 FS26/27 July 1st - September 30th): Fix `filerevision` sqoop job - https://phabricator.wikimedia.org/T431318 (10JAllemandou) 03NEW [17:13:49] 06Data-Engineering (Q1 FS26/27 July 1st - September 30th): Fix `filerevision` sqoop job - https://phabricator.wikimedia.org/T431318#12091283 (10JAllemandou) a:03JAllemandou [18:13:49] 06Data-Engineering (Q1 FS26/27 July 1st - September 30th): Polish signal_driven_handling_bad_faith_accounts.sql model - https://phabricator.wikimedia.org/T431331 (10amastilovic) 03NEW [18:35:05] !log Test Kitchen experiment (poll 147620) - adds: we-1-10-articleguidance-v1; removes: none; fields: none - TK tips at https://w.wiki/_cvdP [18:35:07] Logged the message at https://www.mediawiki.org/wiki/Analytics/Server_Admin_Log [18:41:38] 06Data-Engineering, 10MediaWiki-Logevents, 10MediaWiki-User-management, 06Stewards-and-global-tools, and 3 others: User right log doesn't tally on a wiki and Meta - https://phabricator.wikimedia.org/T431176#12091594 (10Pppery) [19:09:38] 06Data-Engineering, 10Dumps-Generation: Recently edited pages are not included in MediaWiki Content File Exports - https://phabricator.wikimedia.org/T431339 (10JeffDoozan) 03NEW [19:56:48] 10Analytics-Canonical-Data: Fetch base wiki data from SiteMatrix or similar - https://phabricator.wikimedia.org/T405960#12091947 (10nshahquinn-wmf) The missing data for a new wiki just triggered alerts that DPE had to triage (`mw_content_reconcile_mw_content_history_daily` had rows for isvwiki with an empty doma... [21:38:15] FIRING: HdfsCapacityRemainingPercent: Alarmingly low free space on the analytics-hadoop HDFS cluster. - https://wikitech.wikimedia.org/wiki/Analytics/Systems/Cluster/Hadoop/Alerts#HDFS_Capacity_Remaining - https://grafana.wikimedia.org/d/000000585/hadoop?var-hadoop_cluster=analytics-hadoop&orgId=1&panelId=106&fullscreen - https://alerts.wikimedia.org/?q=alertname%3DHdfsCapacityRemainingPercent [21:50:28] 06Data-Engineering, 10Commons-Impact-Metrics, 10Commons-Impact-Metrics-Requests: Update Commons Impact Metrics allow-list June 2026 - https://phabricator.wikimedia.org/T430008#12092328 (10GFontenelle_WMF) 05Open→03Resolved