| Dvorapa | |
| Jun 10 2016, 6:27 AM |
| F4149692: Snímek z 2016-06-10 12-43-41.png | |
| Jun 10 2016, 10:45 AM |
| F4149115: Snímek z 2016-06-10 08-26-24.png | |
| Jun 10 2016, 6:31 AM |
Quarry has got wrong status of old and completed/killed/erroneous queries in Recent Queries list. Please see:
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.
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | None | T137517 Wrong status of queries in Recent Queries list | |||
| Open | BUG REPORT | None | T278583 Quarry should detect a dead worker and report something better than "running" forever |
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:
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
I believe this was an artifact of queries getting stuck in a "running" state. That has largely been fixed with an updated stop button.
As it stands looking through the quarry listing today, it would appear that the state listed in the Recent Queries page matches the state on the query itself.
Please re-open if there is any more work to be done on this ticket.