Dnia Mon, 21 Jun 2004 15:32:52 +0530, GOVINDKRISHNA
<gkrishna@...> napisał:

> I do get corrupted databases with Forced writes on. Not sure if it is
> because of a faulty chip <g>
>
> Tends to happen more on windows 98 than on 2000. But does happen on 2000
> if the UPS fails or server reboots because of a faulty CPU fan etc.
>
> However some points to note
>
> 1. My application stores lots of large blobs.
> 2. There are some fundamental design flaws in my app ( I did not know
> enough about Firebird when I designed it.) The difference between OAT
> and next transaction is pretty large can be between 3000 to 10000.
> (Fixing it in my next rewrite of the app)
>
> gk

Thank You,

But what about Linux : is switching on Forced Writes on Linux requred or
no (ext3 partition) ?
I want to be sure that no software configuration or operation could
corrupt my database (beside broken hardware). Once I tried to create
unique on two columns and unfortunately there was a few connections
pumping data to the same table (Windows XP, Firebird 1.5 final, IB Expert
personal used)
Database gets corrupted (orphan index and data pages) and I could'nt
backup/restore even mended database.I was lucky becouse that was only
import data tests .
By the way : how secure is Firebird against corruption compared to
Oracle,MS SQL Server ?
Is there any article comparing these issue ? I think it would be
interesting to read something about it.

--
Best Regards
Bogusław Brandys

>
> ------------------Original Message-----------
>
> From : Boguslaw Brandys <brandys@...>
> To : "firebird-support.yahoogroups.com"
> <firebird-support@yahoogroups.com>
> Date : 18/06/2004 4:13:08 PM
> Subject : [firebird-support] Some technical questions for experienced
> Firebird users/programmers
>
> Hello,
>
> I don't know if this is the right group for that questions , so fix me if
> i'm wrong.
>
> I was told that some cheap IDE drives have broken chips and incorrectly
> return written status (checked using for example fsync() UNIX ,
> FlushFileBuffers() Windows functions) for data in internal disc buffer
> BEFORE actually write them on disc surface, so the question are : does
> Firebird uses those functions and does anybody have problems with
> corrupted databases even using Forced Writes on, on Windows/Linux
> (without
> using UPS of course) ?
>
> Is switching on Forced Writes on Linux (ext3 partition) gives any better
> security against data corruption ? I don't see it's mentioned as required
> under Linux.
>
>

--
Best Regards
Bogusław Brandys