Issue Details (XML | Word | Printable)

Key: CORE-2260
Type: Bug Bug
Status: Open Open
Priority: Critical Critical
Assignee: Unassigned
Reporter: reinhard
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

user cant login (gbak -b dont work, gbak -b -g works, gbak -c works, login dont works)

Created: 29/Dec/08 01:41 PM   Updated: 01/Jun/09 02:51 PM
Component/s: None
Affects Version/s: 1.5.5
Fix Version/s: None

Environment: windows xp


 Description  « Hide
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


 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Vlad Khorsun added a comment - 05/Jan/09 04:07 AM
"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.

Doychin Bondzhev added a comment - 01/Jun/09 09:17 AM
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)


Vlad Khorsun added a comment - 01/Jun/09 02:51 PM
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 ?