Page MenuHomePhabricator

Quarry seems to hang somehow
Closed, DuplicatePublic

Description

This one is now running for hours and does not get ready?

Query status: running
This query is currently executing...

https://quarry.wmflabs.org/query/48852

On the command line, the query took 5 seconds, so something seems to be wrong here.

Event Timeline

Two "page_title" columns exists in your query, and it looks like it's not handled correctly. So this works well when you rename your columns: https://quarry.wmflabs.org/query/49300.

This is indeed a bug that should be corrected

Oct 24 13:57:04 quarry-worker-02 celery-quarry-worker[24753]: [2020-10-24 13:57:04,967: ERROR/ForkPoolWorker-1482] Task worker.run_query[605c063a-d2cf-4234-8aa4-8d40d22ab37d] raised unexpected: OperationalEr
Oct 24 13:57:04 quarry-worker-02 celery-quarry-worker[24753]: Traceback (most recent call last):
Oct 24 13:57:04 quarry-worker-02 celery-quarry-worker[24753]:   File "/srv/quarry/venv/lib/python3.5/site-packages/celery/app/trace.py", line 382, in trace_task
Oct 24 13:57:04 quarry-worker-02 celery-quarry-worker[24753]:     R = retval = fun(*args, **kwargs)
Oct 24 13:57:04 quarry-worker-02 celery-quarry-worker[24753]:   File "/srv/quarry/venv/lib/python3.5/site-packages/celery/app/trace.py", line 641, in __protected_call__
Oct 24 13:57:04 quarry-worker-02 celery-quarry-worker[24753]:     return self.run(*args, **kwargs)
Oct 24 13:57:04 quarry-worker-02 celery-quarry-worker[24753]:   File "/srv/quarry/quarry/web/worker.py", line 79, in run_query
Oct 24 13:57:04 quarry-worker-02 celery-quarry-worker[24753]:     output.start_resultset([c[0] for c in cur.description], cur.rowcount)
Oct 24 13:57:04 quarry-worker-02 celery-quarry-worker[24753]:   File "/srv/quarry/quarry/web/results.py", line 33, in start_resultset
Oct 24 13:57:04 quarry-worker-02 celery-quarry-worker[24753]:     self.db.execute(sql)
Oct 24 13:57:04 quarry-worker-02 celery-quarry-worker[24753]: sqlite3.OperationalError: duplicate column name: page_title