Skip to content

File manager should be able to reconnect to DB #44

@bdc34

Description

@bdc34

When uploading a file I get an error that looks related to a DB connection.
To produce this I started a submission, skipped ahead to upload file, and uploaded a PDF.
It looks like the DB connection has been dropped or reset.

arxiv-submission-ui       | 172.18.0.1 172.18.0.1 - -|- [05/Jun/2019:16:36:54 -0400] [Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.139 Safari/537.36] "GET /2/file_upload HTTP/1.1" 200 15704 17400 16983
arxiv-filemanager         | DEBUG:filemanager.controllers.upload:Handling upload request for None
arxiv-filemanager         | ERROR:filemanager.controllers.upload:Upload 'archive' not specified. Oversize calculation will use default values.
arxiv-filemanager         | DEBUG:filemanager.controllers.upload:This is a new upload workspace.
arxiv-filemanager         | INFO:filemanager.controllers.upload:Create new workspace: Upload request: file='0704.1439.pdf' archive='None'
arxiv-filemanager         | INFO:filemanager.controllers.upload:Unknown error in upload for new workspace.  Add except clauses for 'Ack! (MySQLdb._exceptions.OperationalError) (2006, 'MySQL server has gone away')
arxiv-filemanager         | [SQL: INSERT INTO uploads (submission_id, owner_user_id, archive, created_datetime, modified_datetime, lastupload_start_datetime, lastupload_completion_datetime, lastupload_logs, lastupload_file_summary, lastupload_upload_status, state, `lock`) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)]
arxiv-filemanager         | [parameters: (None, '7', '', datetime.datetime(2019, 6, 5, 20, 37, 33, 904991, tzinfo=<UTC>), datetime.datetime(2019, 6, 5, 20, 37, 33, 904991, tzinfo=<UTC>), None, None, None, None, None, 'ACTIVE', 'UNLOCKED')]
arxiv-filemanager         | (Background on this error at: http://sqlalche.me/e/e3q8)'. DO IT NOW!
arxiv-filemanager         | 172.18.0.19 172.18.0.19 - -|- [-] [python-requests/2.21.0] "POST /filemanager/api/ HTTP/1.1" 500 117 47056 -
arxiv-submission-ui       | application 05/Jun/2019:16:37:33 +0000 - submit.controllers.upload - None - [arxiv:null] - ERROR: "Traceback (most recent call last):
arxiv-submission-ui       |   File "./submit/controllers/upload.py", line 502, in _new_upload
arxiv-submission-ui       |     stat = fm.upload_package(pointer, token)
arxiv-submission-ui       |   File "./submit/services/filemanager.py", line 137, in upload_package
arxiv-submission-ui       |     timeout=30)
arxiv-submission-ui       |   File "/root/.local/share/virtualenvs/arxiv-AI0WzCV4/lib/python3.6/site-packages/arxiv/integration/api/service.py", line 212, in json
arxiv-submission-ui       |     response = self.request(method, path, token, expected_code, **kwargs)
arxiv-submission-ui       |   File "/root/.local/share/virtualenvs/arxiv-AI0WzCV4/lib/python3.6/site-packages/arxiv/integration/api/service.py", line 193, in request
arxiv-submission-ui       |     self._check_status(resp, expected_code)
arxiv-submission-ui       |   File "/root/.local/share/virtualenvs/arxiv-AI0WzCV4/lib/python3.6/site-packages/arxiv/integration/api/service.py", line 159, in _check_status
arxiv-submission-ui       |     raise_for_http_status(resp.status_code, resp)
arxiv-submission-ui       |   File "/root/.local/share/virtualenvs/arxiv-AI0WzCV4/lib/python3.6/site-packages/arxiv/integration/api/service.py", line 284, in raise_for_http_status
arxiv-submission-ui       |     raise RequestFailed(f'Status: {resp.status_code}', resp)
arxiv-submission-ui       | arxiv.integration.api.exceptions.RequestFailed: Status: 500
arxiv-submission-ui       | "
arxiv-submission-ui       | 172.18.0.1 172.18.0.1 - -|- [05/Jun/2019:16:37:33 -0400] [Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.139 Safari/537.36] "POST /2/file_upload HTTP/1.1" 500 16532 105129 104883

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions