Firebird - Disconnect and inability to reconnect after AbortOperation.
Posted: 28.03.2022, 18:31
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'.
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'.
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.