Steps to reproduce:
- Convert some documents
- Cancel
- Kill Overview during cancel, after
grouped_file_uploads have been deleted for a file group, but before the file_group has been deleted.
- Restart Overview
Expected results: Overview finishes cleanup upon restarting (or the deletion from grouped_file_uploads was in a transaction, so it gets undone and Overview starts where it left off next time)
Actual results: Overview leaves the file_group alone -- it's a job that stays around forever.
Workaround:
- Browse to https://www.overviewdocs.com/admin/jobs
- Inspect the page to see the FileGroup ID (it's part of the table row)
- Make sure you have the right FileGroup:
SELECT * FROM file_group WHERE id = XXXXX
- Make sure it's empty:
SELECT COUNT(*) FROM grouped_file_upload WHERE file_group_id = XXXXX
- Delete it: change
SELECT * to DELETE FROM in the query from step 3
Steps to reproduce:
grouped_file_uploadshave been deleted for a file group, but before thefile_grouphas been deleted.Expected results: Overview finishes cleanup upon restarting (or the deletion from
grouped_file_uploadswas in a transaction, so it gets undone and Overview starts where it left off next time)Actual results: Overview leaves the
file_groupalone -- it's a job that stays around forever.Workaround:
SELECT * FROM file_group WHERE id = XXXXXSELECT COUNT(*) FROM grouped_file_upload WHERE file_group_id = XXXXXSELECT *toDELETE FROMin the query from step 3