Comment 3 for bug 1935971

An interesting thing happened this morning/last night. We had 33 autorenewal events get left in the reacting state, but the circulations were renewed, and the autorenewal email notices were generated, i.e. the number of complete email notice events matches the total of complete and reacting autorenewal events.

I used the following query to determine that the reacting events had actually renewed the ciruclations:

select circulation.*
from action.circulation
join action_trigger.event
on circulation.parent_circ = event.target
and event_def = 124
and event.state = 'reacting'
and event.add_time::date = now()::date;