Subject Re: [firebird-support] BLOB Not Found error
Author Dimitry Sibiryakov
16.03.2018 14:47, shg_sistemas@... [firebird-support] wrote:
> Since some days ago I'm getting (it seems very occasionally and randomly) a "blob not
> found" error.
> As far as I remember the problem happens during read operations: with "locate" commands or
> inside a "while not eof" loop...

You should use "Repeatable Read" or "Snapshot" transaction isolation mode. In "Read
Committed" you can get this error if record has been deleted and garbage collected before
you start reading the BLOB.