Subject Re: [firebird-support] Finding and killing transactions
Author JD FitzGerald
Helen Borrie wrote:
> At 11:30 AM 13/01/2005 +0000, you wrote:
>>Is there any way to list all the transactions active in a database?
> No.

Is there any plans for this? I could imagine it being useful.

>>A transaction from an app that crashed is locking a record in the
>>database and I'd like to roll it back.
> You can't target a transaction from another transaction, which means you
> can't (currently) kill a transaction.

But this is planned for future versions?

> However, the server will detect the crashed connection eventually
> (depending on the network's keep_alive timeout setting) and will do the
> appropriate cleanup. Stopping and restarting the server will also have the
> effect of invalidating dead transactions.

Thanks, I think I'll be patient and hope the timeout ain't too long.