Subject Re: [firebird-support] Re: Kill a transaction
Author W O
Hello Karol

Yes, you are right, my mistake.

I'm using Firebird 2.5.1, SuperServer.

Greetings.

Walter.





On Mon, Jan 7, 2013 at 3:42 AM, karolbieniaszewski <
liviuslivius@...> wrote:

> **
>
>
>
>
> --- In firebird-support@yahoogroups.com, W O wrote:
> >
> > 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]
> >
>
> Hi,
>
> 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
>
>
>


[Non-text portions of this message have been removed]