Skip to content
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

Muti-files restore fails under Vista 64 or Windows 2008 64bits (not under 32 bits) [CORE2394] #2814

Open
firebird-automations opened this issue Mar 27, 2009 · 3 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: FRANCIS PARLANT (fparlant)

I try to restore a 5 gb gbk file with FB 2.1 (WI-V6.3.1.17910 Firebird 2.1) under Vista or Windows 2008 server both 64 bits. I want to restore to as many 2 gb files as needed. So I launch the following command line:
gbak -r -p 8192 -v -user SYSDBA -pas masterkey "H:\OBS 2008.gbk" "H:\OBS01.DB" 250000 "H:\OBS02.DB" 250000 "H:\OBS03.DB" 250000 "H:\OBS04.DB"
But the restored files are not corrects, I get : 3 files of 2gb and the last one is only 24 kb....
If I launch the same command but under Windows 2003 32 bits, this time I got as expected 3 2gb files and the fourth file is 1965 kb and not 24 kb as under 64 bits....

@firebird-automations
Copy link
Collaborator Author

Commented by: Sean Leyne (seanleyne)

Have you confirmed that the size of the last file using the Properties viewer, or are you using the values that Windows Explorer is showing?

(This really should be discussed in the support list until the issue is confirmed)

@firebird-automations
Copy link
Collaborator Author

Commented by: FRANCIS PARLANT (fparlant)

Not sure what you mean, but the size are the same within Properties viewer or Windows Explorer (expressed as bytes I mean)... The problem is that the last file looks like it is truncated under 64 bits OSes....

@firebird-automations
Copy link
Collaborator Author

Commented by: FRANCIS PARLANT (fparlant)

I have been kindly asked to precise the problem I faced :-)

- with FB 32 bits and/or FB 64 bits under a 64 bits OS (Vista or Windows 2008 server) I face the following problem : when restoring a FB 2.1 backup to a multi-files restore, the last file show a wrong size : its size is 24 kb while it should be around 1.8 GB... This problem doesn't happen under a 32 bits OS...

Having made further tests, I have realized that this problem doesn't happen any longer if instead of 0 fort the last file, I ask for the same size as for the first files, I mean 250000.

Thus, contrary to what happens under 32 bits OS, under 64 bits we know have to set a non zero file size for the last file of a multi-files restore....

Doesn't work: gbak -r -p 8192 -v -user SYSDBA -pas masterkey "H:\OBS 2008.gbk" "H:\OBS01.DB" 250000 "H:\OBS02.DB" 250000 "H:\OBS03.DB" 250000 "H:\OBS04.DB"

Works correctly : gbak -r -p 8192 -v -user SYSDBA -pas masterkey "H:\OBS 2008.gbk" "H:\OBS01.DB" 250000 "H:\OBS02.DB" 250000 "H:\OBS03.DB" 250000 "H:\OBS04.DB" 250000

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant