Subject Re: [firebird-support] Error code -901 'conv_out_blob_materialized.isc_open_blob2: BLOB not found'
Author Ann W. Harrison
On 1/14/2011 9:56 AM, Aldo Caruso wrote:
> After executing a stored procedure which selects records from a table, I
> received this error:
>
> Error code -901: 'conv_out_blob_materialized.isc_open_blob2: BLOB not found'
>

If you're running in READ COMMITTED READ ONLY mode, it means that
the procedure read a record with blob data, but by the time it went
back to get the blob, some other transaction had deleted the record
and committed and a third transaction garbage collected the record
and its blobs.

If you're running in another mode, you may have found a Firebird bug.


Good luck,

Ann