search

FirebirdSQL / firebird

Firebird server, client and tools
https://www.firebirdsql.org/
1.23k stars 212 forks source link

restore - WARNING:Bad debug info format #6791

Open tonne1 opened 3 years ago

tonne1 commented 3 years ago

WI-V4.0.0.2442 RC1 and WI-V4.0.0.2452 RC1 in legacy mode.

Restoring a backup from an ODS12 database:

with WI-V3.0.7.33374, as expected

... gbak: restoring SQL role: USR$ADMIN gbak:creating indexes gbak:committing metadata
gbak: activating and creating deferred index IDX_TAG
...

with WI-V4.0.0.2452, with warning

... gbak: restoring SQL role: USR$ADMIN gbak:creating indexes gbak:committing metadata gbak: WARNING:Bad debug info format gbak: activating and creating deferred index IDX_TAG
...

That's the only difference in the restore-logs. Both restores complete successfully. It makes no difference if the fbk ist just metadata or a full backup. Firebird 4 restores the backup with warning, Firebird 3 does not. Where to look further to get the reason of the warning?

hvlad commented 3 years ago

Both fb3 and fb4 uses the same format of debug information. Probably, fb3's gbak lost the warning. In any case, it is harmless for database. Debug info used to produce more useful error messages and build call stack. It is regenerated every time you CREATE or ALTER stored procedure or trigger or PSQL-function.

tonne1 commented 3 years ago

Thanks Vlad, so nothing to worry about. Volker