We have had a couple of more incidents of the item and loan tables being out of sync after renewal attempts.
In the case this morning I found an error in the error log. It is
OptimisticLockException: Object has been modified by someone else:
and the transaction is backed out.
Dale is providing more of the error log.
I wonder if the transaction backouts don't completely backout the transaction when something like this happens.