Issue Number | 4665 |
---|---|
Summary | [Internal] File Sweeper leaves locked documents behind |
Created | 2019-09-14 09:05:26 |
Issue Type | Bug |
Submitted By | Kline, Bob (NIH/NCI) [C] |
Assigned To | Kline, Bob (NIH/NCI) [C] |
Status | Closed |
Resolved | 2020-05-12 09:55:48 |
Resolution | Fixed |
Path | /home/bkline/backups/jira/ocecdr/issue.249778 |
Find out why and prevent it.
For my information - the query to identify the locked documents is the following:
SELECT COUNT⭐, u.id, u.name, u.fullname
FROM usr u
JOIN checkout c
ON c.usr = u.id
WHERE c.dt_in is null
GROUP BY u.id, u.name, u.fullname
All of the locked documents are expired and deleted Meeting Recording *.mp3 files.
I can't tell from the code or the original ticket if the documents haven't been unlocked intentionally after the deletion of the MP3 file but I'm wondering if Alan left the documents locked on purpose to prevent any additional updates.
Added missing code to unlock the updated media docs. The theory that
Alan might have left the documents unlocked intentionally is weak,
because it would be very out of character for Alan to make such a
decision and not document it carefully in the comments. I think it much
more likely that he just wasn't aware of the default behavior of
cdr.repDoc()
.
Elapsed: 0:00:00.001427