search

pulibrary / rdss-catchall

A repository to document and discuss RDSS work that is quantifiable in issues but is outside of application repositories
0 stars 0 forks source link

Restoring files to Thesis-Central pre-04/10 database fix #94

Closed kelynch closed 1 year ago

kelynch commented 1 year ago

After emergency work to begin addressing https://github.com/pulibrary/rdss-catchall/issues/93 on 2023/04/10, it was reported that files uploaded as part of submissions before the fix was put in place where not appearing in the web interface. Files uploaded as part of submissions after the fix was put in place were appearing just fine.

This ticket tracks troubleshooting work on 2023/04/11 and full restore actions to be taken in coordination with Lynn Durgin.

kelynch commented 1 year ago

Originally posted by James in #93

Related to the service outage, an administrative user has provided the following error report from a user:

An issue has come up with the files that were submitted prior to the site outage on Sunday. I received an error message when I try to view/download a file that was submitted earlier than 4/9.

A student alerted me to the issue:

10:26

Hello,I recently (on Saturday) uploaded my thesis onto Thesis Central. While everything on the site worked correctly then, today when I try to view the Manuscript in PDF of my thesis on the site an error occurs; in addition, when I view the submission of my thesis it now says the pdf has a size of 0 bytes. I just wanted to make you aware of the issue so that I can assure that my thesis is still properly stored on the site as it was on Saturday, especially considering that it is due today (Tuesday) at 4:30 PM.Thank you!

kelynch commented 1 year ago

From James:

The following postgreSQL query retrieves the paths and names for the files uploaded:

thesis-prod-db=> select a.name,a.data,sub.id from submission as sub inner join attachment as a on a.submission_id=sub.id inner join person as p on sub.submitter_id=p.id where email like '%[SUBMITTER_NAME]%';
kelynch commented 1 year ago

Resolved 2023/04/12 at 7am EST