Christie: We have another round of problems that I am attributing to the same error bit at the eholdings level. OLE will not delete records with multiple holdings attached as a preventative measure. The workflow when we want to delete a bib is to delete the eholdings and then delete the bib. However there are 17 records that cannot be deleted even though the eholdings have been removed from the bib.
I used this query to confirm that these bibs have no holdings attached in the database.
select * from ole_ds_holdings_t
where bib_id in ('11135165', '11159852', '11247601', '11258770', '11758753', '11119613', '11121649', '11122305', '11130825', '11135164', '11138918', '11232920', '11234945', '11259470', '11259551', '11261592', '11895842');
I am guessing that the index is not getting updated when the eholdings were deleted. (They were deleted 7/31 in the late afternoon.)
I think that the problem is with manual deletes of eholdings. Deleting the holdings is not updating the index. I tried reindexing the records but that did not solve the problem.
Dale: I'll copy the relevant logs to mulberry.