https://quarry.wmflabs.org/query/15594
I started this explain command about 1 day ago. It is still showing as "Running". A number of queries that ran after this one are still shown at Running or Queued.
Description
Description
Related Objects
Related Objects
- Mentioned Here
- T264254: Prepare Quarry for multiinstance wiki replicas
Event Timeline
Comment Actions
I'm still able to run new queries, so at least this doesn't seem to be disruptive for other users. Or do we have reasons to believe it is?
Comment Actions
About a dozen or more queries that happened just after this query are still marked as "Running". I believe there are others as well, some more queries that followed these.
https://quarry.wmflabs.org/query/runs/all?limit=100&from=15350
I think somehow running Explain caused all queries that followed to pile up and never actually be run. But without actually getting killed.
See https://quarry.wmflabs.org/query/15607 for an example
Comment Actions
Explain is almost certainly broken by T264254: Prepare Quarry for multiinstance wiki replicas
The functionality will need rewriting or similar. It stopped working reliably long before that though because of load balancing on the replicas.
Comment Actions
Running EXPLAIN at this point gives me:
ANALYZE/EXPLAIN/SHOW can not be issued; lacking privileges for underlying table
We could say that itself is a problem. But it would be reasonable to open a separate ticket for that. It does at least no longer run endlessly.