EBMS Tickets

Oops, I meant to log this as a bug rather than a task. Sorry about that.

Next time it happens, could you include the body of the error message (cut off in the screen shot)?

It seems to be working fine now (go figure), but I'll post an updated screenshot if we are able to reproduce the problem. Thanks.

Robin B just got the error message to come up again. She sent me three screenshots including the full error message so I will upload those shortly.

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 …

1. a user tries to post a file

2. Drupal extracts the file name from the request

3. Drupal checks the file system to see if the file is already present

4. the file isn’t there, so Drupal doesn’t bother to create a distinguished unique name for the URI

5. a SQL INSERT query is submitted to add a row to the file_managed table

6. 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.

QA has been refreshed from PROD. Please try this again.

Verified on QA. Thanks!