On 2017-02-21 17:32, Nick Upson n...@telensa.com [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