From: SourceForge.net <no...@so...> - 2006-02-28 14:56:25
|
Field-test item #1435997, was opened at 2006-02-21 17:02 Message generated for change (Comment added) made by martinalex You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=593943&aid=1435997&group_id=9028 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Submitted By: martinalex (martinalex) Assigned to: Nobody/Anonymous (nobody) Summary: Close database error -901 for embedded server Initial Comment: The embedded server returns error -901 when closing the database. Error message is: SQL Error: invalid statement handle. Error Code: -901. Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements The error does not happen for the server version, only for the embedded server. The error does happen most times when 'several' (more than 20) records are inserted or updated. For read only the error does never happen. Version used 2.0 b 2 on Win XP Pro SP2 The error happens for function isc_detach_database. ---------------------------------------------------------------------- >Comment By: martinalex (martinalex) Date: 2006-02-28 15:56 Message: Logged In: YES user_id=889091 I can't get the packed exe smaller than 277 kb, so i will split it in 2 parts. close-test.7z.001 and close-test.7z.002 ---------------------------------------------------------------------- Comment By: martinalex (martinalex) Date: 2006-02-28 14:47 Message: Logged In: YES user_id=889091 Attachmant added with source and test FDB. Unfortunately the exe is too large to add. ---------------------------------------------------------------------- Comment By: martinalex (martinalex) Date: 2006-02-28 14:36 Message: Logged In: YES user_id=889091 Error -901 has only to do with the usage of a stored procedure. Test application FBClose.exe in close-test.zip aborts for disconnect with error -901 only after generator value has been increased with a stored procedure. Error happens in function isc_detach_database. Error does not happen for Firebird client. ---------------------------------------------------------------------- Comment By: Dmitry Yemanov (dimitr) Date: 2006-02-22 14:58 Message: Logged In: YES user_id=61270 Could you prepare a simple test case and upload it here? ---------------------------------------------------------------------- Comment By: martinalex (martinalex) Date: 2006-02-22 08:37 Message: Logged In: YES user_id=889091 I could narrow down the error. The error is independent from inserts and updates and happens only when any stored procedure had been used before. It's a simple stored procedure to return the next generator key. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=593943&aid=1435997&group_id=9028 |