--- In firebird-support@yahoogroups.com, Philippe Makowski <makowski@...> wrote:

>
> 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
>

OK I setup from package FirebirdCS-2.5.0.26074-.amd64.rpm . All installed fine (same for SS)
The only other thing running on this box is WHM with 2 cPanels
Yes the databases were restored onto the box
I use IBX TIBDatabase to access (I know its not officially supported but I have the same app running on a Windows Firebird 2.5 SS with 15 users and all is fine)
Could you elaborate on :

> what is the result of free ?
> did you checked your os limits ?

Gstat Results (DB1)
Flags 0
Checksum 12345
Generation 113947
Page size 4096
ODS version 11.2
Oldest transaction 95620
Oldest active 113512
Oldest snapshot 113512
Next transaction 113833
Bumped transaction 1
Sequence number 0
Next attachment ID 3598
Implementation ID 26
Shadow count 0
Page buffers 2048
Next header page 0
Database dialect 1
Creation date Oct 20, 2010 1:04:22
Attributes force write
Variable header data:
Sweep interval: 20000

Gstat DB 2

Database header page information:
Flags 0
Checksum 12345
Generation 10108
Page size 4096
ODS version 11.2
Oldest transaction 1183
Oldest active 9821
Oldest snapshot 9821
Next transaction 10033
Bumped transaction 1
Sequence number 0
Next attachment ID 293
Implementation ID 26
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 1
Creation date Jan 28, 2011 4:50:45
Attributes force write
Variable header data:
Sweep interval: 20000
Gstat DB 3
Database header page information:
Flags 0
Checksum 12345
Generation 41364
Page size 4096
ODS version 11.2
Oldest transaction 27779
Oldest active 41285
Oldest snapshot 41285
Next transaction 41315
Bumped transaction 1
Sequence number 0
Next attachment ID 1439
Implementation ID 26
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 1
Creation date Oct 20, 2010 1:04:22
Attributes force write
Variable header data:
Sweep interval: 20000

When only a few users are connected everything runs fine, I can see the lock files and session files being written in tmp with lots of spare space. Firebird is never using much more than 5% RAM.
Is the memory allocation problem related to RAM or HDD?
I noticed earlier today that a SpamAssasin process was running as user Firebird and also one as root. Ive uninstalled this now.

Thanks for the help,
Kris