Error "Attempt to reopen an open cursor" may be raised if the query handle is
reused in a different transaction
---------------------------------------------------------------------------------------------------------------
Key: CORE-4313
URL: http://tracker.firebirdsql.org/browse/CORE-4313
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 Alpha 1, 3.0 Alpha 2
Reporter: Dmitry Yemanov
Call sequence that demonstrates the issue:
isc_dsql_allocate_statement(status, &db, &st);
isc_start_transaction(status, &tr, 1, &db, 0, NULL);
isc_dsql_prepare(status, &tr, &st, 0, "select 1 from rdb$relations", 1, sqlda);
isc_dsql_execute(status, &tr, &st, 1, NULL);
while (isc_dsql_fetch(status, &st, 1, sqlda) == 0);
isc_commit_transaction(status, &tr);
isc_start_transaction(status, &tr, 1, &db, 0, NULL);
isc_dsql_free_statement(status, &st, DSQL_close);
-- here error is raised
isc_dsql_execute(status, &tr, &st, 1, NULL);
while (isc_dsql_fetch(status, &st, 1, sqlda) == 0);
isc_dsql_free_statement(status, &st, DSQL_drop);
isc_commit_transaction(status, &tr);
The issue is caused by the cursor not being explicitly closed before
transaction commit/rollback. It worked in prior versions, but in v3.0 this
sequence leads to leftover cursor pointers causing the error to be thrown.
P.S. Given the known details, I'm not sure it's the same issue as CORE-3984.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT
organizations don't have a clear picture of how application performance
affects their revenue. With AppDynamics, you get 100% visibility into your
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
