Hi,

Thanks for your suggestions. I set page Buffers to 75, confirmed all of the DBs had this set to 0. Ive also setup tempfs as you described.

After a few days testing its much better but the problem is still there - at present I have 8 users connected to 4 dbs and anyone else logging in is still getting the memory allocation problem.

This is the result of free and df -h at the time I was getting the error:

total used free shared buffers cached
Mem: 4046784 1295932 2750852 0 221028 702480
-/+ buffers/cache: 372424 3674360
Swap: 2096376 0 2096376

[~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/md2 70G 19G 48G 28% /
/dev/md0 289M 34M 241M 13% /boot
tmpfs 2.0G 0 2.0G 0% /dev/shm
/usr/tmpDSK 1.0G 3.4M 1021M 1% /tmp
tmpfs 1.0G 3.4M 1021M 1% /tmp

This is my FB server properties

Server Version Info
----------------------------------------------------------------------
Server Version: LI-V2.5.0.26074 Firebird 2.5
Server Implementation: Firebird/linux AMD64
Service Version: 2

Configuration Info
----------------------------------------------------------------------
Base File: /opt/firebird/
Lock File: /tmp/firebird/
Message File: /opt/firebird/
Security Database: /opt/firebird/security2.fdb

Database Info
----------------------------------------------------------------------
Number of connections: 8
Number of databases: 4

Ive also set my xinetd.conf as follows :

cps = 5000 1000
instances = 500
per_source = 200

Not sure what memory its trying to allocate because server resources are about 95% free at all times.

Any suggestions would be greatly appreciated.

Cheers,
Kris

--- In firebird-support@yahoogroups.com, Philippe Makowski <makowski@...> wrote:
>
> 2011/2/17 Kris B <b.kris24@...>
> >
> > total used free shared buffers cached
> > Mem: 4046784 905792 3140992 0 195728 428392
> > -/+ buffers/cache: 281672 3765112
> > Swap: 2096376 0 2096376
> >
> > This is the result of free - at that time there were 6 users connected to 3 DBs.
> >
> so you should not have problem if you let 75 as page Buffers when you
> use Classic or SuperClassic
>
> if you want to use more ram, use tmpfs
> Firebird can use it for temporary files need for sort, etc ...
> and let ram so your filesystem manage its own cache
>
> http://wiki.centos.org/TipsAndTricks/TmpOnTmpfs
>