Subject Re: Recurring database corruption
Author Zoran Zivkovic
--- In firebird-support@yahoogroups.com, Chris Wallis <cwallis@...>
wrote:
>
> I'm hoping that someone can give me ideas on the cause of recurring
database
> corruption on a Firebird 1.5.2 database. We've used Interbase, and
later,
> Firebird for over 10 years, and it has been a stable, dependable
system.

We are still on I.B 6.0.

>
> Within the last three months, I've had more problems with database
> corruption than in the previous 10 years. "What's different?" I ask
myself.
> There are two new programmers hitting the database via PHP. That's
the only
> significant difference that I'm aware of. The errors after
validation
> tonight are:
>
> Summary of validation errors
>
> Number of index page errors : 6
> Number of database page errors : 3
>

As I also wrote few days a go, we have something similar:

index page errors: 328
database page errors: 4923


> reported from IBExpert. The database validated with no errors less
than 5
> days ago.
>
> I've checked the disk at a software level (this happens to be on a
WinNT
> system, but we also use Linux) and everything checks out, so I'm
assuming
> that there is some other problem, perhaps related tto the PHP
stuff, which I
> don't control.
>
> I've never had these kinds of problems before, and now I'm having
to rebuild
> the database weekly. The hardware is relatively modern, even if the
O/S is
> not. Any ideas would be greatly appreciated.
>

We also didn't have these problems untill recently. Now we are doing
backup of the database 6 times per day, :). I wrote about this
problem few days a go, but only response I got was "go to firebird,
interbase is buggy". It seems to me that we sometimes get "automatic"
replys here. For me, even if I know IB6.0 has some limitations (or
bugs), I think if it worked ok for 5 years, pass on new version is
not "automatic solution" for some new problem.

Anyway, I would appreciate if you find solution for this if you can
send me private email with info what caused probelm to you.

Regards,

Zile