| Subject | Re: [ib-support] error blob not found during backup |
|---|---|
| Author | Ann W. Harrison |
| Post date | 2003-01-21T17:55:15Z |
At 11:19 AM 1/19/2003 -0800, Kevin Stanton wrote:
manipulate blobs in triggers and procedures. In fact,
assigning a blob from one record to another does not cause
any error. However, under some circumstances, that blob
id is copied, so two records point to the same record on
disk. If one of those records is deleted then the other
record will point to nothing and will get the BLOB not found
error. If the blob is updated through one record and the
old version is garbage collected, you'll see the same thing.
Fixed in firebird V1.0
Regards,
Ann
www.ibphoenix.com
We have answers.
>gbak: ERROR: BLOB not foundUpgrade to Firebird.
>
>Can anyone tell me the best approach to fixing this
> and what made the error in the first place?The documentation for InterBase 6 says that you shouldn't
manipulate blobs in triggers and procedures. In fact,
assigning a blob from one record to another does not cause
any error. However, under some circumstances, that blob
id is copied, so two records point to the same record on
disk. If one of those records is deleted then the other
record will point to nothing and will get the BLOB not found
error. If the blob is updated through one record and the
old version is garbage collected, you'll see the same thing.
Fixed in firebird V1.0
Regards,
Ann
www.ibphoenix.com
We have answers.