Subject Re: [firebird-support] Unhandled dead client connection
Author Hannes Streicher
Guten Tag Alan McDonald,

am Dienstag, 27. Januar 2009 um 08:26 schrieben Sie:

>> they do get cleaned up, sometime , i had cases when it took more then
>> 9 days (ie 2 full weekends with no one working )
>> (same system setup /w2k3 server xp ans vista clients, fb2.1.1 )
> I'm afraid my experience is the same as Michael's. They *may* eventually get
> cleaned up, but unfortunately they stay for long enough to sometimes create

yes this problem shows up sometimes, but sometimes i am lucky and just
sit it out :)

> a record lock which does not go away without intervention. That's when my
> clients ring me. They have everyone disconnect and I can still see a
> connection/user. I was hoping 2.1 would give me the ability to drop this
> connection without resorting to restarting the service. Is that not the
> case?

nope, i have tried it with the monitoring tables

delete from mon$statements

delete from mon$transactions

delete from mon$attachments

in all possible combinations

no result

Mit freundlichen GrĂ¼ssen
Hannes Streicher mailto:HStreicher@...