Vacuumd sends automation events before transaction is closed

Auto and action events are sent before the transaction is closed.

If event handlers rely on the records updated by the automation, they may not be available when the event is handled.

Instead, the transaction should be closed before the events are sent.