Subject | Re: [firebird-support] Problems with restore |
---|---|
Author | Martijn Tonies |
Post date | 2006-01-26T10:03:45Z |
Hello Heiko,
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
> We've got a problem to restore databases on one of our customers server.Sounds like you have a NULL in a "not null" column. Can you
> 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
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.