Subject Re: [firebird-support] Problems with restore
Author Martijn Tonies
Hello Heiko,

> We've got a problem to restore databases on one of our customers server.
> The error is something like
>
> gbak: restoring index RDB$FOREIGN820
> gbak: restoring index RDB$FOREIGN740
> gbak: restoring index RDB$FOREIGN747
> gbak: restoring index IXAUFTRVERLADUNG
> gbak: restoring data for table TBLAUFTRAG
> gbak: 10000 records restored
> gbak: adjusting an invalid decompression length from 38 to 5
> gbak: ERROR: validation error for column WAEHRUNGIDWNN, value "***
> null ***"
> gbak: ERROR: warning -- record could not be restored
> gbak: Exiting before completion due to errors

Sounds like you have a NULL in a "not null" column. Can you
confirm this on your database?

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com


> The error varies a bit (different positions) depending on the backup
> file.
> But using the same backup file always produces the same error at the
> same position.
>
> If the restore runs on a different machine everything seems to be OK.
>
> The backups were also created on different machines.
>
> The machine was checked several times by hardware specialists (some
> Siemens guys, because it's a Siemens computer).
> No problems were detected. And other applications running on that
> server are just fine.
> The harddisks were replaced without any effect concerning this problem.
>
> The problem occurs using firebird 1.0.2 and 1.5.2
>
> In the meantime the customer temporarily uses a different server. But
> we (they) are
> of course highly interested in what could be the reason for this.