Open firebird-automations opened 15 years ago
Commented by: @hvlad
"don't work" is noting for us. Write full error message. It seems your database is corrupt. Run gfix -v -f and look at firebird.log for detailed log of errors found.
Commented by: @doychin
I have the same issue with Firebird 2.1.2. The database was under heavy load. I had 15 threads simultaneously pumping data into 2 of the tables . Both are listed below and corrupted or at least the indexes are corrupted.
while everything was working normally suddenly I got the same error message: wrong page type expected 7 found 5
gifx -v -f shows this: Summary of validation errors Number of index page errors : 5 Number of database page errors : 1
gbak works only when I specify -G option but I'm loosing data because that data page is right in the middle of one of the biggest tables in the database. I loose almost half of the data in that table.
Here is a copy of my firebird.log after gfix execution
DDBPC Mon Jun 01 09:42:09 2009 Database: H:\POWERPRO_KABELNET.FDB Index 3 is corrupt on page 2307 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1648 in table CASH_CLIENT_BILL (220)
DDBPC Mon Jun 01 09:42:10 2009 Database: H:\POWERPRO_KABELNET.FDB Index 10 is corrupt on page 2381 level 1. File: ..\..\..\src\jrd\validation.cpp, line: 1648 in table CASH_CLIENT_BILL (220)
DDBPC Mon Jun 01 09:42:10 2009 Database: H:\POWERPRO_KABELNET.FDB Index 5 has orphan child page at page 19682 in table CASH_PAYMENT (257)
DDBPC Mon Jun 01 09:42:10 2009 Database: H:\POWERPRO_KABELNET.FDB Page 32235 wrong type (expected 7 encountered 5)
DDBPC Mon Jun 01 09:42:10 2009 Database: H:\POWERPRO_KABELNET.FDB Index 5 is corrupt on page 32235 level 62. File: ..\..\..\src\jrd\validation.cpp, line: 1454 in table CASH_PAYMENT (257)
DDBPC Mon Jun 01 09:42:10 2009 Database: H:\POWERPRO_KABELNET.FDB Index 5 is corrupt on page 32235 level 62. File: ..\..\..\src\jrd\validation.cpp, line: 1468 in table CASH_PAYMENT (257)
Commented by: @hvlad
1. why do you think you have the *same* issue ? Author of ticket provided zero info. 2. this is not a support forum, use it next time please. 3. why do you think you loose data ? If you really think so, ask at support forum for repair services.
And at last : could you give me copy of broken database and your firebird.log for analyse ?
Submitted by: reinhard (reinhard)
1.) I tried to make backup from the db-file, but gbak -user -passwor -b "path\asdf.fdb" "path\to\asdf.fbk" dont work
2.) i tried gfix couple times , always with "wrong page type expected 7 found 5" on one Table.
3.) i tried gfix -mend no effect (no return, just finished) 3.) i tried gfix -sweep no effect (no return, just finished)
4.) I made gbak -user -password -b -g "path\asdf.fdb" "path\to\asdf.fbk" that works (parameter -g)
5.) i tried to restore the backup gbak -user -password -c "path\to\asdf.fbk" "path\asdf-create.fdb"
6.) log in with user gismo -> dont work 7.) lon in with user sysdba --> works
How to get the db to work for user gismo???
How to