| Issue Number | 503 |
|---|---|
| Summary | [Drupal Core Testing] Error uploading document to EBMS |
| Created | 2019-02-06 10:12:12 |
| Issue Type | Bug |
| Submitted By | Juthe, Robin (NIH/NCI) [E] |
| Assigned To | |
| Status | Closed |
| Resolved | 2019-08-01 14:23:42 |
| Resolution | Fixed |
| Path | /home/bkline/backups/jira/oceebms/issue.239766 |
This is another sporadic error message received upon uploading a document on the "Upload Document" page in the EBMS. I'll attach the file (a portion of a summary) and a screenshot of the error message.
I was able to upload it with a different EBMS name. Maybe it's just a duplicate?
An attempt to refresh QA using Jenkins last fall appears to have corrupted the site, and the database doesn't match what's in the file system. So …
a user tries to post a file
Drupal extracts the file name from the request
Drupal checks the file system to see if the file is already present
the file isn’t there, so Drupal doesn’t bother to create a distinguished unique name for the URI
a SQL INSERT query is submitted to add a row to the
file_managed table
the uri column of that table has a `UNIQUE`
constraint on it, so the query throws an exception
There are many thousands of files in the database (over 16K) on QA which aren’t in the file system, and testers user whatever files they have lying around on their computers, or they download files from the production system when testing on the lower tiers, so it’s not a big surprise that they’d run into such conflicts on a system that’s as badly corrupted as QA is.
The solution will be to get CBIIT to provide backups of the database and the file system from the production site and use them to get QA back to a sane state, then apply the Drupal core upgrade and the patch for the citation queue problem fixed a week or two ago, and then have the users test again.
~juther and ~vshields: I'll be taking down the EBMS QA web server to correct the problem described in the previous comment. Will let you know when it's back up.
Got it. Thank you!
QA has been refreshed from PROD. Please try this again.
Sorry, I need to upgrade Drupal core first. Stay tuned.
Oh whoops, I just tested. Will stay tuned 🙂
Done. Should be ready to test now.
No harm done. It's ready now.
Verified on QA. Thanks!
| File Name | Posted | User |
|---|---|---|
| EBMS doc upload error.png | 2019-02-06 10:12:21 | Juthe, Robin (NIH/NCI) [E] |
| Soy section 092218.docx | 2019-02-06 10:12:57 | Juthe, Robin (NIH/NCI) [E] |
Elapsed: 0:00:00.000779