[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] Bug in fsync in SuSE 9.3
From:       Helmut Tschemernjak <helmut () helios ! de>
Date:       2005-06-27 15:58:21
Message-ID: 42C0221D.7020407 () helios ! de
[Download RAW message or body]


I still don't believe that is a Linux bug. Do you know that you can 
trace all system calls of your app via the "strace" command?

If you can reproduce the problem I would report it to Suse.

best regards / mit freundlichen Gruessen,

Helmut Tschemernjak



Cavit Cahit VURAL wrote:
> Helmut Tschemernjak yazmış:
> 
>> Hi,
>>
>> it is hard to believe that there is a bug in fsync under the Linux 
>> kernel 2.6.10. What kind of filesystem have you used. (NFS, FAT, 
>> Reiser, Ext2/3).
>>
>> Are any special kernel or mount options used?
>> Is it a sparse file?
>> How have you found out that it is related to fsync?
>>
>>
>> best regards
>>
>> Helmut Tschemernjak
> 
> 
> We are using ReiserFS (it's default for SuSE)
> 
> It's kernel's version is 2.6.11.4-20a
> 
> No, they are regular files and no special kernel or mount options.
> 
> 
> 
> The application is about 10 years old and running on 25 servers.
> We have an internal database which using b+tree algorithm. (We are 
> thinking to move SQLite)
> So, before fsync, everything was ok. And when we began to use fsync ,  
> database corruption began. We examined a lot of possibilities like disk 
> corruption, cable damages, memory damages or sofware bug. At last, in an 
> transaction, the main transaction file was corrupted. Then we analyzed a 
> lot , and all clues were showing fsync. We also could not believe, so we 
> disabled it but nothing else, absolutely nothing else. Everything began 
> to work properly and still does.
> 
> Yes, it's hard to believe, but am 99.99% sure, fsync has a bug in SuSE 
> 9.3.  Just i dont know any other application in SuSE 9.3 affects it to 
> work buggy or it's buggy.
> 
> Best Regards
> 
> CC Vural
[prev in list] [next in list] [prev in thread] [next in thread]