have you try it using interbase 7.1
I did also meet the error msg"Arithmetic Overflow or String
Truncation error.." before. But when i restored the backup file in
interbase. All warning and error msgs disappeared.

So I have the same questions around the gbak's philosophy.

================================================================
On Mon, 27 Sep 2004 12:12:02 -0000
"fowlertrainer" <fowlertrainer@...> wrote:

fowlertrainer> Hi !
fowlertrainer>
fowlertrainer> I have a second case, when my FireBird database is corrupted.
fowlertrainer> But I don't understand the gbak's philosophy.
fowlertrainer>
fowlertrainer> In first case the backup is working fine, but the restore is halted by
fowlertrainer> an error message: gds ... length error (252 needed, 249 coming).
fowlertrainer>
fowlertrainer> In next problem (happened in yesterday) the gbak is working good in
fowlertrainer> backup, but restore is say that "Arithmetic Overflow or String
fowlertrainer> Truncation error"... Ahhh...
fowlertrainer> When I try to empty the table (what restore show, when it is halted),
fowlertrainer> the restore is say same error msg in another table.
fowlertrainer> And when I empty all table it is halted again - and say that error in
fowlertrainer> a generator restoration.
fowlertrainer> So (I think) that FDB file is corrupted.
fowlertrainer>
fowlertrainer> But: in every cases I'm very lucky man, because from Delphi copier
fowlertrainer> program I can recreate the database.
fowlertrainer> (Create tables from Meta, Copy Datas, and ISQL exec every other
fowlertrainer> metadatas below Table creation section...).
fowlertrainer>
fowlertrainer> But !!!
fowlertrainer>
fowlertrainer> These cases, and some other cases, when the restore is halted by a
fowlertrainer> constraint that added later than datas (and datas are invalid WITH
fowlertrainer> this constraint), makes me very unhappy.
fowlertrainer>
fowlertrainer> I think, that backup is not usable for SAFE data saving.
fowlertrainer> These cases are shows to me, that the silent backups without
fowlertrainer> errormessages are not same things like "THE DATABASE IS SAVED, AND
fowlertrainer> SAFELY RESTORABLE" methods.
fowlertrainer>
fowlertrainer> MySQL, and PGSQL is save the datas with DUMP, with inserts (but I
fowlertrainer> don't know, how the blobs are saved...).
fowlertrainer>
fowlertrainer> FB is follow the "binary backup" way.
fowlertrainer> But it is not too good, because the gbak is CAN CREATE the backup
fowlertrainer> without error reports, and CAN CREATE a backup that is un-restorable.
fowlertrainer>
fowlertrainer> How to I put faith in backup files, when I not sure that backups are
fowlertrainer> restorable later ???
fowlertrainer>
fowlertrainer> I this time the file copied database is better then only gbak saved
fowlertrainer> database...
fowlertrainer>
fowlertrainer> I think, that the method is wrong.
fowlertrainer>
fowlertrainer> If the gbak is working, that it MUST (!!!) show the errors that it
fowlertrainer> found in database: the datas that not restorable (because them later
fowlertrainer> constrained, and value is not corrected), the length errors, the db
fowlertrainer> validity errors, and others.
fowlertrainer> And it MUST say "Finished, no error", when it is SURE that the datas
fowlertrainer> are restorable.
fowlertrainer>
fowlertrainer> And restore is CAN put a null fields to a record, if the gbak is save
fowlertrainer> NULL for these field - no matter, how the fields are constrained.
fowlertrainer> (Just show the comments in a file - that, and that record is
fowlertrainer> containing null, and the null are not allowed.)
fowlertrainer>
fowlertrainer> THAT IS A GOOD SOLUTION.
fowlertrainer>
fowlertrainer> In this time I say: I can put backup to my CRON jobs, and I'm sure,
fowlertrainer> that what the gbak is saved, I CAN RESTORE LATER !
fowlertrainer>
fowlertrainer>
fowlertrainer> Uff. I say that.
fowlertrainer>
fowlertrainer>
fowlertrainer>
fowlertrainer>
fowlertrainer>
fowlertrainer>
fowlertrainer>
fowlertrainer>
fowlertrainer> Yahoo! Groups Links
fowlertrainer>
fowlertrainer>
fowlertrainer>
fowlertrainer>