Subject | Page Buffers and memory limits (internal gds software consistency check) |
---|---|
Author | Macma |
Post date | 2008-08-01T10:03:47Z |
Hi,
I'm using Firebird SS 1.5.5 (default settings) on Windows Server 2003 R2
PL Standard Edition with SP2. HP Proliant DL180 G5 with Intel Xeon E5420
and 4 GB RAM, RAID 1+0 on SmartArray P400.
I'm using 5 database and on every database I set Page Buffers to maximum
65535. So it's 65535 * 8k (page size) = 512 MB for each database. It's
look like I need 2560 MB for all database witch gave me some margin for
sorting and others operation.
Bud when I try to connect to this databases I get error "internal gds
software consistency check (cannot start thread)". In firebird log i see:
SYDELSERVER (Server) Wed Jul 30 13:03:04 2008
Database: D:\SYDEL\DANE\BAZYT\TURZADZENIA.FDB
Allocated 13101 page buffers of 32767 requested
SYDELSERVER (Server) Wed Jul 30 13:03:04 2008
Database: D:\SYDEL\DANE\BAZYT\TURZADZENIA.FDB
internal gds software consistency check (cannot start thread)
It's looks like firebird can't allocate more than 2GB of RAM. When I
decrease Page Buffers to lower values so my fb memory usage is below 2GB
every thing look fine bud sometimes I get error that I have not enough
memory for sort operation but I see that I have at least 1,5 GB free RAM
and a lot of disc space.
I switch to firebird 2.1.1.17910 and I had the same problem.
I try to keep pages in memory (as more as I can) because disc operation
is my only bottleneck.
What could be the reason of this behavior ? Any help appreciated.
Regards,
Grzegorz
I'm using Firebird SS 1.5.5 (default settings) on Windows Server 2003 R2
PL Standard Edition with SP2. HP Proliant DL180 G5 with Intel Xeon E5420
and 4 GB RAM, RAID 1+0 on SmartArray P400.
I'm using 5 database and on every database I set Page Buffers to maximum
65535. So it's 65535 * 8k (page size) = 512 MB for each database. It's
look like I need 2560 MB for all database witch gave me some margin for
sorting and others operation.
Bud when I try to connect to this databases I get error "internal gds
software consistency check (cannot start thread)". In firebird log i see:
SYDELSERVER (Server) Wed Jul 30 13:03:04 2008
Database: D:\SYDEL\DANE\BAZYT\TURZADZENIA.FDB
Allocated 13101 page buffers of 32767 requested
SYDELSERVER (Server) Wed Jul 30 13:03:04 2008
Database: D:\SYDEL\DANE\BAZYT\TURZADZENIA.FDB
internal gds software consistency check (cannot start thread)
It's looks like firebird can't allocate more than 2GB of RAM. When I
decrease Page Buffers to lower values so my fb memory usage is below 2GB
every thing look fine bud sometimes I get error that I have not enough
memory for sort operation but I see that I have at least 1,5 GB free RAM
and a lot of disc space.
I switch to firebird 2.1.1.17910 and I had the same problem.
I try to keep pages in memory (as more as I can) because disc operation
is my only bottleneck.
What could be the reason of this behavior ? Any help appreciated.
Regards,
Grzegorz