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

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




Yahoo! Groups Links

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