Maniphest T205214

EXPLAIN is broken because new analytics wiki replica cluster contains multiple servers
Closed, ResolvedPublicBUG REPORT
Actions

Assigned To

Authored By

	Framawiki
	Sep 23 2018, 10:15 AM

Description

Since T195836: Cannot reliably get the EXPLAIN for a query on analytics wiki replica cluster it's not possible to directly get the EXPLAIN for a query on analytics wiki replica cluster since multiple servers are handling requests and it's not possible to choose on which one the EXPLAIN need to be executed.

Details

Related Changes in Gerrit:

	Subject	Repo	Branch	Lines +/-
	app.py: EXPLAIN needs to be executed on the good server	analytics/quarry/web	master	+38 -17
	query-status.html: hide Explain button until bug is solved	analytics/quarry/web	master	+12 -11

Customize query in gerrit

Related Objects

Mentioned In: T367464: [bug] Quarry queries not completing
T265430: SHOW EXPLAIN FOR via Quarry or sql-optimizer fails often due to load balancing
T224656: A Query takes suddenly really much too long – something corrupt?
Mentioned Here: T264254: Prepare Quarry for multiinstance wiki replicas
rANQW1f297c9931a5: query-status.html: hide Explain button until bug is solved
T195836: Cannot reliably get the EXPLAIN for a query on analytics wiki replica cluster

Event Timeline

Framawiki created this task.Sep 23 2018, 10:15 AM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptSep 23 2018, 10:15 AM

Framawiki moved this task from Backlog to Bugs on the Quarry board.Oct 21 2018, 6:58 PM

Change 462286 had a related patch set uploaded (by Framawiki; owner: Framawiki):
[analytics/quarry/web@master] EXPLAIN needs to be executed on the good server

https://gerrit.wikimedia.org/r/462286

gerritbot added a project: Patch-For-Review.Nov 11 2018, 11:34 AM

Framawiki mentioned this in T224656: A Query takes suddenly really much too long – something corrupt?.Jun 4 2019, 7:03 PM

zhuyifei1999 merged a task: T227942: Pushing "Explain" button outputs "Error Hmm... Is the SQL actually running?!".Aug 29 2019, 3:35 PM

zhuyifei1999 added a subscriber: Nicolas_Raoul.

Change 543923 had a related patch set uploaded (by Framawiki; owner: Framawiki):
[analytics/quarry/web@master] query-status.html: hide Explain button until bug is solved

https://gerrit.wikimedia.org/r/543923

Change 543923 merged by jenkins-bot:
[analytics/quarry/web@master] query-status.html: hide Explain button until bug is solved

https://gerrit.wikimedia.org/r/543923

Mentioned in SAL (#wikimedia-cloud) [2019-10-19T15:18:27Z] <wm-bot> framawiki: Deployed 1f297c9 on -web-01 T205214 (query-status.html: hide Explain button until bug is solved)

Nicolas_Raoul unsubscribed.Oct 20 2019, 3:24 AM

AntiCompositeNumber mentioned this in T265430: SHOW EXPLAIN FOR via Quarry or sql-optimizer fails often due to load balancing.Oct 14 2020, 12:48 AM

It is more broken now due to T264254: Prepare Quarry for multiinstance wiki replicas

Pppery edited projects, added Patch-Needs-Improvement; removed Patch-For-Review.Apr 1 2023, 4:23 PM

Aklapper changed the subtype of this task from "Task" to "Bug Report".Jul 18 2023, 12:20 PM

SD0001 merged a task: T288170: quarry explain not working since move to multiple databases.Jun 14 2024, 7:11 AM

SD0001 added a subscriber: • rook.

siddharthvp opened https://github.com/toolforge/quarry/pull/53

siddharthvp closed https://github.com/toolforge/quarry/pull/53

SD0001 mentioned this in T367464: [bug] Quarry queries not completing .Jun 16 2024, 7:02 PM

The EXPLAIN capability is back up now!

There's a UI issue though - as this feature predates the STOP feature, a UI change is required to ensure the button doesn't show up on stopped queries (as explain only works for running queries.)

siddharthvp opened https://github.com/toolforge/quarry/pull/56

siddharthvp closed https://github.com/toolforge/quarry/pull/56

Change #462286 abandoned by Majavah:

[analytics/quarry/web@master] app.py: EXPLAIN needs to be executed on the good server

Reason:

quarry has moved to github for now, abandoning old patches

https://gerrit.wikimedia.org/r/462286