Recent

Author Topic: Disconnecting TZconnection (zeos) error  (Read 471 times)

fjabouley

  • Jr. Member
  • **
  • Posts: 81
Disconnecting TZconnection (zeos) error
« 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 !!!

« Last Edit: November 29, 2019, 09:52:39 am by fjabouley »

fjabouley

  • Jr. Member
  • **
  • Posts: 81
Re: Disconnecting TZconnection (zeos) error
« Reply #1 on: November 29, 2019, 01:49:32 pm »
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 ?

EgonHugeist

  • Jr. Member
  • **
  • Posts: 66
Re: Disconnecting TZconnection (zeos) error
« Reply #2 on: January 24, 2020, 07:06:25 am »
That's resolve in SVN on SF.net inbetween. Thanks for pointing this out.

fjabouley

  • Jr. Member
  • **
  • Posts: 81
Re: Disconnecting TZconnection (zeos) error
« Reply #3 on: January 24, 2020, 01:16:23 pm »
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.