Ok !

I tried to do your tricks..

I found the problematic table.. but, when I open it, the server retrieve
nothing..

The message erro are:

Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements.
database file appears corrupt ().
bad checksum.
checksum error on database page 2106.

Now, what I need to do to resolve then ?

The data in this table are not important. I tried to drop the table, i tried
to delete all records by "delete from" but in both of them the error message
ocurrs.

What I need do ? Use gfix ? Have some links to explain me ?

Thanks !
Valeu pela dica Cantu !

Tiago Gouvêa

----- Original Message -----
From: "Carlos H. Cantu" <listas@...>
To: "Tiago Gouvêa de Oliveira" <firebird-support@yahoogroups.com>
Sent: Tuesday, June 29, 2004 8:34 AM
Subject: Re: [firebird-support] Backup Error


> It seems that you have bad data in char/varchar fields somewhere in
> your records.
>
> Try to do a select fetching all rows from the problematic table. If
> the error happens during the select, check what was the lastest
> recorded retrieved. Probably the record with error is the next one.
> Or try blocking the fetch (using first/skip) until you find what is
> the problematic record(s).
>
> Carlos
> http://www.warmboot.com.br
> FireBase - http://www.FireBase.com.br
>
> TGdO> Hi all !
>
> TGdO> First, excuse my poor english.
>
> TGdO> I tried to do a Backup in one FireBird DB and they return
"arithmetic
> TGdO> exception, numeric overflow, or string truncation" during the
backup. Then
> TGdO> it not end, and I can't make the backup....
>
> TGdO> By the first time, the error message are displayed in one place, by
the
> TGdO> second in another place of backup..
>
> TGdO> What can I do to locate where is the bug, and to make the full
backup
> TGdO> finally !??
>
> TGdO> Thanks !
>
> TGdO> Tiago Gouvêa
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>