Ok ! All fine !

But I can't resolve by the "correct" way..

When I tried to use GFIX -mend they returns "internal gds software
consistency check (page in use during flush (210))"....

What I did ? I recreate the GDB using the metadata, and using IBPump,
inserted the data of all tables less the corrupt table into the new file..
it's run fine.

But I still worry, because I canot use the GFIX... I readed the IBPhoenix
article, maded by Helen and in the -mend I stop..

Ok !

Tiago Gouvêa

----- Original Message -----
From: "Tiago Gouvêa de Oliveira" <tiago@...>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, June 29, 2004 12:14 PM
Subject: Re: [firebird-support] Backup Error


> 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
> >
> >
> >
> >
> >
> >
> >
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>