Subject | Re: Kill a transaction |
---|---|
Author | karolbieniaszewski |
Post date | 2013-01-07T07:42:39Z |
--- In firebird-support@yahoogroups.com, W O wrote:
I do not know what version of Firebird you have
but try to select from MON$TRANSACTIONS
to kill transaction try delete row from this table
Karol Bieniaszewski
>Hi,
> Hello everybody
>
> Sometimes a transaction updates a row and hangs up before commit, avoiding
> another transactions update that row. So the questions are:
>
> 1. How to know if a transaction is lasting too much? (by example: more than
> a minute)
>
> 2. How to kill the offending transaction?
>
> Thank you in advance.
>
> Greetings.
>
> Walter.
>
>
> [Non-text portions of this message have been removed]
>
I do not know what version of Firebird you have
but try to select from MON$TRANSACTIONS
to kill transaction try delete row from this table
Karol Bieniaszewski