Subject Re: [firebird-support] dropping the connection
Author Mark Rotteveel
On 2017-02-21 17:32, Nick Upson nu@... [firebird-support] wrote:
> Hi
>
> The problem I'm trying to solve is users leaving inactive db_workbench
> sessions attached to a database while other work is going on by other
> processes, causing a large OIT gap and the consequent problems. The
> solution needs to be automatic and unattended.
>
> db_workbench doesn't have a timeout setting (I asked)
>
> deleting the row from mon$statements doesn't kill the transaction;
> deleting the row from mon$transactions or mon$attachments gives
> "operation not supported"
>
> I could automate a kill of the fb_inetserver process but I would
> rather something with less risk
>
> I figure other people have had this and solved it before, I hope.
>
> currently using firebird 2.1 on centos, shortly moving to 2.5


Killing connections by deleting from MON$STATEMENTS requires Firebird
2.5 and an ODS 11.2 database (so you will also need to backup and
restore the database when migrating to Firebird 2.5!).

Mark