Comment 3 for bug 1441301

Hello, we ran into this issue recently, but it was limited to only two holds total in our system that would trigger the error when viewing the canceled holds. I used the following query to find instances of these canceled holds that point at non-existant meta records.

select * from
action.hold_request ahr
where
not exists (select 1 from metabib.metarecord mm where mm.id=ahr.target)
and ahr.hold_type='M'
and ahr.cancel_time is not null
;

To fix them I converted them to title holds by changing the type and target.

Josh