Symptom

When attempting to empty the trash from within CSA, timeouts may occur, outlined through a pop-up on the screen.

Resolution

The timeouts are occurring because the SQL query running in the background is taking too long to report back to the browser, causing both the website and query to time out. Because of this, the trash never actually gets emptied. In order to get around this, it is necessary to manually delete the contents of the trash folder from within the CuratorDB.

Folder and its content deletion:

Delete FROM curatordb.folders where hex(parent_folder_id) = "CAD23C135D8943C5B260D756FC4CF32A";

Media Deletion:

Delete FROM curatordb.media where hex(folder_id) = "CAD23C135D8943C5B260D756FC4CF32A";

Audio Deletion:

Delete FROM curatordb.audio where hex(folder_id) = "CAD23C135D8943C5B260D756FC4CF32A";

Image/Other Deletion:

Delete FROM curatordb.images where hex(folder_id) = "CAD23C135D8943C5B260D756FC4CF32A";

NOTE: If any media item within the Trash folder is linked to keyframes or thumbnails, the database record will be deleted, however the physical file on spinning disk will not be, hence performing the above may cause orphaned files on disk.