Page MenuHomeSoftware Heritage
Paste P109

query wait timeout when too many worker for copy to azure
ActivePublic
Actions

Authored by ardumont on Sep 23 2016, 1:51 PM.
Sep 22 20:41:47 uffizi python3[28445]: [2016-09-22 20:41:47,054: ERROR/MainProcess] Task swh.storage.archiver.tasks.SWHArchiverToBackendTask[cdfe6d71-704d-4c8a-b664-e9e8fe9d3308] raised unexpected: DatabaseError('query_wait_timeout\nSSL co
nnection has been closed unexpectedly\n',)
Sep 22 20:41:47 uffizi python3[28445]: Traceback (most recent call last):
Sep 22 20:41:47 uffizi python3[28445]: File "/usr/lib/python3/dist-packages/celery/app/trace.py", line 240, in trace_task
Sep 22 20:41:47 uffizi python3[28445]: R = retval = fun(*args, **kwargs)
Sep 22 20:41:47 uffizi python3[28445]: File "/usr/lib/python3/dist-packages/celery/app/trace.py", line 437, in __protected_call__
Sep 22 20:41:47 uffizi python3[28445]: return self.run(*args, **kwargs)
Sep 22 20:41:47 uffizi python3[28445]: File "/usr/lib/python3/dist-packages/swh/storage/archiver/tasks.py", line 26, in run
Sep 22 20:41:47 uffizi python3[28445]: ArchiverToBackendWorker(*args, **kwargs).run()
Sep 22 20:41:47 uffizi python3[28445]: File "/usr/lib/python3/dist-packages/swh/storage/archiver/worker.py", line 88, in run
Sep 22 20:41:47 uffizi python3[28445]: copies = self.compute_copies(self.set_objstorages, obj_id)
Sep 22 20:41:47 uffizi python3[28445]: File "/usr/lib/python3/dist-packages/swh/storage/archiver/worker.py", line 167, in compute_copies
Sep 22 20:41:47 uffizi python3[28445]: result = self.archiver_db.content_archive_get(content_id)
Sep 22 20:41:47 uffizi python3[28445]: File "/usr/lib/python3/dist-packages/swh/storage/common.py", line 17, in _meth
Sep 22 20:41:47 uffizi python3[28445]: return meth(self, *args, cur=cur, **kwargs)
Sep 22 20:41:47 uffizi python3[28445]: File "/usr/lib/python3/dist-packages/swh/storage/archiver/storage.py", line 54, in content_archive_get
Sep 22 20:41:47 uffizi python3[28445]: return self.db.content_archive_get(content_id, cur)
Sep 22 20:41:47 uffizi python3[28445]: File "/usr/lib/python3/dist-packages/swh/storage/archiver/db.py", line 65, in content_archive_get
Sep 22 20:41:47 uffizi python3[28445]: cur.execute(query, (content_id,))
Sep 22 20:41:47 uffizi python3[28445]: psycopg2.DatabaseError: query_wait_timeout
Sep 22 20:41:47 uffizi python3[28445]: SSL connection has been closed unexpectedly

Event Timeline

ardumont created this paste.Sep 23 2016, 1:51 PM
ardumont mentioned this in Unknown Object (Maniphest Task).Sep 23 2016, 1:56 PM
About · Developer information · Legal