|Subject||Re: [firebird-support] BLOB not found|
> >gbak: 140000 records writtenthoughts:
> >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
> 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
> limit on how many rows you should insert in a single transaction (in allAll IMHO of course, but if the server cannot handle this, it should
> events!). You were lucky to get 159,999 good writes. A million is a
> far-far stretch.
raise an exception, not silently continue and mess things up afterwards.
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL