[10:31:03] 10Quarry, 10Data-Services, 10cloud-services-team (FY2023/2024-Q3-Q4), 13Patch-For-Review: Create db user for Quarry with readonly access to public ToolsDB databases - https://phabricator.wikimedia.org/T348407#9812034 (10github-toolforge-bot) dhinus opened https://github.com/toolforge/quarry/pull/40 [11:16:10] (03CR) 10Santiago Faci: "I have a few questions about some of the fields included in the new schema. I have put some comments in the corresponding place" [schemas/event/secondary] - 10https://gerrit.wikimedia.org/r/1019138 (https://phabricator.wikimedia.org/T356228) (owner: 10David Martin) [11:52:51] 10Quarry, 10Data-Services, 10cloud-services-team (FY2023/2024-Q3-Q4), 13Patch-For-Review: Create db user for Quarry with readonly access to public ToolsDB databases - https://phabricator.wikimedia.org/T348407#9812218 (10github-toolforge-bot) vivian-rook closed https://github.com/toolforge/quarry/pull/40 [12:26:08] 10Quarry: quarry puppet not running - https://phabricator.wikimedia.org/T365357 (10rook) 03NEW [12:49:10] btullis: o/ I wised I had time to fully review your patches on friday but I didn't, and I'd need to read the context etc.. I assume this is not super urgent, sorry for the delay, in case it becomes urgent please ping me [13:02:37] elukey: Thanks so much. It's not blocking me right now, so whenever you get a chance would be great. Would you like to have a call to chat about the context? [13:03:45] btullis: for the moment no, but if I get confused too much I'll definitely ask you for a meeting! Hope it will be smoother :) [13:04:17] Cool. <3 [13:07:33] Hello everyone! I'm finally back from daddy duty! [13:27:35] (03CR) 10Dbrant: [C:03+2] Add agent device_family to app fragment [schemas/event/secondary] - 10https://gerrit.wikimedia.org/r/1032887 (https://phabricator.wikimedia.org/T363700) (owner: 10Clare Ming) [13:28:06] (03Merged) 10jenkins-bot: Add agent device_family to app fragment [schemas/event/secondary] - 10https://gerrit.wikimedia.org/r/1032887 (https://phabricator.wikimedia.org/T363700) (owner: 10Clare Ming) [13:29:02] (03CR) 10Dbrant: [C:03+2] Update app base schema to include updated fragment [schemas/event/secondary] - 10https://gerrit.wikimedia.org/r/1032890 (https://phabricator.wikimedia.org/T363700) (owner: 10Clare Ming) [13:29:31] (03Merged) 10jenkins-bot: Update app base schema to include updated fragment [schemas/event/secondary] - 10https://gerrit.wikimedia.org/r/1032890 (https://phabricator.wikimedia.org/T363700) (owner: 10Clare Ming) [13:31:33] (03CR) 10Dbrant: [C:03+2] Bump app base version and article_toc_interaction version [schemas/event/secondary] - 10https://gerrit.wikimedia.org/r/1032891 (https://phabricator.wikimedia.org/T363700) (owner: 10Clare Ming) [13:31:42] 14Analytics, 06Data-Engineering, 10Data-Engineering-Wikistats, 06Data Products: Pageviews complete dumps have lots of rows with article name = '-' - https://phabricator.wikimedia.org/T365321#9812461 (10lbowmaker) [13:32:02] (03Merged) 10jenkins-bot: Bump app base version and article_toc_interaction version [schemas/event/secondary] - 10https://gerrit.wikimedia.org/r/1032891 (https://phabricator.wikimedia.org/T363700) (owner: 10Clare Ming) [13:32:55] (03CR) 10Dbrant: [C:03+2] Bump app base version and article_find_in_page_interaction version [schemas/event/secondary] - 10https://gerrit.wikimedia.org/r/1032892 (https://phabricator.wikimedia.org/T363700) (owner: 10Clare Ming) [13:33:26] (03Merged) 10jenkins-bot: Bump app base version and article_find_in_page_interaction version [schemas/event/secondary] - 10https://gerrit.wikimedia.org/r/1032892 (https://phabricator.wikimedia.org/T363700) (owner: 10Clare Ming) [14:24:01] 10Quarry: quarry puppet not running - https://phabricator.wikimedia.org/T365357#9812602 (10rook) 05Open→03Resolved [14:30:46] (03PS6) 10Mforns: Improve Commons Impact Metrics base pipeline and dumps [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1027525 (https://phabricator.wikimedia.org/T362892) [14:31:01] (03CR) 10Mforns: [V:03+2] Improve Commons Impact Metrics base pipeline and dumps [analytics/refinery] - 10https://gerrit.wikimedia.org/r/1027525 (https://phabricator.wikimedia.org/T362892) (owner: 10Mforns) [14:37:46] !log deploying refinery for https://gerrit.wikimedia.org/r/c/analytics/refinery/+/1027525 [14:37:49] Logged the message at https://www.mediawiki.org/wiki/Analytics/Server_Admin_Log [15:35:12] !log finished deploying refinery for https://gerrit.wikimedia.org/r/c/analytics/refinery/+/1027525 [15:35:14] Logged the message at https://www.mediawiki.org/wiki/Analytics/Server_Admin_Log [16:23:16] 06Data-Engineering-Icebox: Deprecation (if possible) of the #central channel on irc.wikimedia.org - https://phabricator.wikimedia.org/T242712#9813067 (10elukey) [16:31:16] 10Quarry: [bug] Quarry bug - https://phabricator.wikimedia.org/T365374 (10Liz) 03NEW [16:31:55] 07Analytics-Data-Problem, 06Data-Platform, 06Movement-Insights: Unique devices per country spikes on wikifunctions - https://phabricator.wikimedia.org/T364872#9813108 (10MNeisler) @Mayakp.wiki Thanks for following up. See responses inline below and let me know if any additional information would be helpful... [16:33:18] 10Quarry: [bug] Quarry bug - https://phabricator.wikimedia.org/T365374#9813121 (10Liz) [16:36:12] 10Quarry: [bug] Quarry bug - https://phabricator.wikimedia.org/T365374#9813142 (10Liz) Sorry, but whatever was the problem is fixed, it's working now. Feel free to close this. Thanks. [16:37:28] 10Quarry: [bug] Quarry bug - https://phabricator.wikimedia.org/T365374#9813145 (10rook) 05Open→03Resolved [19:07:06] 14Analytics, 06Data-Engineering, 06DBA, 10Event-Platform: Eventually Consistent MediaWiki State Change Events - https://phabricator.wikimedia.org/T120242#9813867 (10Ottomata) > As pointed out above, not even MediaWiki products assume 100% @akosiaris, just so I understand this point: Are you saying that M... [19:39:57] 10Quarry: [bug] Access denied for user 'quarry'@'172.16.2.72' (using password: NO) - https://phabricator.wikimedia.org/T365374#9814008 (10SD0001) 05Resolved→03Open Still occurring intermittently. Error message suggests a failure in accessing the Trove db. @rook did we make any changes to the setup lately? [20:00:41] 10Quarry: Error 500 when clicking "stop query" - https://phabricator.wikimedia.org/T362213#9814081 (10SD0001) Turns out the issue is quite simpler - only running queries can be stopped. A query in queued state has no db process associated with it, so there's nothing to kill. I don't think the celery based archit... [20:04:04] 10Quarry: [bug] Access denied for user 'quarry'@'172.16.2.72' (using password: NO) - https://phabricator.wikimedia.org/T365374#9814111 (10Liz) I spoke too soon. It's happening again. [20:30:51] 10Data-Engineering (Q4 2024 April 1st - June 30th): Move reportupdater reports away from their local filesystem locations - https://phabricator.wikimedia.org/T365382#9814193 (10amastilovic) No update still - let's wait for a bit and see what happens, the sync refreshment period might be daily as opposed to hourly. [20:36:10] 10Quarry, 10Cloud-VPS: [bug] Lot of queries stuck in queued state for hours and days (with stop actions leading to HTTP 500) - https://phabricator.wikimedia.org/T365136#9814203 (10SD0001) Per the worker logs, we are getting a lot of connection resets while accessing the trove db: ` sqlalchemy.exc.OperationalE... [21:18:27] 06Data-Engineering, 10MediaWiki-General: PHP 8.3 missing (showing as other?) on https://pingback.wmflabs.org/#php-version - https://phabricator.wikimedia.org/T365201#9814351 (10amastilovic) We are attempting to resolve this issue in this ticket: T365382