Subject RE: [firebird-support] Recurring database corruption
Author Nigel Weeks
Hopefully you're not doing DDL (table/procedure/trigger) changes, AND using
persistent connections to the database from PHP....

> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com]On Behalf Of Chris Wallis
> Sent: Friday, 11 August 2006 4:21 PM
> To: 'firebird-support@yahoogroups.com'
> Subject: [firebird-support] Recurring database corruption
>
>
> 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.
>
> 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
>
> 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.
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>