On Fri, 10 Oct 2014 12:43:42 +0300, "Harriv [email protected] [firebird-support]" <[email protected]> wrote: > My application generates following errors occasionally: > > Error writing data to the connection. > > Unsuccessful execution caused by a system error that precludes successful > execution of subsequent statements > > GDS Code: 335544727 Error Code: 407 > > And: > > GDS Code: 335544726 Error Code: 406 > > And sometimes: > > GDS Code: 335544332 Error Code: 12 > > These come from simple select -statement, which is executed pretty often > (every few seconds). > > What could cause this problem? According to error code list this e > connection problem, but Firebird log doesn't show extra disconnects. > > Is this caused by the client side or does this come from server? Can the > root cause be in another application accessing the database or is it the > same application where the error occurs? The system has about 5 active > applications accessing the database all the time. > > Is there any way to debug this from server side? > > Earlier I had similar problems when using same connection from multiple > threads, but that should be fixed.
Errors: 335544726=Error reading data from the connection. 335544727=Error writing data to the connection. These are usually thrown for network related errors, which are normally only client-side AFAIK. Without more information (eg platform, connection library, etc) it is hard to provide more help. Error 335544332=invalid transaction handle (expecting explicit transaction start) Means that you (or the access component) are handling transactions incorrectly. Make sure that you don't concurrently use **the same** connection from **multiple** threads. None of these error have to do with concurrent access by other applications or other connections. Mark
