Subject Firebird 1.5.1 dies under load
Author Delmerico, James
Hello.



I am load testing a small application built on top of Firebird. During my
testing I have consistently caused Firebird to abnormally terminate with 10
concurrent users within a minute of starting the load. The error I see in
the log is "C:\Program Files\Firebird\bin\fbserver.exe: terminated
abnormally (4294967295)".



The database I am testing with is tiny (8 tables, < 100 rows total, no BLOB
data) and so far I'm only performing reads (no writes or deletes).



The server configuration is:

Dell 2650 Server (2-2.6 ghz processors. Hyperthreaded (disabled))

Windows Server 2003

1G memory

33G hd (30G free)

10mb connection between server and client (load generator)



I have verified that hyperthreading is disabled and I have attempted setting
CPU affinity (tried 1 and 2 for values).



I am using the 1.5.1 release of Firebird Superserver. During the process I
disabled the Guardian service.



The server software is .NET-based using the firebird .NET provider. I have
tried a few different connection strings with mainly this form:

Server=localhost;Database=tesla;User=SYSDBA;Password=masterkey;Pooling=false
;Packet Size=8192;



Connection pooling has been on and off with no affect. I've also tried
specifying the server by IP, also with no affect.



The configuration for Firebird is the default other than the cpu affinity
changes I mentioned earlier.



I wouldn't expect 10 concurrent users only performing reads to bring down
Firebird, so I expect it's my configuration or use.



Any help would be appreciated.







[Non-text portions of this message have been removed]