-
-
Notifications
You must be signed in to change notification settings - Fork 205
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Firebird 5 : gbak with -FIX_FSS_DATA NONE and -PAR (Firebird-5.0.0.1306-0-linux-x64.tar.gz) #8095
Comments
Could you try with latest snapshot build ? |
Just a side note: |
Sorry for the confusion. gbak:restore options are: |
I'll try this weekend.. |
I re-open the issue as it is not clear what really happens. Waiting for more details. |
Any news ? |
I'm unable to restore a database if it contains -FIX_FSS_DATA Errors whilst using a backup with -PAR
This DB contains an implicit error in one table.
Following fails:
/opt/firebird/bin/gbak -b -se %IP%:service_mgr -user %USER% -pass %PASS% -T %DB% -PAR 16 -V /tmp/dailybackup.fbk
/opt/firebird/bin/gbak -rep -se %IP%:service_mgr -user %USER% -pass %PASS% -V -P 8192 -FIX_FSS_DATA NONE -i /tmp/dailybackup.fbk dailyrestore
--- The backup works however the restore fails and raises an error to fix the fss_data
Following works:
Just removing the -PAR 16 in the backup the database is successfully backed-up and restored (with and without indexes -i).
backup
gbak: 345.709 0.000 0 0 writing referential constraints
gbak: 345.709 0.000 0 0 writing check constraints
gbak: 345.713 0.003 2 0 writing SQL roles
gbak: 345.718 0.005 0 0 writing names mapping
gbak: 345.719 0.000 0 0 writing publications
gbak: 346.749 1.030 0 0 closing file, committing, and finishing. 4179507200 bytes written
gbak: 346.750 0.000 8011603 537935 total statistics
Restore just crashes
gbak: 471.878 0.200 0 0 400000 records restored
gbak: 472.017 0.139 0 0 410000 records restored
gbak: 472.854 0.837 0 0 420000 records restored
gbak: 473.036 0.181 0 0 430000 records restored
gbak: 473.509 0.472 0 203 440000 records restored
gbak: 473.811 0.302 0 136 445000 records restored
From what I can gather using -PAR changes the backup file in a way that -FIX_FSS_DATA NONE will not work when restoring it.
The text was updated successfully, but these errors were encountered: