[01:16:49] 14Analytics, 06Data-Engineering, 06Test Kitchen: Count the number of video plays - https://phabricator.wikimedia.org/T198628#11506013 (10Yaron_Koren) @TheDJ - alright, I changed most of the SQL calls in the code (including all of the INSERT calls) into prepared statements; thanks for the suggestion. I also... [06:31:56] 06Data-Engineering, 06DBA, 07Schema-change-in-production: Add il_target_id to imagelinks table in wmf production - https://phabricator.wikimedia.org/T413525#11506173 (10Marostegui) [06:53:06] 06Data-Engineering, 06DBA, 07Schema-change-in-production: Add il_target_id to imagelinks table in wmf production - https://phabricator.wikimedia.org/T413525#11506194 (10Marostegui) [07:30:38] 06Data-Engineering, 06SRE, 10SRE-Access-Requests: Grant Access to analytics-privatedata-users for kareid - https://phabricator.wikimedia.org/T413364#11506251 (10Dzahn) Since the request is described as "access and update dashboards", Hadoop is not mentioned and per: https://wikitech.wikimedia.org/wiki/Data_... [11:41:57] 06Data-Engineering, 06DBA, 10GlobalBlocking, 06Product Safety and Integrity, and 2 others: Remove default value from gbw_by in global_block_whitelist table on WMF wikis - https://phabricator.wikimedia.org/T414183 (10Dreamy_Jazz) 03NEW [11:44:57] 06Data-Engineering, 10MediaWiki-extensions-EventLogging, 06Test Kitchen, 07Essential-Work, 07Technical-Debt: Migrate 1 instrument using mw.eventLog.newInstrument() to mw.xLab.getInstrument() - https://phabricator.wikimedia.org/T408096#11506953 (10Sgs) GrowthExperiments has at least one use-case for this... [12:18:39] 06Data-Engineering, 06DBA, 10GlobalBlocking, 06Product Safety and Integrity, and 2 others: Remove default value from gbw_by in global_block_whitelist table on WMF wikis - https://phabricator.wikimedia.org/T414183#11507144 (10Marostegui) [12:19:43] 06Data-Engineering, 06DBA, 10GlobalBlocking, 06Product Safety and Integrity, and 2 others: Remove default value from gbw_by in global_block_whitelist table on WMF wikis - https://phabricator.wikimedia.org/T414183#11507156 (10Marostegui) p:05Triage→03Medium a:03Marostegui [12:21:59] 06Data-Engineering, 06DBA, 07Schema-change-in-production: Add il_target_id to imagelinks table in wmf production - https://phabricator.wikimedia.org/T413525#11507164 (10Marostegui) [12:32:27] 06Data-Engineering, 06DBA, 10GlobalBlocking, 06Product Safety and Integrity, and 2 others: Remove default value from gbw_by in global_block_whitelist table on WMF wikis - https://phabricator.wikimedia.org/T414183#11507240 (10Marostegui) [12:37:28] 06Data-Engineering, 06DBA, 10GlobalBlocking, 06Product Safety and Integrity, and 2 others: Remove default value from gbw_by in global_block_whitelist table on WMF wikis - https://phabricator.wikimedia.org/T414183#11507251 (10Marostegui) [13:03:10] 06Data-Engineering, 06DBA, 10GlobalBlocking, 06Product Safety and Integrity, and 2 others: Remove default value from gbw_by in global_block_whitelist table on WMF wikis - https://phabricator.wikimedia.org/T414183#11507355 (10Marostegui) [13:03:37] 06Data-Engineering, 06DBA, 10GlobalBlocking, 06Product Safety and Integrity, and 2 others: Remove default value from gbw_by in global_block_whitelist table on WMF wikis - https://phabricator.wikimedia.org/T414183#11507357 (10Marostegui) [13:04:32] 06Data-Engineering, 06DBA, 10GlobalBlocking, 06Product Safety and Integrity, and 2 others: Remove default value from gbw_by in global_block_whitelist table on WMF wikis - https://phabricator.wikimedia.org/T414183#11507362 (10Marostegui) [13:05:14] 06Data-Engineering, 06DBA, 10GlobalBlocking, 06Product Safety and Integrity, and 2 others: Remove default value from gbw_by in global_block_whitelist table on WMF wikis - https://phabricator.wikimedia.org/T414183#11507378 (10Marostegui) s4 is done, but a couple of replicas (one in codfw and one in eqiad) w... [13:09:45] 06Data-Engineering, 06DBA, 10GlobalBlocking, 06Product Safety and Integrity, and 2 others: Remove default value from gbw_by in global_block_whitelist table on WMF wikis - https://phabricator.wikimedia.org/T414183#11507388 (10Marostegui) [13:12:42] 06Data-Engineering (Q3 FY25/26 January 1st - March 31th): duplicated page_title in mediawiki_content_current_v1 - https://phabricator.wikimedia.org/T413888#11507397 (10xcollazo) >>! In T413888#11504711, @APizzata-WMF wrote: >>Great find! I think I see the root cause now, but I will let you play with it more and... [13:13:04] 06Data-Engineering, 06DBA, 10GlobalBlocking, 06Product Safety and Integrity, and 2 others: Remove default value from gbw_by in global_block_whitelist table on WMF wikis - https://phabricator.wikimedia.org/T414183#11507398 (10Marostegui) s3 is on-going, it will take a few hours. [14:05:49] 06Data-Engineering, 10Data-Platform, 06Data-Platform-SRE, 06Wikimedia Enterprise: Provide auth-less access to Enterprise APIs from WMF Analytics cluster - https://phabricator.wikimedia.org/T403298#11507539 (10HShaikh) @fkaelin the code for structured contents is avaialble for viewing here in the public gi... [14:30:09] !log Test Kitchen edge-unique experiments (poll 131996) - adds: none; removes: sticky-headers; fields: none - xLab/MPIC/TK tips at https://w.wiki/FwuD [14:30:11] Logged the message at https://www.mediawiki.org/wiki/Analytics/Server_Admin_Log [14:41:59] 06Data-Engineering, 10Data-Platform, 06Data-Platform-SRE, 06Wikimedia Enterprise: Provide auth-less access to Enterprise APIs from WMF Analytics cluster - https://phabricator.wikimedia.org/T403298#11507657 (10Isaac) > Based on the summary, it seems that either (A) or (C) are the right next step. Considerin... [15:48:43] 06Data-Engineering, 06DBA, 10GlobalBlocking, 06Product Safety and Integrity, and 2 others: Create gb_target in globalblocks table - https://phabricator.wikimedia.org/T414211 (10Dreamy_Jazz) 03NEW [15:51:54] 06Data-Engineering, 06DBA, 10GlobalBlocking, 06Product Safety and Integrity, and 2 others: Create gb_target in globalblocks table - https://phabricator.wikimedia.org/T414211#11507958 (10Dreamy_Jazz) Would appreciate any #dba feedback on this, especially about the datatype being used for `gb_target` (as we... [15:52:54] 06Data-Engineering, 06DBA, 10GlobalBlocking, 06Product Safety and Integrity, and 2 others: Create gb_target in globalblocks table - https://phabricator.wikimedia.org/T414211#11507963 (10Dreamy_Jazz) [17:09:56] 06Data-Engineering, 10MediaWiki-extensions-EventLogging, 06Test Kitchen, 07Epic, and 2 others: [EPIC] Deprecate and remove mw.eventLog.newInstrument() - https://phabricator.wikimedia.org/T408091#11508205 (10phuedx) [17:19:46] !log Test Kitchen edge-unique experiments (poll 132501) - adds: synth-aa-test-traffic-impact; removes: none; fields: none - xLab/MPIC/TK tips at https://w.wiki/FwuD [17:19:48] Logged the message at https://www.mediawiki.org/wiki/Analytics/Server_Admin_Log [18:10:30] 06Data-Engineering (Q3 FY25/26 January 1st - March 31th): Fix reconcile bug where user_id is not being populated correctly. - https://phabricator.wikimedia.org/T411803#11508481 (10xcollazo) >>! In T411803#11503785, @xcollazo wrote: > Now retrying `spark_process_reconciliation_events ` for 2025-12-14 with `pushdo... [18:14:06] 06Data-Engineering, 06DBA, 10GlobalBlocking, 06Product Safety and Integrity, and 2 others: Remove default value from gbw_by in global_block_whitelist table on WMF wikis - https://phabricator.wikimedia.org/T414183#11508491 (10Marostegui) [18:14:14] 06Data-Engineering, 06DBA, 10GlobalBlocking, 06Product Safety and Integrity, and 2 others: Remove default value from gbw_by in global_block_whitelist table on WMF wikis - https://phabricator.wikimedia.org/T414183#11508493 (10Marostegui) 05Open→03Resolved This is done [18:17:12] 06Data-Engineering, 06DBA, 10GlobalBlocking, 06Product Safety and Integrity, and 2 others: Remove default value from gbw_by in global_block_whitelist table on WMF wikis - https://phabricator.wikimedia.org/T414183#11508505 (10Dreamy_Jazz) Thanks [18:17:35] 06Data-Engineering, 06DBA, 10GlobalBlocking, 06Product Safety and Integrity, and 2 others: Remove default value from gbw_by in global_block_whitelist table on WMF wikis - https://phabricator.wikimedia.org/T414183#11508508 (10Dreamy_Jazz) [18:35:23] 06Data-Engineering, 06DBA, 10GlobalBlocking, 06Product Safety and Integrity, and 2 others: Create gb_target in globalblocks table - https://phabricator.wikimedia.org/T414211#11508589 (10Dreamy_Jazz) [20:50:58] 06Data-Engineering (Q3 FY25/26 January 1st - March 31th): Fix reconcile bug where user_id is not being populated correctly. - https://phabricator.wikimedia.org/T411803#11508804 (10xcollazo) Now running `mw_content_reconcile_mw_content_history_monthly` to see where were at. [[ https://airflow.wikimedia.org/dags/... [23:10:19] (03PS1) 10Gerrit maintenance bot: Add kai.wikipedia to pageview allowlist [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1225039 (https://phabricator.wikimedia.org/T414237)