> 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?

If you run v2.5 you can just DELETE FROM MON$ATTACHMENTS.

Else you can identify and close socket used by this broken connection. On Windows you can use, for example TcpView, to do it. Can't say much for other OSes.

BTW, this is strange that second part of VPN connection still alive. Probably your VPN software have some timeout to reset such connections. In this case you can just wait for it to happens.

Regards,
Vlad