|Subject||dropping the connection|
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