Subject | open transaction after broken connection |
---|---|
Author | Olaf Kluge |
Post date | 2010-05-03T09:01:08Z |
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]
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]