Hi Aage,

> Sergey B. wrote:
> Anybody knows that database does not like incorrect
> shutdown of system or hardware (for example turning off power or
> system restart via Reset Button etc.). It causes various
> corruptions of database structure i. e. orphan pages, corrupted
> indexes, lost data pages, ... bla-bla-bla.
> Good. And what about IB database corruption during
> ABSOLUTELY CORRECT explotation?
> -----------------------------------------
>
> What about faulty hardware? (disks?, power supply? - an UPS is usually a
> good thing)
> Are the 2 (or 3) last cases on the same server?

No. 2 last cases had place at different computers.
Naturally, all servers has UPS. It was the first thing I required.
No hardware failrues. No server restarts. No exceptions.
Nothing suspected :-((.

I have unexpected thoughts. The story is below.

During explotation Interbase performed AUTOMATIC sweep
and garbage-collection. Often sweep process started during
rush-hours. So I force IB do not perform garbage collection
and sweep automatically. Users have to start it manually
daily on midnight (or some later when there no customers
at the store), when 'nothing to do'.

Then all 6 shops continued their work during following
three monthes. THERE NO ANY MORE DATABASE
CORRUPTION.

THE CONCLUSION
IB may corrupt database WHEN SWEEP OR GARBAGE
COLLECT AND DATA UPDATE (performs insert, delete,
update) at THE SAME TIME.

Regards,
Sergey Balter
balter@...