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.
Description
Description
Related Objects
Related Objects
Event Timeline
Comment Actions
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