Subject | Too many savepoints (287) |
---|---|
Author | xuxu |
Post date | 2005-10-20T09:27:36Z |
firebird-support!
My firebird will become slowly after about 4 hours hard working .
( 4000 reads/hour, 4000 update/hour, 2000 insert/hour )
I can find this in /opt/firebird/firebird.log :
-------------------------------------------------------------------
localhost.localdomain (Server) Thu Oct 20 12:11:06 2005
Database: /opt/interbase/data/AccountData.gdb
internal gds software consistency check (Too many savepoints (287))
-------------------------------------------------------------------
I will show u the DB info:
-----------------------------------------------------------------------
Database "/opt/interbase/data/AccountData.gdb"
Database header page information:
Flags 0
Checksum 12345
Generation 497561
Page size 4096
ODS version 10.1
Oldest transaction 496725
Oldest active 496726
Oldest snapshot 496726
Next transaction 497552
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 19
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jun 4, 2004 9:44:42
Attributes
Variable header data:
Sweep interval: 0
*END*
-rw-r--r-- 1 root root 309435904 Oct 20 01:02 AccountData.gbk
-rw------- 1 root root 549576704 Oct 20 17:29 AccountData.gdb
-------------------------------------------------------------------------------------
What is the probably reason ?
2005-10-20
My firebird will become slowly after about 4 hours hard working .
( 4000 reads/hour, 4000 update/hour, 2000 insert/hour )
I can find this in /opt/firebird/firebird.log :
-------------------------------------------------------------------
localhost.localdomain (Server) Thu Oct 20 12:11:06 2005
Database: /opt/interbase/data/AccountData.gdb
internal gds software consistency check (Too many savepoints (287))
-------------------------------------------------------------------
I will show u the DB info:
-----------------------------------------------------------------------
Database "/opt/interbase/data/AccountData.gdb"
Database header page information:
Flags 0
Checksum 12345
Generation 497561
Page size 4096
ODS version 10.1
Oldest transaction 496725
Oldest active 496726
Oldest snapshot 496726
Next transaction 497552
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 19
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jun 4, 2004 9:44:42
Attributes
Variable header data:
Sweep interval: 0
*END*
-rw-r--r-- 1 root root 309435904 Oct 20 01:02 AccountData.gbk
-rw------- 1 root root 549576704 Oct 20 17:29 AccountData.gdb
-------------------------------------------------------------------------------------
What is the probably reason ?
2005-10-20