The databse that I have has no clients connected to it(other than gstat and maybe ibconsole), but still there is a gap.
-gili

-----Original Message-----
From: Ann W. Harrison [mailto:aharrison@...]
Sent: Thursday, April 07, 2005 5:55 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Re: Performance when deleting a lot of records, again


Gili Buzaglo wrote:

>
> But how do I know which transaction was not commited ?

That, unfortunately, is hard. Here is a suggestion that might work,
assuming you can reproduce the problem outside a production environment.

1) Get the database in a state where there is a large gap in transaction
numbers.

2) Shut down one client at a time, doing a gstat -h after each shutdown.

3) When the oldest active value moves, you've found a client that has a
long-lived transaction.

You'll probably have to do this several times - it's possible that every
client has an open snapshot.

Alternately, you can start clients slowly and watch for the gap to start
growing.


Regards,


Ann



_____

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 <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]