Subject | Re: [firebird-support] Re: Oldest transaction far behind... |
---|---|
Author | Kjell Rilbe |
Post date | 2011-03-22T06:54:54Z |
Den 2011-03-22 07:47 skrev karolbieniaszewski såhär:
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
> you have long running transactionThanks Karol, I'll check! but I stress that this gstat -h was executed
> 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
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