[13:53:34] 10Quarry: Queries take forever to run - https://phabricator.wikimedia.org/T367654 (10GTrang) 03NEW [13:54:04] 10Quarry: Queries take forever to run - https://phabricator.wikimedia.org/T367654#9896074 (10GTrang) [13:56:17] 10Quarry, 10cloud-services-team (FY2023/2024-Q3-Q4): [bug] Access denied for user 'quarry'@'172.16.2.72' (using password: NO) - https://phabricator.wikimedia.org/T365374#9896076 (10GTrang) >>! In T365374#9890676, @Liz wrote: > I'm not getting that message any more but some queries are just running endlessl... [15:22:03] 10Quarry: Queries take forever to run - https://phabricator.wikimedia.org/T367654#9896126 (10SD0001) →14Duplicate dup:03T367464 [15:22:24] 10Quarry: [bug] Quarry queries not completing - https://phabricator.wikimedia.org/T367464#9896128 (10SD0001) [16:21:56] 10Quarry: [bug] Quarry queries not completing - https://phabricator.wikimedia.org/T367464#9896165 (10Liz) Now, there is a little grey box saying "Explain" at the bottom of the page under Query Status (see [[ https://quarry.wmcloud.org/history/83084/901583/875059 | this Quarry query ]] ) that just produces a tabl... [17:27:40] 10Quarry: [bug] Quarry queries not completing - https://phabricator.wikimedia.org/T367464#9896220 (10Novem_Linguae) >>! In T367464#9896165, @Liz wrote: > Now, there is a little grey box saying "Explain" at the bottom of the page under Query Status (see [[ https://quarry.wmcloud.org/history/83084/901583/875059 |... [19:04:11] 10Quarry: [bug] Quarry queries not completing - https://phabricator.wikimedia.org/T367464#9896329 (10SD0001) >>! In T367464#9896220, @Novem_Linguae wrote: >>>! In T367464#9896165, @Liz wrote: >> Now, there is a little grey box saying "Explain" at the bottom of the page under Query Status (see [[ https://quarry.w... [19:06:15] 10Quarry: [bug] Quarry queries not completing - https://phabricator.wikimedia.org/T367464#9896332 (10SD0001) It's surprising that this issue still occurs with pre-ping enabled – Trove connections from the pool are now validated to ensure liveness before being used. Perhaps I don't understand SQLAlchemy well enou... [19:15:23] 10Quarry, 13Patch-Needs-Improvement: EXPLAIN is broken because new analytics wiki replica cluster contains multiple servers - https://phabricator.wikimedia.org/T205214#9896350 (10SD0001) 05Open→03Resolved a:03SD0001 The EXPLAIN capability is back up now! There's a UI issue though - as this feature... [19:33:26] 10Quarry, 13Patch-Needs-Improvement: EXPLAIN is broken because new analytics wiki replica cluster contains multiple servers - https://phabricator.wikimedia.org/T205214#9896369 (10github-toolforge-bot) siddharthvp opened https://github.com/toolforge/quarry/pull/56 [19:59:03] 10Quarry: [bug] Quarry queries not completing - https://phabricator.wikimedia.org/T367464#9896388 (10Wurgl) For my query: https://quarry.wmcloud.org/query/83617 When I wait for about 20 Minutes and click on "Explain": Nothing happens When I start the query an click on "Explain" immediate after starting, I see s... [20:25:26] 10Quarry: [bug] Quarry queries not completing - https://phabricator.wikimedia.org/T367464#9896408 (10Liz) But hitting "Explain" fills up the part of the page with a table where the query results should be plus it is in code that only a developer or coder would understand, not us mere editors. So, it's not help... [20:36:20] 10Quarry: [bug] Quarry queries not completing - https://phabricator.wikimedia.org/T367464#9896411 (10Wurgl) Liz: Explain tells you in which order the query is processed and which index (if there is some) is used. This is an output of the database itself and you may find some (more or less) helpful information on... [20:51:11] 10Quarry: [bug] Quarry queries not completing - https://phabricator.wikimedia.org/T367464#9896436 (10Novem_Linguae) Results will go under the explain. I forget if the explain disappears. The explain is useful to the sql query writer, because you can use it to see why your query is slow. For example you can see... [21:04:00] 10Quarry, 13Patch-Needs-Improvement: EXPLAIN is broken because new analytics wiki replica cluster contains multiple servers - https://phabricator.wikimedia.org/T205214#9896453 (10github-toolforge-bot) siddharthvp closed https://github.com/toolforge/quarry/pull/56