Subject | RE: [firebird-support] Stability problems |
---|---|
Author | Santiago Cordoba |
Post date | 2004-06-28T08:16:24Z |
Hi:
<Do you have Forced Writes ON or OFF?
<What is the header statistics of the database? The database header
<"might" give some indication as to what is happening.
<You can use the GSTAT command-line to retrieve both information.
Here It is:
Database header page information:
Flags 0
Checksum 12345
Generation 5401040
Page size 8192
ODS version 10.1
Oldest transaction 5396132
Oldest active 5396133
Oldest snapshot 5394502
Next transaction 5400951
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 8000
Next header page 0
Database dialect 1
Creation date May 15, 2004 19:25:20
Attributes force write, database
shutdown
Variable header data:
Sweep interval: 0
*END*
<Do you have an anti-virus running, that might be scanning the file? It
<might be the scheduled scan, not the real-time scan.
There are an antivirus running, but the gdb file is excluded.
<Do you have a disk defragmenter that might be running at the
<time(might be scheduled or running automatically at different times)?
No
<And, is it possible that the WAN users using FR might cause some
<problems(maybe the FR connection is not strong enough, sometimes)?
I do not understand so that a connection WAN can have poblems
Santiago Cordoba
[Non-text portions of this message have been removed]
<Do you have Forced Writes ON or OFF?
<What is the header statistics of the database? The database header
<"might" give some indication as to what is happening.
<You can use the GSTAT command-line to retrieve both information.
Here It is:
Database header page information:
Flags 0
Checksum 12345
Generation 5401040
Page size 8192
ODS version 10.1
Oldest transaction 5396132
Oldest active 5396133
Oldest snapshot 5394502
Next transaction 5400951
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 8000
Next header page 0
Database dialect 1
Creation date May 15, 2004 19:25:20
Attributes force write, database
shutdown
Variable header data:
Sweep interval: 0
*END*
<Do you have an anti-virus running, that might be scanning the file? It
<might be the scheduled scan, not the real-time scan.
There are an antivirus running, but the gdb file is excluded.
<Do you have a disk defragmenter that might be running at the
<time(might be scheduled or running automatically at different times)?
No
<And, is it possible that the WAN users using FR might cause some
<problems(maybe the FR connection is not strong enough, sometimes)?
I do not understand so that a connection WAN can have poblems
Santiago Cordoba
[Non-text portions of this message have been removed]