Invalid statement handle
------------------------
Key: CORE-4972
URL: http://tracker.firebirdsql.org/browse/CORE-4972
Project: Firebird Core
Issue Type: Bug
Affects Versions: 3.0 RC 1
Reporter: Tim Kelly
Error: "invalid statement handle"
I have recently updated to a recent snapshot (2015-10-21). Since then I keep
getting apparently random error messages when executing SQL statements.
I am using snapshot of 21/10/15. (server x64 win, client x32 win), Delphi IBX
components.
[09:12:02] (Error)-> Error executing SQL: <INSERT INTO SOS_BASE_PERSISTENT_OBJEC
T (OID, DELETED, CREATED, UPDATED, SMART_CLASS_OID, IMPORT_KEY) VALUES (:OID, :D
ELETED, :CREATED, :UPDATED, :SMART_CLASS_OID, :IMPORT_KEY)>invalid statement
handle
Not quite sure when this problem was introduced but it wasn't present about 6
months ago in version 3.
I think this statement would have been executed previously during a different
transaction. It would have been executed a second time with different
parameters following a transaction->commit, transaction->begin. My software has
been stable for about 10 years so i am pretty sure it's not something I have
introduced.
I also have started receiving:
SQL error code = -502
Invalid cursor declaration
Statement already has a cursor {612A1D09-A255-4781-8DF1-54B24A9C4B3E} assigned
[09:18:51] (Error)-> Request generated error: Dynamic SQL Error
I suspect this is a secondary error as I always get the invalid statement
handle first.
--
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
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
