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