Comment 1 for bug 1758975

Revision history for this message
Michele Morgan (mmorgan) wrote :

Adding a query to identify likely victims of this bug.

select stop_fines, count(circ.*) from action.circulation circ
join asset.copy ac on ac.id = circ.target_copy
where circ.xact_finish is null
and circ.checkin_time is null
and ac.status in (17)
group by 1

The query reveals an error in my accounting of the 84 items currently erroneously marked Lost and Paid in our production system. 26 of the 84 still open transactions where the copy status has been changed to Lost and Paid have stop_fines LOST.