Subject | Re: [firebird-support] Re: Restore problem |
---|---|
Author | Michael Ludwig |
Post date | 2012-04-16T19:39:02Z |
Dmitry Kuzmenko schrieb am 16.04.2012 um 10:59 (+0400):
http://www.firebirdsql.org/manual/gbak-cmdline.html
Maybe repeated here:
http://www.firebirdsql.org/manual/gbak-caveats.html
If I understand correctly, corruption occurs as a result of an
unwarranted application of the -fix_* switches. I can only guess how
exactly the corruption occurs. Does it by any chance try to apply an
encoding scheme to some data suspected not to have received the proper
encoding due to a bug in the FB or GBAK version it originated in?
Michael
> Friday, April 13, 2012, 11:55:38 PM, you wrote:This note might be important enough to make it into the GBAK manual.
>
> AJ>> gbak -se service_mgr
> AJ>> -fix_fss_metadata ISO8859_1
> AJ>> -fix_fss_data ISO8859_1
> AJ>> -rep -v -z
> AJ>> -user SYSDBA -password masterkey
> AJ>> E:\...\...\sl1b3_20120412.fbk15 SL1
> AJ>> ==================================
> AJ>> Previous restores have never failed.
>
> DK>> mmm, you did this command SEVERAL TIMES???
>
> AJ> Yes, I've do this quite often.
>
> if you run same command line for the same DB,
> i.e. backup/restore, backup/restore, etc,
> than you killed metadata in it.
>
> Options -fix must be specified only ONE TIME,
> when you restore your database at 2.5 from
> previous versions backups, and moreover,
> only if you have ERROR during restore without
> -fix options.
http://www.firebirdsql.org/manual/gbak-cmdline.html
Maybe repeated here:
http://www.firebirdsql.org/manual/gbak-caveats.html
If I understand correctly, corruption occurs as a result of an
unwarranted application of the -fix_* switches. I can only guess how
exactly the corruption occurs. Does it by any chance try to apply an
encoding scheme to some data suspected not to have received the proper
encoding due to a bug in the FB or GBAK version it originated in?
Michael
> AJ> Why wouldn't I use the same restore command each time I fetch a new backup?
>
> because, as I said, -fix options are special options to fix incorrect
> encoding of data and metadata, that could happen in previous FB
> versions.