> >gbak: 140000 records written
> >gbak: error accessing BLOB column VAL -- continuing
> >gbak: ERROR: BLOB not found
> >gbak: 160000 records written
> >...
> >
> >I think that this is a bug. What do you think ?
>
> I think you have more investigation to do and I can only offer some

thoughts:

>
> The first thing to do for your test (and in production!!) is to break the
> operation into batches and commit after each 20,000 rows. There's an

upper

> limit on how many rows you should insert in a single transaction (in all
> events!). You were lucky to get 159,999 good writes. A million is a
> far-far stretch.

All IMHO of course, but if the server cannot handle this, it should
raise an exception, not silently continue and mess things up afterwards.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com