Subject | Re: [ib-support] db corrupted |
---|---|
Author | Jan Agermose |
Post date | 2003-02-13T08:19:25Z |
The day of the post I had some problems receiving post from this list. Hope
I did not miss any replies?
But, the corruption came at a point where no backup was in progress (as the
backup script was not running :-( ) As it turns out, I lost one table
completely, and some 6-7 other tables are there if you do a "show tables"
but if You do a select on the tables You get the same error as bellow.
gfix and gbak will not run.
Jan
I did not miss any replies?
But, the corruption came at a point where no backup was in progress (as the
backup script was not running :-( ) As it turns out, I lost one table
completely, and some 6-7 other tables are there if you do a "show tables"
but if You do a select on the tables You get the same error as bellow.
gfix and gbak will not run.
Jan
----- Original Message -----
From: "Bill Katelis" <bill@...>
To: <ib-support@yahoogroups.com>
Sent: Thursday, February 13, 2003 6:18 AM
Subject: Re: [ib-support] db corrupted
> Jan - that error usually comes when someone has dropped a table after a
> gbak has commenced.
>
> Simply try the gbak again.
>
> thanks
> bill
>
> Jan Agermose wrote:
>
> >I faced with bit of a problem. My database is corruptet. I can connect to
it
> >and read/use it but a table is missing. I cannot gfix it og gbak it :-(
> >
> >If I try: "gfix -mend" I get
> >
> >invalid request BLR at offset 30
> >-table ARMATURINFO is not defined
> >
> >same with "gfix -validate" and trying to backup the database gives:
> >
> >gbak: ERROR: invalid request BLR at offset 38
> >gbak: ERROR: table ARMATURINFO is not defined
> >gbak: ERROR: gds_$compile_request failed
> >gbak: Exiting before completion due to errors
> >
> >This is of couse also the table that is missing. This is on Firebird 1
under
> >RH7
> >
> >Jan
> >
> >
> >
> >[Non-text portions of this message have been removed]
> >
> >
> >
> >To unsubscribe from this group, send an email to:
> >ib-support-unsubscribe@egroups.com
> >
> >
> >
> >Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>