Subject RE: [firebird-support] I/O error or Internal gds error when running many concurrent transactions
Author Alan McDonald
> Hi,
> I have a thread repeatly inserts and updates several tables (with
> triggers). When I run 100 instances of the same thread, sometimes when
> starting the application I received the following exception, either
> the first or the second:
> 1. FirebirdSql.Data.FirebirdClient.FbException: I/O error for file
> CreateFile (open) "tmcdb.fdb" Error while trying to open file
> 2. FirebirdSql.Data.FirebirdClient.FbException: internal gds software
> consistency check (can't continue after bugcheck)
> I used Firebird superserver to create the template
> database, and used fbembed.dll(v. to run the server in
> embedded mode.
> The problem only occurs at the first round of threads' execution. If
> the first round is fine, it will continue running with no problem.
> How can I avoid this?
> Thank you very much!
> Sean

java? .NET?
anyway - are you ensuring that each thread is using it's own connection? if
we knew what language/connection components used we could indicate some
other requirements.