CDR Tickets

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
Description

Find out why and prevent it.

Comment entered 2019-10-15 14:15:53 by Englisch, Volker (NIH/NCI) [C]

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

Comment entered 2019-10-15 14:52:41 by Englisch, Volker (NIH/NCI) [C]

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.

Comment entered 2020-05-12 09:55:48 by Kline, Bob (NIH/NCI) [C]

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