I have tried a gfix - list to get all limbo transactions and none are
listed, when I try either a gfix-commit or gfix-rollback it says the
transaction is not in limbo, it is active and this it cannot either
commit or rollback that transaction for me.

Forced Writes is on (this is a windows 2000 server with 1gb RAM and dual
processor.)
The sweep interval is 20000 but it does not get called as it was
explained to me that the sweep interval is the definition between the
oldest transation and the oldest active transaction, and as you can see
from the stats these are 1 transaction apart.

I have not tried a gfix -sweep, the database is used 24/7 by a medical
service so I pretty reluctant to force them anymore slowdown during
operation times that necessary, they are already pretty annoyed that we
are having to backup and restore them to resolve the issue atleast once
a week.

I appreciate your help on this matter, any other suggestions are
welcomed as I need to resolve this... I have other customers that are
just as busy using IB 5.6 that in fact have slower older hardware as
servers but do not get this problem, some also have the transaction gap
problem but do not report slowness......

TIA


Martin Dew
Senior Developer
Adastra Software Ltd.
Unit 4, Eurogate Business Park, Ashford, Kent TN24 8SB
Tel: (01233) 722700 Fax: (01233) 722701 www.adastra.co.uk


-----Original Message-----
From: Daniel Rail [mailto:daniel@...]
Sent: 24 November 2003 15:48
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] long running active transactions ??

Hi,

At November 24, 2003, 08:45, Martin Dew wrote:

> I cannot replicate or find how my apps are doing this but on occasions

> I have a header statistics from the database as follows;

> OT 566738
> OAT 566739
> NT 940551
> OS 564916

> Even if I log all applications out the transactions do not catch up
> with themselves.. So my question is I am seriously considering moving
> to FB
> 1.5 once it is in full release, is there a way that I can type in the
> oat and get rid of the transaction so that the Transactions all catch
> up ? I have tried with interbase to use the gfix -commit [trans
> number] and it just says that the transaction is active, even if I
> have no connections to interbase.

It could be a transaction in limbo! Because, what are those statistics
after a backup/restore? If the OAT is still the same, have you tried
gfix -rollback (instead of gfix -commit)?

> Wouldn't it be nice to have a command that you can run that just
> resets all transactions and memory allocations, so if you know that
> no-one on a site is connected and doing anything to your database you
> can just say right, lets set IB/FB as though we have done a backup and

> restore and start from the beginning again..

Have you tried gfix -sweep (it forces garbage collection)?
What is your sweep interval?
Do you have Forced Writes ON or OFF?

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)



To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/