Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

user cant login (gbak -b dont work, gbak -b -g works, gbak -c works, login dont works) [CORE2260] #2686

Open
firebird-automations opened this issue Dec 29, 2008 · 3 comments

Comments

@firebird-automations
Copy link
Collaborator

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

@firebird-automations
Copy link
Collaborator Author

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.

@firebird-automations
Copy link
Collaborator Author

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)

@firebird-automations
Copy link
Collaborator Author

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 ?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant