[firebird-support] Problem with Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements

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

Re: [firebird-support] Problem with Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements

wrote: On Fri, 10 Oct 2014 12:43:42 +0300, Harriv har...@gmail.com [firebird-support] firebird-support@yahoogroups.com wrote: My application generates following errors occasionally: Error writing data to the connection. Unsuccessful execution caused by a system error that precludes

[firebird-support] Optimization help: is null and not null?

Hi, 3rd party application is doing following query: SELECT * FROM V_MY_VIEW WHERE V_MY_VIEW.HANDLED_TIMESTAMP IS NOT NULL AND V_MY_VIEW.RECEIPT_TIMESTAMP IS NULL V_MY_VIEW is simple view with: SELECT * FROM MY_TABLE WHERE STATUS 0 . This query doesn't return many rows (if any),

[firebird-support] Occasional server hangs/major slowdowns

Hello, Every now and then (about week or two) one of my systems hangs, and it seems to be related to Firebird server. I'm running Firebird 2.5.2 on 32-bit Windows 7 as SuperServer. It looks like Firebird server process stops responding. Usually I've restarted the server process, but today I