On rare occasion, submissions can be approved twice, which causes duplicate records to be created. We suspect that it is a timing issue. Recommend locking the submission table during the approval process.
Installed in r2014-330 on 2014-10-09. Keeping open since the larger issue of changing the submission state from "N" to "I" at the beginning of the approval process hasn't been addressed yet.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
--- old+++ new@@ -1 +1 @@-On rare occasion, submissions can be approved twice, which cause duplicate records to be created. We suspect that it is a timing issue. Recommend locking the submission table during the approval process.+On rare occasion, submissions can be approved twice, which causes duplicate records to be created. We suspect that it is a timing issue. Recommend locking the submission table during the approval process.
status: open --> closed-fixed
assigned_to: Ahasuerus
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Ticket moved from /p/isfdb/bugs/143/
Ticket moved from /p/isfdb/feature-requests/534/
Fixed Make Pseudonym and Remove Pseudonym in:
Installed in r2014-330 on 2014-10-09. Keeping open since the larger issue of changing the submission state from "N" to "I" at the beginning of the approval process hasn't been addressed yet.
Diff:
Addressed in:
By adding an "In Progress" state to the list of possible submission states. Installed in r2015-074 on 2015-03-15. Closing.
Spelling fixes in mod/recent.py 1.22. Installed in r2105-075 on 2015-03-15.
Fixed SQL syntax (after the fact, no change made to the database) in scripts/add_in_progress_submission_status.sql 1.2