Alan,

> In my case, the error received is happening on a read only transaction

Read only read committed one?

> blobs are being returned via a view which substrings the blob to the first
> 250 characters. It never posts any data and there (I think) is never a round
> trip to retrieve the blob contents using the ID since the blob is sent as a
> varchar in the first instance anyway.

Prior to v2.1, SUBSTRING(BLOB) returned a varchar, but now it returns a
temporary blob. So I believe the blob contents is actually fetched by
the client via the blob ID. Could it be possible that it's done after a
transaction commit, for example?


Dmitry