Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Race: empty FileGroups can't be resumed #693

Open
adamhooper opened this issue Jan 29, 2019 · 0 comments
Open

Race: empty FileGroups can't be resumed #693

adamhooper opened this issue Jan 29, 2019 · 0 comments

Comments

@adamhooper
Copy link
Member

Steps to reproduce:

  1. Convert some documents
  2. Cancel
  3. Kill Overview during cancel, after grouped_file_uploads have been deleted for a file group, but before the file_group has been deleted.
  4. 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:

  1. Browse to https://www.overviewdocs.com/admin/jobs
  2. Inspect the page to see the FileGroup ID (it's part of the table row)
  3. Make sure you have the right FileGroup: SELECT * FROM file_group WHERE id = XXXXX
  4. Make sure it's empty: SELECT COUNT(*) FROM grouped_file_upload WHERE file_group_id = XXXXX
  5. Delete it: change SELECT * to DELETE FROM in the query from step 3
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant