Page MenuHomePhabricator

Wrong status of queries in Recent Queries list
Open, Needs TriagePublic

Description

Quarry has got wrong status of old and completed/killed/erroneous queries in Recent Queries list. Please see:


and

Look on the second screenshot. There are queries marked as running under queries marked as completed. This looks broken. They maybe isn't running, but their status in this table isn't correct then.

Event Timeline

Dvorapa created this task.Jun 10 2016, 6:27 AM
Restricted Application added subscribers: Zppix, Aklapper. · View Herald TranscriptJun 10 2016, 6:27 AM
Dvorapa renamed this task from Queries running for more than 4 hours still not killed by a system to Queries running for more than 4 hours and not killed.Jun 10 2016, 6:29 AM
Dvorapa added a project: Quarry.
Dvorapa updated the task description. (Show Details)
Dvorapa updated the task description. (Show Details)Jun 10 2016, 6:31 AM

It doesn't appear to be running anything at the moment:

root@quarry-main-01:~# mysql -h enwiki.labsdb -u u2029 -p enwiki_p -e "show processlist"
Enter password: 
+----------+-------+--------------------+----------------+---------+------+-------+------------------+----------+
| Id       | User  | Host               | db             | Command | Time | State | Info             | Progress |
+----------+-------+--------------------+----------------+---------+------+-------+------------------+----------+
| 12974272 | u2029 | 10.68.16.218:35477 | wikidatawiki_p | Sleep   |  162 |       | NULL             |    0.000 |
| 12979259 | u2029 | 10.68.17.14:41649  | enwiki_p       | Query   |    0 | init  | show processlist |    0.000 |
+----------+-------+--------------------+----------------+---------+------+-------+------------------+----------+

Quite a few things which are shown as running in quarry are not.

Therefore it looks like there is an error with status of the query. Please see screenshot:

Dvorapa added a comment.EditedJun 28 2016, 8:06 PM

Look on the screenshot. There are queries marked as running under queries marked as completed. This looks broken. They maybe isn't running, but their status in this table isn't correct then

Dvorapa renamed this task from Queries running for more than 4 hours and not killed to Wrong status of queries in Recent Queries list.Jul 1 2016, 3:13 PM
Dvorapa updated the task description. (Show Details)
Dvorapa updated the task description. (Show Details)