Hello,
we use asynchronous function fb_cancel_operation (fb_cancel_raise) for
interruption long running operations.
During implementation, we encountered the problem that is described in
http://tracker.firebirdsql.org/browse/CORE-4004
(Sometimes long-running operations cannot be interrupted by asynchronous
shutdown / cancellation requests)
However, it is not our problem.
We have problem with data modification after fb_cancel_operation API call. Our
client correctly received isc_cancelled error from connection. At this point
data is modified (there has been no explicit commit of transaction witch
modified data)
We don't have simple steps to reproduce this problem. The problem occurs only
after huge triggers/stored procedures activity inside previous transaction
(this transaction is rolled back). We analyzed trace log without any success.
The last reference to transaction witch modified data is inside block "FAILED
EXECUTE_TRIGGER_FINISH".
Do you have any suggestions on how to proceed in solving this problem? Thank
you for discussing this behavior.
David Petrík, Czech Republic
Server Version: 2.5.2 (Stable)
Client Components: Delphi / IBObjects
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
