Issue Details (XML | Word | Printable)

Key: CORE-4050
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Unassigned
Reporter: Honório Morais
Votes: 1
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Error when we try restore an backup using Gbak 2.5.2.26539 and FB 2.0

Created: 14/Feb/13 05:20 PM   Updated: 30/Sep/13 12:28 PM
Component/s: GBAK, GFIX
Affects Version/s: 2.5.2
Fix Version/s: None


 Description  « Hide
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.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Sean Leyne added a comment - 14/Feb/13 05:47 PM
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.

Adriano dos Santos Fernandes added a comment - 14/Feb/13 07:10 PM
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." -- CORE-3733

Beto Neto added a comment - 30/Sep/13 12:28 PM
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 ?