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

[firebird-issue-importer]

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-issue-importer]

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-issue-importer]

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-issue-importer]

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 ?