Issue Details (XML | Word | Printable)

Key: CORE-3069
Type: Bug Bug
Status: Open Open
Priority: Critical Critical
Assignee: Unassigned
Reporter: vander clock stephane
Votes: 2
Watchers: 3

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

Index corrupted

Created: 10/Jul/10 03:37 PM   Updated: 07/Sep/10 09:13 AM
Component/s: Engine
Affects Version/s: 2.5 RC3
Fix Version/s: None

Environment: Windows 2008 R2 64 bit, FB super classic

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

* FB 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 !

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.