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

Error when we try restore an backup using Gbak 2.5.2.26539 and FB 2.0 [CORE4050] #4379

Open
firebird-automations opened this issue Feb 14, 2013 · 3 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Honório Morais (honoriojpm)

Votes: 1

We have an app wich I send gbak and gfix with it to do backup's in any workstation. There are some customers who still are using FB 2.0. After we upgraded gbak and gfix files to version 2.5.2.26539, we still can make backup connecting on FB 2.0 servers. But when we try to restore this same backup file, to the same FB 2.0 server the following error is happening at the end of the process:

gbak: committing metadata
gbak: ERROR:Dynamic SQL Error
gbak: ERROR: SQL error code = -104
gbak: ERROR: Token unknown - line 1, column 247
gbak: ERROR: SIMILAR
gbak:Exiting before completion due to errors

This error doesn't happen with gbak 2.5.1.

@firebird-automations
Copy link
Collaborator Author

Commented by: Sean Leyne (seanleyne)

The use of mixed versions of utilities (gbak and gfix... etc) and the server is not supported -- it if works, it is a fluke.

Although, gbak runs like a client application, it is designed to backup database system metadata based on specific criteria/logic.

The utilities and engine should be treated as a single component for deployment purposes.

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

I believe Alex intention was to hide this error in 2.0 / 2.1:
"Use correct way to detect digital strings. In 2.1 with missing SIMILAR TO had to ignore errors when fixing generators." -- CORE3733

@firebird-automations
Copy link
Collaborator Author

Commented by: Beto Neto (betoneto.tbo)

I got the same problem:

gbak: committing metadata
gbak: ERROR:Dynamic SQL Error
gbak: ERROR: SQL error code = -104
gbak: ERROR: Token unknown - line 1, column 247
gbak: ERROR: SIMILAR
gbak:Exiting before completion due to errors

Backup from 2.1.5x86
Restore to 2.5.2 (build 26540) x64.

I was only able to restore the backup using service manager switch (-se).

I have 4 firebird versions installed (test purposes):
- 2.1.5 x86 (port 3050, installed using installer)
- 2.1.5 x64 (port 21564)
- 2.5.2 x86 (port 25232)
- 2.5.2 x64 (port 25264)

Is possible the Gbak.exe version 2.5.2 trying to use fbclient.dll version 2.1.5 ?

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