Subject RE: [firebird-support] Re: Unpredictable Behaviour when Database File Size hit the Maximum 2G limit. Help!!
Author Alan McDonald
>
> Can I get any feedback from this forum ? I would like to know whether
> the error message below means database corruption ? as I would like
> to prepare corrective action for future.
>
> rgds
>

I've only struck something like this once - quite a while ago, but since
noone else is offering I suggest you make a new shell of the database, then
pump the data to it after making another file (5 in total)
I assume that connecting to the databse is still ok and it's just gbak which
has a problem..?
I assume also that you have made sure your version of gbak matches the
server version? and that you have tried RC7 for the exercise?

Alan

>
> --- In firebird-support@yahoogroups.com, "Chooi-Ting" <goonct@w...>
> wrote:
> > hi,
> >
> > I have 4 database files and the last file has hit 2G limit. The
> > database is running on firebird 1.0 at solaris 2.8.
> >
> > The database application cannot write data to the database because
> of
> > the I/O problem (file size exceed 2G limit). The errors was shown as
> >
> > When we try to gbak, ibserver is terminated adnormally after 1 hour.
> > The errors were shown below:
> > gbak: ERROR: Error reading data from the connection.
> > gbak: ERROR: gds_$receive failed
> > gbak: Exiting before completion due to errors
> > gbak: ERROR: Unable to complete network request to host "localhost".
> > gbak: ERROR: Error reading data from the connection.
> > gbak: ERROR: Connection reset by peer
> >
> > Then, we try gfix, different error were prompted:
> > Unable to complete network request to host "localhost".
> > -Error reading data from the connection.
> >
> > When I checked the interbase.log, seems like ibserver was
> restarted.
> > Below are the errors:
> >
> *********************************************************************
> > geodb2 (Server) Mon Dec 29 02:23:49 2003
> > Database: /db2/firebird/gdbfile/hts_corrupt.gdb
> > Relation has 4441 orphan backversions (0 in use) in table
> > ANALOGHOURLY (134)
> >
> >
> > geodb2 (Server) Mon Dec 29 02:35:57 2003
> > Database: /db2/firebird/gdbfile/hts_corrupt.gdb
> > Relation has 1318456 orphan backversions (12963144 in use)
> in
> > table HISTCURR (138)
> >
> >
> > geodb2 (Server) Mon Dec 29 02:42:29 2003
> > bugcheck during scan of table 150 (HISTORY)
> >
> > geodb2 (Server) Mon Dec 29 02:42:29 2003
> > SCH_validate -- not entered
> >
> > geodb2 (Client) Mon Dec 29 02:42:32 2003
> > /usr/interbase/bin/ibguard: bin/ibserver terminated
> > abnormally (-1)
> >
> >
> > geodb2 (Client) Mon Dec 29 02:42:32 2003
> > /usr/interbase/bin/ibguard: guardian starting bin/ibserver
> >
> >
> > geodb2 (Server) Mon Dec 29 02:42:32 2003
> > Open file limit increased from 256 to 1024
> >
> > *******************************************************************
> >
> > What should I do to resume the database ? Please advise.
> >
> > rgds, chooi ting
>
>
>
>
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to:
> http://docs.yahoo.com/info/terms/
>
>
>
>