Subject Re: [firebird-support] CORE-4467
Author Ivan Arabadzhiev
Index recalculation (I think) was done to minimize the configuration needed (unfortunately, I wasn`t involved in the initial design). Non the less - it hasn`t been an issue for the past 7-8 years and is still working in most instances.
The error count comes from a full validation with gfix (done on a file "broken" by the issue I`ve described in the core).

2014-06-21 0:02 GMT+03:00 Jesus Garcia jegaza@... [firebird-support] <>:

El 20/06/2014, a las 21:33, "Ivan Arabadzhiev intelrullz@... [firebird-support]" <> escribió:


So I was redirected to the list to discuss
What I can add is that it occurred to me to run a validation on the database after I get the error (I keep a copy, just in case backup/restore goes wrong).
Result is :
Summary of validation errors

        Number of record level errors   : 3
        Number of database page errors  : 1

Given that backup/restore goes smoothly, I assume the errors are in metadata pages (somewhere in index if the error is anything to go by).
I`m willing to run any suggested tests that might help. The load that breaks the database is reproducable but I`d really prefer not to upload a few years worth of customer data (worst case scenario - I`ll scramble it and take the chance).
As I said before - up to about a month ago things have been running fine.