Thanks, and hi again.

Hmm, this is odd (at least to me).
I did a "gfix -l" and this is what i got:

Transaction 1561932 is in limbo.
Could not reattach to database for transaction 1561932.
Original path: 192.168.1.37:/var/firebird/db/erp_am.fdb
Enter a valid path:
localhost:/var/firebird/db/erp_am.fdb
Could not reattach to database for transaction 1256282.
Original path: 192.168.1.73:/var/firebird/db/erp_sd.fdb
Enter a valid path:

We are running a replication service for both these hosts, but I don't
really understand the clear picture of what's going on here.

Would it be safe to just do a "gfix -c all" ?

Thanks.

Regards,
Faisal

On Wed, 15 Dec 2004 19:58:25 +1100, Helen Borrie <helebor@...> wrote:
> At 03:26 PM 15/12/2004 +0800, you wrote:
>
>
> >Hello,
> >
> >As we speak, my database has an OAT of 4118147 and OIT of 1561932,
> >which gives a gap of
> >2556215. I've done a sweep (during an online database) but it seems
> >that the gap does not move. I can't understand that really.
> >
> > >From my observation, Next transaction keeps on increasing, while OAT,
> >OIT keeps static. For today so far, OAT and OIT hasn't moved since
> >8.30 a.m till 3.24 p.m.
> >We have an average of 100 transactions every 4 seconds.
>
> Well, the classic answer here is that your application code is holding
> transactions open indefinitely. As long as you have a transaction open,
> not hard-committed, not rolled back, it remains active. As long as you
> have rolled back transactions, they remain "interesting" until garbage
> collection or sweeping makes them "uninteresting".
>
> If you have COMMIT RETAINING happening to transactions all over the system,
> with no hard commits, those transacs just remain active and interesting
> forever -- which is why If GC and sweeping don't clear them up.
>
> >--
> >There are many ways of going forward, but there is only one way of
> >standing still --- unless you are talking about Commit Retaining. :-))
>
> ./hb
>
>
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
>
>
> ________________________________
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


--
There are many ways of going forward, but there is only one way of
standing still.