Subject | Re: Database compress/purge |
---|---|
Author | skotaylor |
Post date | 2003-07-24T09:21:51Z |
--- In firebird-support@yahoogroups.com, Nando Dessena <nandod@t...>
wrote:
heLen was getting at too. That is developer stupid, maybe it should
be fixed if it hasn't been in 1.5.
I just got lucky, the tables don't restore in any certain order, so it
just looked like all but the one got restored.
gbak: restoring index RDB$PRIMARY7
gbak: restoring data for table STMENU
gbak: 76 records restored
gbak: restoring index RDB$PRIMARY3
gbak: restoring data for table CATEGORY
gbak: 9 records restored
gbak: restoring index RDB$PRIMARY1
gbak: restoring data for table QUOTES
gbak: ERROR: validation error for column QT_CAT, value "*** null ***"
gbak: ERROR: warning -- record could not be restored
gbak: Exiting before completion due to errors
it was the quotes table that I added a null field to and made it not
null. I figured it was the first table I created in the DB so if it
didn't go alphabetically, it might go chronologically, seems like
random to me.
Cheers.
wrote:
> First time gbak encounters such an error it will stop operation andOh, looking back on the output of the restore again, now I see what
> the rest of the backup file is unrestored.
heLen was getting at too. That is developer stupid, maybe it should
be fixed if it hasn't been in 1.5.
I just got lucky, the tables don't restore in any certain order, so it
just looked like all but the one got restored.
gbak: restoring index RDB$PRIMARY7
gbak: restoring data for table STMENU
gbak: 76 records restored
gbak: restoring index RDB$PRIMARY3
gbak: restoring data for table CATEGORY
gbak: 9 records restored
gbak: restoring index RDB$PRIMARY1
gbak: restoring data for table QUOTES
gbak: ERROR: validation error for column QT_CAT, value "*** null ***"
gbak: ERROR: warning -- record could not be restored
gbak: Exiting before completion due to errors
it was the quotes table that I added a null field to and made it not
null. I figured it was the first table I created in the DB so if it
didn't go alphabetically, it might go chronologically, seems like
random to me.
Cheers.