gbak: ERROR:BLOB not found
--------------------------
Key: CORE-3492
URL: http://tracker.firebirdsql.org/browse/CORE-3492
Project: Firebird Core
Issue Type: Bug
Components: Engine, GBAK
Affects Versions: 2.1.3
Environment: PC, Debian Squeeze
Reporter: FrantiĊĦek Jahoda
Priority: Critical
Regular backups with "gbak -b" failed at these error
gbak: ERROR:BLOB not found
gbak: ERROR:gds_$receive failed
gbak:Exiting before completion due to errors
content of /var/log/firebird.log (all times are in UTC):
our_database (Server) Tue May 17 03:34:51 2011
Database: /srv/firebird/our_database.fdb
deadlock
internal gds software consistency check (error during savepoint backout
(290), file: exe.cpp line: 4043)
our_database (Server) Tue May 17 03:36:39 2011
Database: /srv/firebird/our_database.fdb
deadlock
our_database (Server) Tue May 17 03:36:44 2011
Database: /srv/firebird/our_database.fdb
deadlock
our_database (Server) Wed May 18 06:15:25 2011
Fatal lock manager error: invalid lock id (21688), errno: 22
Last successful backup started at 2011-05-17T22:00Z and ended at
2011-05-18T04:53Z
after that error we have been unable to backup database, gfix binary copy of it
trough --mend or --validate --full
we were able to backup database with gbak -b --ignore but unable to restore
(gbak restored the file but ended on bad page type error and quit)
but the gfix was able to find a lot of following types of errors:
Database: /mnt/tmp/our_database.fdb
Index 1 is corrupt on page 8136665 level 1. File:
../src/jrd/validation.cpp, line: 1649
in table DEVICE_PIM_DATA (133)
our_database (Server) Fri May 20 16:24:02 2011
Database: /mnt/tmp/our_database.fdb
Page 22655159 is an orphan
We were able to finally backup the database after manually scanning all blobs
and removing records with missing blobs (cca 8 records).
Our database have 89GB file size (cca 70% of content are blobs). After gbak
failed we upgraded to 2.1.4 and solved the problem with this version. We
provide free service for users all around the world so we do not want any
downtime. (but the database itegrity is still a priority). Should we do
anything about reported errors?
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
vRanger cuts backup time in half-while increasing security.
With the market-leading solution for virtual backup and recovery,
you get blazing-fast, flexible, and affordable data protection.
Download your free trial now.
http://p.sf.net/sfu/quest-d2dcopy1
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
