2011/2/16 b.kris24 <b.kris24@...>

> Hi all!
> New member to the group but a long time Firebird user!
> Ive always used Firebird on Windows servers but have recently started using a web based Linux server. I currently have 3 small dbs (3,5 and 8mb) on the server and have around 3 users per db concurrently logged on (so pretty tiny really).
>
> After a few people are logged in new users logging in get "unable to allocate memory from operating system" or if they are already in "sort error - not enough memory". Ive checked the temp dir and there is lots of space (400mb+ unused) and also tried Super Server and had the same problem. My firebird.conf is default at the moment although ive tried changing DefaultDbCachePages, FileSystemCacheThreshold etc but always end up with the same problem.
> Really hope somebody can help as Ive Googled the hell out of it and found nothing that helped!
>
> Cheers,
> Kris
>
> Server Spec :
> Dual Core Intel E3110 @3Ghz
> 4 Gb Ram
> Centos 5.5 x86_64 Standard
> Tmp Dir - 485mb 448mb available

can you tell us more ?
how did you set up Firebird, from what package ?
what is running on this box ?
did you restored databases on this box ?
what is your connection string ?
what is the result of free ?
did you checked your os limits ?
what give a gstat -h for you databases ?

note Centos 5 is now a old system, Firebird 2.5 can't be built on it
out of the box
RHEL6 clones take time to come