Subject Re: [firebird-support] Re: Oldest transaction far behind...
Author Kjell Rilbe
Den 2011-03-22 07:47 skrev karolbieniaszewski såhär:
> you have long running transaction
> and i see ODS11.1 then i suppose that this is FB2.x series.
>
> If yes then check
> SELECT * FROM MON$TRANSACTION
> to check what transaction stops garbage collector - you see date and
> time when transaction start
> and follow attachment id to see what process on what computer it is

Thanks Karol, I'll check! but I stress that this gstat -h was executed
with NO OTHER ATTACHMENTS to the database.

Yes, this is FB 2.1.x.

Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64