Subject | Re: Database corruption observations in attention to Mrs. Borrie |
---|---|
Author | Ivan Maradzhiyski |
Post date | 2007-12-20T12:25:13Z |
Thanks for your cooperation, Milan.
Probably that is one of my problems, indeed.
My slacks are poisoned with ReisersFS.
On freeBSD(with UFS) I have not encountered such situation.
The other problem is with long running queries.
A database hosted on one of my Slack servers crashes almost every day.
The crash becomes after of a long running report.
There is no power failure or other hardware crash.
--- In firebird-support@yahoogroups.com, Milan Babuskov <milanb@...>
wrote:
Probably that is one of my problems, indeed.
My slacks are poisoned with ReisersFS.
On freeBSD(with UFS) I have not encountered such situation.
The other problem is with long running queries.
A database hosted on one of my Slack servers crashes almost every day.
The crash becomes after of a long running report.
There is no power failure or other hardware crash.
--- In firebird-support@yahoogroups.com, Milan Babuskov <milanb@...>
wrote:
>for some
> Michael Weissenbacher wrote:
> >> If your filesystem is ReiserFS (which was unfortunately default
> >> Slackware versions) switch to ext3 (or something else) ASAP. Ihad many
> >> problems with corruption and ReiserFS, and they all vanishedafter we
> >> switched to ext3.firebird. But
> > Well, as always, YMMV. I've never had problems with reiserfs +
> > i've moved to XFS now since reiserfs's future seems unclear.
>
> I forgot to write that, but ReiserFS problems are really related to the
> 'power failure' corruption that OP was having. At the company were I
> worked we did an extensive 'power failure' testing of Firebird on
> ReiserFS and Ext3, and ReiserFS would simply fail to recover in very
> high % of the cases. Some details about it in my blog:
>
> http://swoes.blogspot.com/search?q=reiser
>
> --
> Milan Babuskov
> http://www.flamerobin.org
>