Sorry BB, somebody else will have to chip in with Linux. I have not enough experience there.

Regarding corruption, generally whenever somebody raises the issue, they get squashed saying that there is no such thing, with people giving examples of databases running for years without corruption.

My take on this is that Firebird databases can get corrupted, usually it can be traced back to the client having done something very stupid. But yes corrupted databases are possible.


Regards
gk



------------------Original Message-----------

From : Boguslaw Brandys <brandys@...>
To : firebird-support@yahoogroups.com
Date : 11/06/2004 5:28:15 PM
Subject : Re: [firebird-support] Some technical questions for experienced Firebird users/programmers

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.
>
>





>>> This mail is created in Hamsa (www.jlmatrix.com) <<<