Subject | Re: [Firebird-Java] 335544329 invalid BLOB ID |
---|---|
Author | Roman Rokytskyy |
Post date | 2005-12-09T22:50:03Z |
Jim,
READ COMMITTED isolation and engine fetches the record including the BLOB ID
and before the record is written, parent is deleted and BLOB is garbage
collected. Can this happen?
Roman
> No, happily this isn't possible. Blobs are garbage collected when theEven if we talk about "INSERT INTO ... SELECT * FROM aTable"? So, if we have
> parent records are deleted or have versions pruned. And the symptom
> would only be visible from a read committed transaction and then only
> between the interval of fetching a record and having it deleted and
> garbage collected. A transaction containing an insert wouldn't meet any
> of these conditions, let alone all of them.
READ COMMITTED isolation and engine fetches the record including the BLOB ID
and before the record is written, parent is deleted and BLOB is garbage
collected. Can this happen?
Roman