>
> >or any suggestions as to what might cause this?
>
> Far, far more common is applications not committing transactions in a
> timely manner. A traditionally *very common* cause of that is Delphi
> applications that use CommitRetaining...which was an abomination
> designed by Borland/Inprise to "hide" transactions from programmers who
> only understood non-transactional data systems.

That abomination can appear if you use an old DbExpress (pre-D2010,
AFAIR) interbase driver with Fb. For some reason, it defaults to
commit-retaining. Closing the connection after the processing makes an hard
commit.

(Anyway, it must be tested since the last time I battled it was circa
2008).