Look like bug in Firebird (server or client). I suggest to send it to Firebird Support or Devel Group
Cheers A Pham <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello: > > Looks like you are runnint the inserts using always implicit > trasnactions what will cause 25000 transactiosn to be created and > committed, try using explicit transactions. > > ----Mensaje original---- > De: [EMAIL PROTECTED] > Recibido: 25/10/2005 10:29 > Para: > <Firebird-net-provider@lists.sourceforge.net> > Asunto: [Firebird-net- > provider] High load causing server quit? > > Hi all. > > I'm using 1.7a (is > this the most recent stable build? > the web page says 1.6.3 is but > doesn't provide links > to download it...) for some simple tests. > > I have > a loop inserting items into a test DB by > building a string, creating a > NpgsqlCommand and > calling ExecuteNonQuery. The same connection is used > for all the inserts. > > However, if I insert more than 25,000 rows an > exception is thrown and the Firebird server process > exits! > > Am I doing > something wrong? > > > Exception details: > > Started up at 25/10/2005 08:48: > 48 , > Initialising connection... > using ADO > on Firebird 00: > 00:02.0625000 > Deleting... , 00:00:02.4062500 > Populating 100 > categories... , 00:00:01.2656250 > Populating 25000 products... , > Unhandled Exception: > FirebirdSql.Data.Firebird.FbException: Error > reading > data from the connection. > at FirebirdSql.Data.Firebird. > FbTransaction.Commit() > at > FirebirdSql.Data.Firebird.FbCommand. > CommitImplicitTransaction() > at > FirebirdSql.Data.Firebird.FbCommand. > ExecuteNonQuery() > at OPathExperiments.AdoTests.PopulateProducts > (Int32 > number, Int32 maxPrice) > at OPathExperiments.Program.RunTests > (IDBTests > tests, DBType dBType, String connectionString) > at > OPathExperiments.Program.Main(String[] args) > > Cheers. > > > > > > ___________________________________________________________ > Yahoo! > Messenger - NEW crystal clear PC to PC calling worldwide with voicemail > http://uk.messenger.yahoo.com > > > ------------------------------------------------------- > This SF.Net > email is sponsored by the JBoss Inc. > Get Certified Today * Register for > a JBoss Training Course > Free Certification Exam for All Training > Attendees Through End of 2005 > Visit http://www.jboss. > com/services/certification for more information > _______________________________________________ > Firebird-net-provider > mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists. > sourceforge.net/lists/listinfo/firebird-net-provider > > > > > > ------------------------------------------------------- > This SF.Net email is sponsored by the JBoss Inc. > Get Certified Today * Register for a JBoss Training Course > Free Certification Exam for All Training Attendees Through End of 2005 > Visit http://www.jboss.com/services/certification for more information > _______________________________________________ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > ------------------------------------------------------- This SF.Net email is sponsored by the JBoss Inc. Get Certified Today * Register for a JBoss Training Course Free Certification Exam for All Training Attendees Through End of 2005 Visit http://www.jboss.com/services/certification for more information _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
