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'.
Firebird - Disconnect and inability to reconnect after AbortOperation.
-
- Platinum Boarder
- Posts: 1956
- Joined: 17.01.2011, 14:17
Re: Firebird - Disconnect and inability to reconnect after AbortOperation.
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.