Transaction Log

[Toni Eibner]

Is it possible to have a transaction in the tran log that WON'T commit? I don't have an
example for you, but say a transaction causes your application to abort for some reason.
How does that get cleared out of the transaction log if it won't commit? Would that cause other
transactions to be held in the log and not be committed as well?

Thank you!
Toni Eibner

[Craig]

On 12/30/98 7:20:58 AM, Toni Eibner wrote:
> Is it possible to have a transaction in the tran log that WON'T commit?
> I don't have an
example for you, but say a transaction causes your
> application to abort for some reason.
How does that get cleared out of the
> transaction log if it won't commit? Would that cause other
>
transactions to be held in the log and not be committed as well?

Thank
> you!
Toni Eibner

+++++++++

In order for the kernel to provide automatic recovery on shutdown and restart, the information is in the transaction log and is read by the kernel to ensure database integrity.

Don't worry about it.

[Richard Clarke]

On 12/30/98 7:20:58 AM, Toni Eibner wrote:
> Is it possible to have a transaction in the tran log that WON'T commit?
> I don't have an
example for you, but say a transaction causes your
> application to abort for some reason.
How does that get cleared out of the
> transaction log if it won't commit? Would that cause other
>
transactions to be held in the log and not be committed as well?

Thank
> you!
Toni Eibner


Yes, to paraphrase books online, "an open transaction can be blocked on locks held by another process". Incidentally this prevents the log being truncated by checkpoint or by DUMP TRAN.