Subject | Gbak restore problem , failing reporting nulls where non exist |
---|---|
Author | Peter Chaisty |
Post date | 2006-11-08T19:01:52Z |
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 "*** null ***"
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
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 "*** null ***"
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