[Ml-yokadi] unable to open database file

Sébastien Renard Sebastien.Renard at digitalfox.org
Sun Aug 23 18:20:37 CEST 2009


Le dimanche 23 août 2009 16:22:47, Stéphane Péchard a écrit :
> > And what kind of filesystem are you using ? Ext3 or something else ? You
> > should not use NFS ou CIFS remote filesystem as they're known to badly
> > interact with sqlite (ineficient locking issue).
>
> the database file is on an ext4 partition

That may be the problem. Ext4 has changed some assumption about flushing writes 
and some software have been bitten. Maybe sqlite have this issue. 

Google mostly report about performance issue with sqlite and ext4... I did not 
manage to find something more complete about that...

> > With a corrupted database, can you try this ?
> >  open you corrupted database with sqlite3 and run the following : PRAGMA
> > integrity_check;
>
> do it as soon as I have the problem again :-)

Thanks.
-- 
Sébastien


More information about the Ml-yokadi mailing list