Lazarus
Programming => Databases => Topic started by: fjabouley on November 28, 2019, 08:31:55 am
-
Hi all !!
I'm facing an issue while trying to disconnect a TZconnection component.
I recently updated lazarus (2.0.6) and zeos (7.2.6), everything worked well before update (firebird database), but when I try now to restore database from my software, and try to disconnect the database before doing that (TZconnection.disconnect) , I got an error message : "Cannot disconnect database with open transactions (1 active) error -901"
I tried to close all TZquery components, rollback everything, etc.... but unfortunately it doesn't work..
I can't see any transactions in MON$TRANSACTIONS too...
Has anybody faced this issue ?
(I'm using TFBadmin to restore db)
Regards !!!
-
I reinstalled Zeos 7.2.4 and then it works again.
Seems that with 7.2.6, the connection keeps working (an attachment in MON$ATTACHMENTS is still present) , although you try to disconnect or free TZconnection component...
Is that a bug ? Does someone has the same behavior ?
-
That's resolve in SVN on SF.net inbetween. Thanks for pointing this out.
-
Works with SVN files ! Thanks, and sorry for being so annoying with firebird and zeos, the workaround with connection.starttransaction and commit also seems to work to... To be continued...
I'll check in few days if, when I shutdown server, it takes time to make a new request.
Many thanks again for your answers.