Subject | Unpredictable Behaviour when Database File Size hit the Maximum 2G limit. Help!! |
---|---|
Author | Chooi-Ting |
Post date | 2003-12-29T01:51:58Z |
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
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