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

Index corrupted [CORE3069] #3448

Open
firebird-automations opened this issue Jul 10, 2010 · 1 comment
Open

Index corrupted [CORE3069] #3448

firebird-automations opened this issue Jul 10, 2010 · 1 comment

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: vander clock stephane (arkadia)

Votes: 2

Without any hardware error (not server shuntdown, no memory or harddrive problem) we have all the time some index corrupted

* FB 2.5.0.26038 super classic with around 50 000 000 queries / days
* The database is arround 50 GO in size

sometime the index corrupted not block the client application to work, sometime yes because it's make the server enter in undefinite loop.
After Vlad correct the bug with monitoring table the index corrupted problem was not so often BUT it's still happen (before one time every 2/3 days now one time every 2/3 weeks) ... we are still using monitoring table, so it's possible that the problem is still connected to monitoring table

the last time the problem happen, the server become to write in the firebird.log
INET/select_wait: found "not a socket" socket : 504 ... when we try to validate the database we discover that lot of index was corrupted (235 errors founds)

* what do you need exactly to be able to reproduce the bug ? as you see it's involve in a very intensive environement that it's not easy to reproduce
* can the index corrupted appear on "inet error" ?
* can the fb_inet_server can crash without any warning, without writing anything in the log (i thing yes) ? and in this way that can explain the index corrupted if the server crash in the middle of a write ! but for now nothing in the log show that the fbserver crash !

anyway this is a major bug, because index must never be possible to be corrupted without any hardware error ...

thanks for all !
stephane

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

priority: Blocker [ 1 ] => Critical [ 2 ]

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