Wrong page type

[Franky Brandt]

Hi all,

Big problem at a customer, the nightly backup of their database is not happening anymore, i found out that i also get a error when i manually backup the database.

The error message is
'wrong page type page 453162 is of wrong type (expected 7, found 5)'
gds_$recieve failed
unknown ISC error 336330835

I tried gfix but that didn't fix it.

i also looked in RDB$PAGES but there is no page with id 453162.

Any tip to solve this problem would be very appreciated.

[Franky Brandt]

I managed to find the cause few hours after creating the ticket, the data in one table seems corrupt, even going over the records in that table ultimately results in the same error, the data is reproducible so i can just drop the table dependencies, drop the table and create all again.
Executing delete from <table> also is not a option as results in the same error.
After recreating the table backup + restore worked fine.

Op maandag 29 april 2024 om 20:45:13 UTC+2 schreef Franky Brandt:

[Attila Molnár]

Hi!

We had the same problem. The solution was to use TCP/IP connection url for gbak, not just a local file path.

https://github.com/FirebirdSQL/firebird/issues/7151

https://github.com/FirebirdSQL/firebird/issues/7443

[Mark Rotteveel]

On 29/04/2024 14:50, Franky Brandt wrote:
> Big problem at a customer, the nightly backup of their database is not
> happening anymore, i found out that i also get a error when i manually
> backup the database.
>
> The error message is
> 'wrong page type page 453162 is of wrong type (expected 7, found 5)'
> gds_$recieve failed
> unknown ISC error 336330835
>
> I tried gfix but that didn't fix it.
> i also looked in RDB$PAGES but there is no page with id 453162.

The RDB$PAGES table does not list all pages.

> Any tip to solve this problem would be very appreciated.

Try to use gfix
(https://firebirdsql.org/file/documentation/html/en/firebirddocs/gfix/firebird-gfix.html)
on a *copy* of the database (or at least, make sure you make a
file-level copy of the database for safekeeping).

Mark
--
Mark Rotteveel