Skip to content

Restore of wide table can fail with "adjusting an invalid decompression length from <N> to <M>" #7974

@pavel-zotov

Description

@pavel-zotov

Ticket has been created after talk with Vlad.
Bug found during implementing test for #7436
Please consider .sql from attached file.
gh-7436-ddl_and_data.sql.zip

Launch FB 4.x and apply this script ( %FB4X_HOME%\isql -q -i gh-7436-changed-field-names.sql; don't forget to adjust name of temporary database to your env.)

Then make backup (also using FB 4.x: %FB4X_HOME\gbak -b -z -v -g localhost:g:\temp\tmp4test.fdb g:\temp\tmp4test.fbk 1>gh_7436_4x_backup.log 2>&1 )

Then try to restore from just created .fbk using FB 5.x or 6.x (add '-v' command switch to gbak).

Restore will fail; tail of its log:

...
gbak:    restoring column X0000B1
gbak:    restoring column X0000B5
gbak:    restoring column X00000000B6
gbak:committing metadata
gbak:restoring data for table TEST
gbak:adjusting an invalid decompression length from 39 to 37
gbak:   1 records restored
gbak:do not recognize table attribute 0 -- continuing
gbak:do not recognize table attribute 0 -- continuing
gbak:do not recognize table attribute 0 -- continuing
gbak:do not recognize table attribute 0 -- continuing
gbak:do not recognize table attribute 0 -- continuing
gbak:do not recognize table attribute 0 -- continuing
gbak:do not recognize table attribute 0 -- continuing
gbak:do not recognize table attribute 0 -- continuing
gbak:do not recognize table attribute 0 -- continuing
gbak:do not recognize table attribute 0 -- continuing
gbak:do not recognize table attribute 0 -- continuing
gbak:do not recognize table attribute 0 -- continuing
gbak:do not recognize table attribute 0 -- continuing
gbak:restoring data for table TEST
gbak: ERROR:expected record length
gbak:Exiting before completion due to errors

(number of "gbak:do not recognize table attribute 0 -- continuing" can very).

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions