Hi Alexey !

Alexey Kovyazin wrote:

>Hello, Alexandre!
>
>
>
>>People,
>>
>>I got my first FB DB corrupted :-)
>>
>>
>
>
>Congratulations :)
>
>

Thanks, I didn't take much care of this DB, I didn't mind if I lost some
data when I killed the FB service with forced writes off, I did it a
dozen times, I wonder I didn't get it corrupted earlier. :-)

>
>It looks like some piece in the ned of database is lost, including one
>of the pointer pages.
>I wonder why gfix did not produce any message. Did it complete the
>validation process or just hang up?
>
>

Completed. I used
gfix localhost:smc_tp -user sysdba -password masterkey -validate

It kept running for some minutes and ended graciously without any
output. I had never needed to use gfix to fix a corrupted db, SO I
didn't know if it will be verbose telling me what he is doing or just
point errors/corrections. It just terminated without any output. I
thought it had fixed the DB, but when I tried to select I got the same
error, tehn tried to gbak withou success as I wrote on my original message.

>If you like to have more information, please take a look on firebird.log
>entries
>and run IBFirstAID Diagnostician to check low-level structures.
>
>

I have deleted the DB my notebook is getting low on disk space, and I
had to restore the backup, so the file was deleted. I did like to play
with that corrupted DB to see how many data I could get back, just
curious to see if that was a production DB without back-up, how much dat
will be lost.

>Sincerely,
>Alexey Kovyazin
>www.ibsurgeon.com
>
>

thank you !



--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.8.1 - Release Date: 23/03/2005