Subject Re: Cannot connect to server under heavy load
Author ma_golyo
Increasing the thread numbers the same error appears when only 1 application runs with many threads...

--- In firebird-support@yahoogroups.com, "ma_golyo" <ma_golyo@...> wrote:
>
> 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
> >
>