Subject Re: [ib-support] Corrupt database - help needed
Author Paul Hope
Brandon

Thanks very much for your help. Command line gfix -m -i did the trick :-)
. I can sleep tonight!

Regards
Paul


> Here are some articles to give you some insight on how to fix this
problem:
>
>
http://www.ibphoenix.com/netfradb/search.nfs?a=knowledgebase&l=;KNOWLEDGEBAS
> E.PAGES;ID='46'
>
>
http://www.ibphoenix.com/netfradb/search.nfs?a=knowledgebase&l=;KNOWLEDGEBAS
> E.PAGES;ID='92'
>
> I hope this helps, if not let me know and I will try to help you out some
> other way or point you in the right direction. There is the possibility
you
> will lose data but you should be able to get the database back to working
> order. Just make sure you have backups before you do anything these
> articles mention. If none of this helps the folks at IB Phoenix can fix
> these problems in a jiffy.
>
> Brandon Fouts
> ----- Original Message -----
> From: "paulphope" <paulhope@...>
> To: <ib-support@yahoogroups.com>
> Sent: Sunday, June 02, 2002 6:48 PM
> Subject: [ib-support] Corrupt database - help needed
>
>
> > Hi
> >
> > I have a customer whos database is corrupt and their automated 2
> > hourly backups have been failing. So we're in big trouble and any
> > help would be very much appreciated.
> >
> > IB 5.6 on NT4 sp6a
> >
> > Using Server Manager a standard backup fails. A backup with all the
> > ticks selected goes fine until this lot
> >
> > gbak: writing data for table PATIENT
> > gbak: error accessing BLOB column PRIVATECOMMENTS -- continuing
> > gbak: ERROR: database file appears corrupt ()
> > gbak: ERROR: wrong page type
> > gbak: ERROR: page 71404 is of wrong type (expected 5, found -1)
> > gbak: error accessing BLOB column PRIVATECOMMENTS -- continuing
> > gbak: ERROR: database file appears corrupt ()
> > gbak: ERROR: wrong page type
> > gbak: ERROR: page 71404 is of wrong type (expected 5, found -1)
> > gbak: error accessing BLOB column PRIVATECOMMENTS -- continuing
> > gbak: ERROR: database file appears corrupt ()
> > gbak: ERROR: wrong page type
> > gbak: ERROR: page 71404 is of wrong type (expected 5, found -1)
> > gbak: error accessing BLOB column PRIVATECOMMENTS -- continuing
> > gbak: ERROR: database file appears corrupt ()
> > gbak: ERROR: wrong page type
> > gbak: ERROR: page 71404 is of wrong type (expected 5, found -1)
> > gbak: error accessing BLOB column PRIVATECOMMENTS -- continuing
> > gbak: ERROR: database file appears corrupt ()
> > gbak: ERROR: wrong page type
> > gbak: ERROR: page 71404 is of wrong type (expected 5, found -1)
> > gbak: error accessing BLOB column PRIVATECOMMENTS -- continuing
> > gbak: ERROR: database file appears corrupt ()
> > gbak: ERROR: wrong page type
> > gbak: ERROR: page 71404 is of wrong type (expected 5, found -1)
> > gbak: error accessing BLOB column PRIVATECOMMENTS -- continuing
> > gbak: ERROR: database file appears corrupt ()
> > gbak: ERROR: wrong page type
> > gbak: ERROR: page 71404 is of wrong type (expected 5, found -1)
> > gbak: ERROR: database file appears corrupt ()
> > gbak: ERROR: wrong page type
> > gbak: ERROR: page 71404 is of wrong type (expected 5, found -1)
> > gbak: ERROR: gds_$receive failed
> > gbak: Exiting before completion due to errors
> >
> > What can I do next?
> >
> > Regards
> > Paul
> >
> >
> >
> >
> >
> > 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/
>
>
>