Subject | About database corruption. gfix is hanging... |
---|---|
Author | Alexey |
Post date | 2001-07-18T07:59:07Z |
Hello, All!
I have a big problem during repairing corrupted database.
About configuration:
Operation System is Windows Server 2000 (no sp)
File System is FAT16
Server version is Interbase NI-V4.0A(4)
Database 467 Mb
Here is the sequence of occurred events and problems:
1. Disk with database was out of drive space.
2. All users were disconnected from the server and temporary files were
deleted. After that we have got ~400 Mb free space.
2. While trying to connect database via Server Manager the error
with message:
Summary - "Error connecting to the requested database."
Detail -
"database file appears corrupt ()
-bad checksum
-checksum error on database page 59902"
was occurred.
3. The file copies of corrupted database file was made.
4. After that i tried to recover it:
start
gfix -v -full -user sysdba -password masterkey C:\TEMP\database.gdb
and on second computer start
gfix -mend -user sysdba -password masterkey C:\TEMP\database.gdb
During 16 hours gfix was processing the file.
Interbase.log begun grow! ~60Kb/sec.
Such errors as
"Page <num> is doubly allocated" is repeated circularly with the same <num>.
5. During over 16 house gfix was working and interbase.log was growing. The
last database file modification was made by gfix ~20 minutes after launch
(this i consider from database file info).
6. I stopped gfix with Ctrl-C :-(((
After that i tried to use:
1) gfix from Interbase 5.6 - with the same result.
2) gbak -backup -v -ignore database.gdb database.gbk
Result is:
"
gbak: ERROR: I/O error for file "C:\temp\database.gdb"
gbak: ERROR: error while truing to read from file
gbak: ERROR: End of file is Reached /*It's translation from russian error message*/
"
So i failed to recover database. Help!
[Non-text portions of this message have been removed]
I have a big problem during repairing corrupted database.
About configuration:
Operation System is Windows Server 2000 (no sp)
File System is FAT16
Server version is Interbase NI-V4.0A(4)
Database 467 Mb
Here is the sequence of occurred events and problems:
1. Disk with database was out of drive space.
2. All users were disconnected from the server and temporary files were
deleted. After that we have got ~400 Mb free space.
2. While trying to connect database via Server Manager the error
with message:
Summary - "Error connecting to the requested database."
Detail -
"database file appears corrupt ()
-bad checksum
-checksum error on database page 59902"
was occurred.
3. The file copies of corrupted database file was made.
4. After that i tried to recover it:
start
gfix -v -full -user sysdba -password masterkey C:\TEMP\database.gdb
and on second computer start
gfix -mend -user sysdba -password masterkey C:\TEMP\database.gdb
During 16 hours gfix was processing the file.
Interbase.log begun grow! ~60Kb/sec.
Such errors as
"Page <num> is doubly allocated" is repeated circularly with the same <num>.
5. During over 16 house gfix was working and interbase.log was growing. The
last database file modification was made by gfix ~20 minutes after launch
(this i consider from database file info).
6. I stopped gfix with Ctrl-C :-(((
After that i tried to use:
1) gfix from Interbase 5.6 - with the same result.
2) gbak -backup -v -ignore database.gdb database.gbk
Result is:
"
gbak: ERROR: I/O error for file "C:\temp\database.gdb"
gbak: ERROR: error while truing to read from file
gbak: ERROR: End of file is Reached /*It's translation from russian error message*/
"
So i failed to recover database. Help!
[Non-text portions of this message have been removed]