Subject | Backup of database fails - Invalid BLOB ID |
---|---|
Author | Bhavbhuti Nathwani |
Post date | 2009-04-17T06:32:57Z |
Hi all
I am backing up a 2.0 database for restore so as to update the system tables to 2.1 (I haven't updated to the cutting edge version but use 2.1.0.17798_0)
I use FlameRobin 0.9.2.1845's backup facility and the below is the last part of the log. This is a client's database that has this problem. My dev. database did not have this problem and converted well.
I dropped the table BEA3 (as the error came just when writing to it) just to see if that is the one having the actual problem, the next backup run failed at table TEA3 (BEA3's parent and heavily used table by the client, see log still below)
Please advise.
LOG EXCERPT 1
...
...
gbak: writing data for table BEA3
Database backup canceled 11:51:38 due to IBPP exception:
*** IBPP::SQLException ***
Context: ServiceImpl::Wait
Message: isc_service_query failed
SQL Message : -901
Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements
Engine Code : 335544329
Engine Message :
invalid BLOB ID
gds_$receive failed
LOG EXCERPT 2
...
...
gbak: writing data for table TEA3
Database backup canceled 11:56:41 due to IBPP exception:
*** IBPP::SQLException ***
Context: ServiceImpl::Wait
Message: isc_service_query failed
SQL Message : -901
Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements
Engine Code : 335544329
Engine Message :
invalid BLOB ID
gds_$receive failed
I am backing up a 2.0 database for restore so as to update the system tables to 2.1 (I haven't updated to the cutting edge version but use 2.1.0.17798_0)
I use FlameRobin 0.9.2.1845's backup facility and the below is the last part of the log. This is a client's database that has this problem. My dev. database did not have this problem and converted well.
I dropped the table BEA3 (as the error came just when writing to it) just to see if that is the one having the actual problem, the next backup run failed at table TEA3 (BEA3's parent and heavily used table by the client, see log still below)
Please advise.
LOG EXCERPT 1
...
...
gbak: writing data for table BEA3
Database backup canceled 11:51:38 due to IBPP exception:
*** IBPP::SQLException ***
Context: ServiceImpl::Wait
Message: isc_service_query failed
SQL Message : -901
Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements
Engine Code : 335544329
Engine Message :
invalid BLOB ID
gds_$receive failed
LOG EXCERPT 2
...
...
gbak: writing data for table TEA3
Database backup canceled 11:56:41 due to IBPP exception:
*** IBPP::SQLException ***
Context: ServiceImpl::Wait
Message: isc_service_query failed
SQL Message : -901
Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements
Engine Code : 335544329
Engine Message :
invalid BLOB ID
gds_$receive failed