Re: [Banshee-List] Fatal Error Banshee 2.1.0, Ubuntu 11.04

[Bertrand Lorentz <bertrand lorentz gmail com>]

On Mon, May 16, 2011 at 7:38 AM, olivier dufour <olivier duff gmail com> wrote:
> Hello,
> 1) Why not add a menu option to load this sql db fix ?
> Best is to make an extention wich is not by default.I know that it need
> dependancy sqllitetool.

This is tracked in this bug :
https://bugzilla.gnome.org/show_bug.cgi?id=621057

> 2) The second point is why db corrupt ? We know that we get a lot of
> corruption whereas never eard of such corruption with firefox or other
> sqllite tool... so can we log somewhere last 10 queries...

We're using our sqlite database with the "PRAGMA synchronous = OFF"
option, I think for performance reasons.
Some details in the sqlite documentation :
http://sqlite.org/pragma.html#pragma_synchronous

For the various reports of database corruption I've seen, there was
always some kind of crash before it was noticed : Banshee, system,
power failure, etc. But of course I'd be happy to be shown otherwise.

I think Firefox is using synchronous = NORMAL or FULL, and I seem to
remember that this setting was involved in the "it takes more than a
minute to startup" complaints...

In any case, I'd be interested in seeing some data on the performance
hit if we have synchronous = NORMAL

-- 
Bertrand Lorentz