Subject | Re: Gbak restore problem , failing reporting nulls where non exist |
---|---|
Author | Peter Chaisty |
Post date | 2006-11-08T19:40:44Z |
Hi all
False alarm, workbench was displaying 0's where there were nulls
Gbak was correct all the time
Peter
--- In firebird-support@yahoogroups.com, "Peter Chaisty" <peter@...>
wrote:
False alarm, workbench was displaying 0's where there were nulls
Gbak was correct all the time
Peter
--- In firebird-support@yahoogroups.com, "Peter Chaisty" <peter@...>
wrote:
>null ***"
> Hi I wonder if anyone can help / make any suggestions.
>
> I have a backup of a live db which I make daily backups of.
> This is the first time I attempted to restore this particular db
> though I do have others of a similar structure I have succesfully
> restored.
>
> Restoring using gbak is failing with the error
>
> gbak: restoring data for table DOWNLOADED_PINS
> gbak: 961 records restored
> gbak: restoring index PK_COST_GROUPS
> gbak: restoring index PK_TERMINAL_REDIRECTS
> gbak: restoring index U_TERMINAL_REDIRECTS
> gbak: restoring data for table TERMINAL_REDIRECTS
> gbak: ERROR: validation error for column TERMINAL_ID, value "***
> gbak: ERROR: warning -- record could not be restored
> gbak: Exiting before completion due to errors
>
>
> running gfix -v -full reports no errors
>
> If I restore with the -n option then the process goes through.
> I only have a few entries in the table Terminal_redirects and
> columd_id is a PK and has no null entries.
>
> I am using Firebird 1.5.2 on windows
>
> running a restore on linux also gives the same error.
>
> I would welcome advice / suggestions.
>
> Rgds
>
> Peter
>