Stability issue after "object in use" error
-------------------------------------------
Key: CORE-3789
URL: http://tracker.firebirdsql.org/browse/CORE-3789
Project: Firebird Core
Issue Type: Bug
Components: API / Client Library
Affects Versions: 2.5.1
Environment: - Windows XP SP3
- Delphi 7
- Devart dbexpress driver 2.70.0.27
Reporter: Emmanuel ZURMELY
After creating and dropping temporary tables, sometimes the drop fails with an
"object in use" error.
This error is handled properly and the application continues to execute SQL
statements.
However, after the first time this error occurs, the application becomes
unstable: creating and executing new SELECT queries works, but when releasing
these query objects, an exception with the same error message "object in use"
as before is raised. The error occurs when releasing the dataset of SELECT
statements that are executed after the initial DROP TABLE which encounters the
"object in use" error. It seems that the previous error state is not well
cleared and that the error remains present somewhere in the client.
I have tested with the 2.5 and 2.1 FB clients, the problem is very reproducible.
With the 1.5.6.5026 FB client, I did not reproduce the problem.
Not knowing if the problem is related to the client or the driver, I have also
posted this issue to Devart's issue tracker :
http://www.devart.com/forums/viewtopic.php?p=79190
--
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
------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
