Hello Vlad

> We have experienced out first database corruption from any of our

customers

> in 15 years of Interbase and Firebird!
>
> I would like some clues as to what may have caused it.
>
>
>
> FB 1.5.3, windows server 2003, superserver

/ Read ReleaseNotes for 1.5.5 (and, better for 2.1.2) and seek how many
/index related error was fixed. Then ask yourself - why i still use 1.5.3
/???

I hear what you're saying. Trouble is that there is so much work checking
out thousands of possible SQL constructions to ensure they don't fall foul
of the tighter requirements of FB2 we cant justify the time spent,
especially when the customers will see no real benefit. We will just have
to gradually check out our code until we are more confident of complying -
might take a few years yet!

/Without run of gfix -v -f it is impossible to said even which kind of
/corruption you encountered. Upgrade at least up to 1.5.5 ASAP and consider
/upgrade to 2.1...

I will run gfix and see what I can learn from it. I understood that 1.5.5
was a security fix so I am assuming it wouldn't have helped. Anyway I will
read the release notes and move to it of possible.

Thanks for you help
Regards
Paul