Subject Re: Error on FB 1.5.5 involving "hung" connections
Author Eduardo A. Salgado
--- In, Thomas Steinmaurer <ts@...>
> Uncommitted or committed with a soft commit (= commit retaining).
> A soft commit might be used behind the scenes when using some kind
> AutoCommit mode.
> The (SQL Server) user indicates that a Sweep is running. If you
> start a Sweep manually, then it got started automatically. This is
> defined via the Sweep interval which kicks in when OAT-OIT > Sweep
> interval. A stuck OIT can cause an automatic Sweep periodically.
> reasons for a stuck OIT can be:
> - Long-running transaction which has been left open (does not
apply when
> it's a read-only read committed transaction)
> - A large data manipulation transaction got rolled back and not
> - Soft commits without doing hard commits from time to time


Thank you for your quick answer.

I have been trying to get through to the damaged database using
Sweep because I could not get it to report on Statistics other than
the Header stuff. But, it ran Sweep all night and never finished.
I'll keep at it to see what table(s) are being affected.

Anyhow, are there any tools that we can use to log or be aware of
all the SQL statements that run against the server so we may narrow
down to what transactions are hanging or not being properly