Subject open transaction after broken connection
Author Olaf Kluge
Hello,

I'v a little problem.

We have a vpn-connection to our customer. One of the two parts has
disconnectet the connection. Now I have an open transaction (seen with the
follow sql-statement:

select
mt.mon$transaction_id,
ma.mon$remote_address,
ma.mon$remote_process,
ma.mon$attachment_name,
ms.mon$timestamp,
ms.mon$sql_text
from mon$transactions mt
left join mon$attachments ma on ma.mon$attachment_id=mt.mon$attachment_id
left join mon$statements ms on ms.mon$transaction_id=mt.mon$attachment_id
)

How can I reset the broken transaction?

Thank you.

Regards


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