--- In firebird-support@yahoogroups.com, Kjell Rilbe <kjell.rilbe@...> wrote:

>
> 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
>

What is your "Sweep interval" setting for database?
Is it 0?
If yes then you set that you mannually run sweep process if not then what is value?

try gfix -sweep
and then gstat -h is this now ok?

Karol Bieniaszewski