Subject Re: Unpredictable Behaviour when Database File Size hit the Maximum 2G limit. Help!!
Author Chooi-Ting
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


--- 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