I’ve had a similar problem with another database doing the same thing. My problem was that I had another program running and it was locking the file system and looking for updates on my drivers periodically; also I would assume that windows update might cause problems too. Maybe check to see if the connection is open and active, if not try to connect again, if it fails again wait a specified time, and then try again, fails that time trap the error and show a message box describing the problem. I don’t use NHibernate... just a thought it might be something else...
From: korkless Sent: Thursday, February 24, 2011 12:47 AM To: firebird-net-provider@lists.sourceforge.net Subject: [Firebird-net-provider] problem with a random io exception hi all, i have a form application which will create/insert data into a firebird db. i'm using fb embedded 2.5 with the net provider 2.6 (and nhibernate). my application works on a single table, it will insert a single row per transaction with a low rate (<10 insert for minute). my problem is that after same hours that it works correctly a random excpetion will make it crash. this is the exception stack NHibernate.TransactionException: Commit failed with SQL exception ---> FirebirdSql.Data.FirebirdClient.FbException: I/O error during "WriteFile" operation for file "C:\PROGRAMDATA\COMPANY\DBFILE.FDB" Error while trying to write to file ---> I/O error during "WriteFile" operation for file "C:\PROGRAMDATA\COMPANY\DBFILE.FDB" Error while trying to write to file --- Fine dell'analisi dello stack dell'eccezione interna --- in FirebirdSql.Data.FirebirdClient.FbTransaction.Commit() in NHibernate.Transaction.AdoTransaction.Commit() note: the file is open/used only by that application the exception appears to be throw on random time, sametime after 2 hours, sametime after 10 hours. sametime the exception is about ReadFile the application is running on win 7 professional from a normal user account (it has read/write ability to the db file) i don't know if this problem is related to the provider or to firebird, if is related only to firebird sorry if i posted there. thanks -------------------------------------------------------------------------------- ------------------------------------------------------------------------------ Free Software Download: Index, Search & Analyze Logs and other IT data in Real-Time with Splunk. Collect, index and harness all the fast moving IT data generated by your applications, servers and devices whether physical, virtual or in the cloud. Deliver compliance at lower cost and gain new business insights. http://p.sf.net/sfu/splunk-dev2dev -------------------------------------------------------------------------------- _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
------------------------------------------------------------------------------ Free Software Download: Index, Search & Analyze Logs and other IT data in Real-Time with Splunk. Collect, index and harness all the fast moving IT data generated by your applications, servers and devices whether physical, virtual or in the cloud. Deliver compliance at lower cost and gain new business insights. http://p.sf.net/sfu/splunk-dev2dev
_______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
