[00:44:49] (03PS1) 10Gerrit maintenance bot: Add zgh.wiktionary to pageview allowlist [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1170221 (https://phabricator.wikimedia.org/T399785) [03:19:25] FIRING: [2x] AlertLintProblem: Linting problems found for HaproxyKafkaDeliveryErrors - https://wikitech.wikimedia.org/wiki/Alertmanager#Alert_linting_found_problems - TODO - https://alerts.wikimedia.org/?q=alertname%3DAlertLintProblem [03:29:43] 06Data-Engineering, 06Data-Engineering-Radar, 10Dumps-Generation, 06MediaWiki-Platform-Team, 06serviceops: Migrate WMF production from PHP 7.4 to PHP 8.1 - https://phabricator.wikimedia.org/T319432#11011720 (10Krinkle) [03:35:17] 06Data-Engineering, 06Data-Engineering-Radar, 10Dumps-Generation, 06MediaWiki-Platform-Team, 06serviceops: Migrate WMF production from PHP 7.4 to PHP 8.1 - https://phabricator.wikimedia.org/T319432#11011722 (10Novem_Linguae) Looks like we've ticked most the boxes and resolved most the subtasks. Might be... [04:56:13] 06Data-Engineering, 06Data-Engineering-Radar, 10Dumps-Generation, 06MediaWiki-Platform-Team, 06serviceops: Migrate WMF production from PHP 7.4 to PHP 8.1 - https://phabricator.wikimedia.org/T319432#11011816 (10Krinkle) [06:05:45] 06Data-Engineering, 06Data-Engineering-Radar, 10CheckUser, 06DBA, and 2 others: Add '*_actor_ip_hex_time' indexes to 'cu_changes', 'cu_log_event', and 'cu_private_event' on WMF wikis - https://phabricator.wikimedia.org/T399728#11011845 (10Marostegui) p:05Triage→03Medium a:03FCeratto-WMF Could you wor... [07:19:25] FIRING: [2x] AlertLintProblem: Linting problems found for HaproxyKafkaDeliveryErrors - https://wikitech.wikimedia.org/wiki/Alertmanager#Alert_linting_found_problems - TODO - https://alerts.wikimedia.org/?q=alertname%3DAlertLintProblem [07:34:40] 06Data-Engineering, 06DBA, 07Schema-change-in-production: Add cl_timestamp_id index to categorylinks table - https://phabricator.wikimedia.org/T399249#11012015 (10Marostegui) [07:51:03] 14Analytics-Radar, 06Data-Engineering-Radar, 10TimedMediaHandler, 07Video: Record and report metrics for audio and video playback - https://phabricator.wikimedia.org/T108522#11012046 (10TheDJ) [07:53:05] 14Analytics, 06Data-Engineering, 06Data-Engineering-Icebox: Count the number of video plays - https://phabricator.wikimedia.org/T198628#11012051 (10TheDJ) @AndrewTavis_WMDE just a note, that browsers can preload video. So request data does not necessarily correlate to an actual view. [07:59:54] 06Data-Engineering, 06Data-Engineering-Radar, 10Dumps-Generation, 06MediaWiki-Platform-Team, 06serviceops: Migrate WMF production from PHP 7.4 to PHP 8.1 - https://phabricator.wikimedia.org/T319432#11012061 (10jijiki) [08:00:50] 06Data-Engineering, 06Data-Engineering-Radar, 10Dumps-Generation, 06MediaWiki-Platform-Team, 06serviceops: Migrate WMF production from PHP 7.4 to PHP 8.1 - https://phabricator.wikimedia.org/T319432#11012072 (10jijiki) [09:15:42] 14Analytics, 06Data-Engineering, 06Data-Engineering-Icebox: Count the number of video plays - https://phabricator.wikimedia.org/T198628#11012411 (10AndrewTavis_WMDE) Thanks for checking in here, @TheDJ 👋 Can we check the conditions with you, as as I understood it the approach we'd taken was getting around th... [10:07:08] 06Data-Engineering, 06Data-Platform-SRE, 07Epic: Upgrade Hadoop to version 3.3.6 and Hive to version 4.0.1 - https://phabricator.wikimedia.org/T379385#11012540 (10BTullis) [11:19:25] FIRING: [2x] AlertLintProblem: Linting problems found for HaproxyKafkaDeliveryErrors - https://wikitech.wikimedia.org/wiki/Alertmanager#Alert_linting_found_problems - TODO - https://alerts.wikimedia.org/?q=alertname%3DAlertLintProblem [12:16:39] 14Analytics, 06Data-Engineering, 06Data-Engineering-Icebox: Count the number of video plays - https://phabricator.wikimedia.org/T198628#11012993 (10TheDJ) Can you give examples of these requests that we are filtering? If they are directly on the video, are you only checking requests that have the Range heade... [12:35:48] 14Analytics, 06Data-Engineering, 06Data-Engineering-Icebox: Count the number of video plays - https://phabricator.wikimedia.org/T198628#11013053 (10TheDJ) Additional note. If you also count the thumbnail poster downloads of videos, then by combining these numbers, You can give a rough estimate of the click t... [13:07:41] (03CR) 10Hasan Akgün (WMDE): [C:03+2] Use WikimediaDbList more consistently [analytics/wmde/scripts] - 10https://gerrit.wikimedia.org/r/1163315 (owner: 10Lucas Werkmeister (WMDE)) [13:08:14] (03Merged) 10jenkins-bot: Use WikimediaDbList more consistently [analytics/wmde/scripts] - 10https://gerrit.wikimedia.org/r/1163315 (owner: 10Lucas Werkmeister (WMDE)) [13:08:40] (03CR) 10Hasan Akgün (WMDE): [C:03+2] Remove Facebook, IRC and Twitter social metrics [analytics/wmde/scripts] - 10https://gerrit.wikimedia.org/r/734898 (https://phabricator.wikimedia.org/T294014) (owner: 10Lucas Werkmeister (WMDE)) [13:08:41] (03PS3) 10Lucas Werkmeister (WMDE): Remove Facebook, IRC and Twitter social metrics [analytics/wmde/scripts] - 10https://gerrit.wikimedia.org/r/734898 (https://phabricator.wikimedia.org/T294014) [13:09:08] (03PS1) 10Lucas Werkmeister (WMDE): Use WikimediaDbList more consistently [analytics/wmde/scripts] - 10https://gerrit.wikimedia.org/r/1170338 [13:09:12] (03CR) 10Lucas Werkmeister (WMDE): [C:03+2] Use WikimediaDbList more consistently [analytics/wmde/scripts] - 10https://gerrit.wikimedia.org/r/1170338 (owner: 10Lucas Werkmeister (WMDE)) [13:09:42] (03Merged) 10jenkins-bot: Use WikimediaDbList more consistently [analytics/wmde/scripts] - 10https://gerrit.wikimedia.org/r/1170338 (owner: 10Lucas Werkmeister (WMDE)) [13:10:06] (03CR) 10Lucas Werkmeister (WMDE): [C:03+2] "poke Zuul after rebase" [analytics/wmde/scripts] - 10https://gerrit.wikimedia.org/r/734898 (https://phabricator.wikimedia.org/T294014) (owner: 10Lucas Werkmeister (WMDE)) [13:10:38] (03Merged) 10jenkins-bot: Remove Facebook, IRC and Twitter social metrics [analytics/wmde/scripts] - 10https://gerrit.wikimedia.org/r/734898 (https://phabricator.wikimedia.org/T294014) (owner: 10Lucas Werkmeister (WMDE))