Firebird - Disconnect and inability to reconnect after AbortOperation.

The offical for ZeosLib 7.3 Report problems, ask for help, post proposals for the new version of Zeoslib 7.3/v8
Quick Info:
-We made two new drivers: odbc(raw and unicode version) and oledb
-GUID domain/field-defined support for FB
-extended error infos of Firebird
-performance ups are still in queue
In future some more feature will arrive, so stay tuned and don't hassitate to help
Post Reply
MJFShark
Expert Boarder
Expert Boarder
Posts: 218
Joined: 04.06.2020, 13:59

Firebird - Disconnect and inability to reconnect after AbortOperation.

Post by MJFShark »

Using FB3 server and running a cartesian product join on two large tables (just to have something lengthy to abort.) Calling ZConn.AbortOperation closes the connection and leaves it in a state where it seems that a reconnect doesn't work. Exiting the program is the only solution as far as I can tell.

This may be related to:
viewtopic.php?f=50&t=142053#p175053

I can try to work up a test case, but just wondering if anyone else sees this issue. Thanks!

The error message shown is:
Project raised exception class EZDatabaseConnectionLostError with message
'SQL Error: Error writing data to the connection.;
GDS Code: 335544727;
Unsuccessful execution caused by a system error that precludes successful
execution of subsequent statements; send_packet/send;
GDS Code: 335544382;
Unsuccessful execution caused by system error that does not preclude successful
execution of subsequent statements Code: -902'.
marsupilami
Platinum Boarder
Platinum Boarder
Posts: 1956
Joined: 17.01.2011, 14:17

Re: Firebird - Disconnect and inability to reconnect after AbortOperation.

Post by marsupilami »

A test case would be good in any case. Although I am not sure on how to integrate these into the test suite ;) But there are other people having problems too. You might want to test wether this can be solved by switching back to the old ISC API.
Post Reply