Guten Tag Adam,

am Montag, 3. November 2008 um 22:51 schrieben Sie:

> --- In firebird-support@yahoogroups.com, Hannes Streicher
> <hstreicher@...> wrote:
>>
>> Hello all ,
>>
>> i have some stuck Transactions since Thrusday, the oldest Active
>> Transaction is not advancing
>>
>> Saturday and Sunday all Machines were turned off , only the server
>> was running , shouldnt dead connections be detected after 2 Hours ?

> This may be an obvious question, but were there any application that
> connect to your database (like a database administration tool) still
> running on your server over the weekend?

yes and no there is one programm which connects to the database entering
orders coming in from the webshop but this application does not show
up in the monitoring tables so it must have closed an commited
properly, it is invoked by a shop email and only runs where
there is work to do shutting down after


in the monitoring tables i can see 5 connections started on thursday
still listed today
and tracing thru the mon$ tables i can nail down the Oldest Active to
one of those connections where the machine was turned off over the
weekend (or better already Thu evening and started again on Friday)



--
Mit freundlichen Grüssen
Hannes Streicher mailto:HStreicher@...