Subject | Re: HUGE PROBLEM - Problem with multiple access |
---|---|
Author | rudidias |
Post date | 2004-07-05T20:58:10Z |
--- In firebird-support@yahoogroups.com, Daniel Rail <daniel@a...> wrote:
This is what gstat /usr/local/firebird/database/ipuc.gdb
of my database has returned.
Isn't that option
Database "/usr/local/firebird/database/ipuc.gdb"
Database header page information:
Flags 0
Checksum 12345
Generation 2774557
Page size 1024
ODS version 10.0
Oldest transaction 2774342
Oldest active 2774343
Oldest snapshot 2774343
Next transaction 2774439
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 1
Creation date Nov 12, 2002 9:26:30
Variable header data:
Sweep interval: 20000
*END*
Database file sequence:
File /usr/local/firebird/database/ipuc.gdb is the only file
Database log page information:
Creation date
Log flags: 2
No write ahead log
Next log page: 0
Variable log data:
Control Point 1:
File name:
Partition offset: 0 Seqno: 0 Offset: 0
Control Point 2:
File name:
Partition offset: 0 Seqno: 0 Offset: 0
Current File:
File name:
Partition offset: 0 Seqno: 0 Offset: 0
*END*
Analyzing database pages ...
> I mean the status of the database. If the status of the database isI did not understand what you say about shutdown.
> shutdown, then a big chance that it is your problem. Use FB's GSTAT
> command-line utility to see the database header statistics, and it
> should indicate there if your database is shutdown or not.
This is what gstat /usr/local/firebird/database/ipuc.gdb
of my database has returned.
Isn't that option
Database "/usr/local/firebird/database/ipuc.gdb"
Database header page information:
Flags 0
Checksum 12345
Generation 2774557
Page size 1024
ODS version 10.0
Oldest transaction 2774342
Oldest active 2774343
Oldest snapshot 2774343
Next transaction 2774439
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 1
Creation date Nov 12, 2002 9:26:30
Variable header data:
Sweep interval: 20000
*END*
Database file sequence:
File /usr/local/firebird/database/ipuc.gdb is the only file
Database log page information:
Creation date
Log flags: 2
No write ahead log
Next log page: 0
Variable log data:
Control Point 1:
File name:
Partition offset: 0 Seqno: 0 Offset: 0
Control Point 2:
File name:
Partition offset: 0 Seqno: 0 Offset: 0
Current File:
File name:
Partition offset: 0 Seqno: 0 Offset: 0
*END*
Analyzing database pages ...