Hi Santini,

Someone reported a bug (related to IB6) giving
"BLOB not found" error in this scenario:
inserting or updating records with blobs inside
triggers and storerd procedure (mainly copiing
them from the same table), i.e. for example in
an after update trigger insert another record
in the same table using the "new.blobname" as
value. To avoid this get UDF library which has
functions to convert from blob to string (e.g.
f_blobAsPchar), and from string to blob (e.g. f_strBlob).
Then you can insert blob fields from procedures and
triggers. For example,
insert into tableWithBlob(blobField)
values(f_strBlob(f_blobAsPchar(new.blobField)));


Ciao!
Marco Kregar
www.firebirdsql.it

--- In firebird-support@yahoogroups.com, "Santini"
<santini.lista@t...> wrote:

> Hi,
>
> What means the following error ?
>
> gbak: error accessing BLOB column VAL -- continuing
> gbak: ERROR: BLOB not found
> gbak: 200000 records written
> gbak: 220000 records written
> gbak: ERROR: segment buffer length shorter than expected
> gbak: ERROR: gds_$get_segment failed
> gbak: Exiting before completion due to errors
>
> I ran gfix -v -full database.gdb but nothing is returned, this is,

the

> database isnt corrupted.
>
> Any idea ?
>
> Thanks,
>
> Rafael Santini