Another strange fact : Running 1 application with 250 thread where each thread connects to 2 database and runs 2 select works perfectly, BUT
Running 50 application with 5 thread where each thread connects to 2 database and runs 2 select throw errors mentioned eralier. --- In firebird-support@yahoogroups.com, "ma_golyo" <ma_golyo@...> wrote: > > Hi! > > Cannot connect to server under heavy load. > I get "connection rejected by remote interface" (335544421). > > Is this a bug, ot there is an option in firebird.conft to avoid this? > > > Firebird.log (FB20 Classic Server) > L3S-4 Wed Oct 24 14:04:28 2012 > I/O error for file "C:\PROGRAM > FILES\FIREBIRD\FIREBIRD_2_0\SECURITY2.FDB" > > > L3S-4 Wed Oct 24 14:04:28 2012 > lock conflict on no wait transaction > > > L3S-4 Wed Oct 24 14:04:32 2012 > Error while trying to access file > > > L3S-4 Wed Oct 24 14:04:32 2012 > no permission for read-write access to database C:\PROGRAM > FILES\FIREBIRD\FIREBIRD_2_0\SECURITY2.FDB > > > L3S-4 Wed Oct 24 14:04:36 2012 > The process cannot access the file because it is being used by another > process >