Re: [Tracker] Errors in SQLite stored procedures ? NO New SQLite fixed it

[Jamie McCracken <jamiemcc blueyonder co uk>]

tpgww onepost net wrote:
> On Mon, 30 Oct 2006 19:04:58 +0100
> "Ulrik Mikaelsson" <ulrik mikaelsson gmail com> wrote:
>
> > I think you're seeing a variant of
> > http://mail.gnome.org/archives/tracker-list/2006-October/msg00240.html
> >
> > It should be fixed now, I think. Dunno if you have to recreate your index,
> > though? (Jamie?)
> >
> > Regards
> > / Ulrik
>
> I updated my sqlite to 3.3.8, with thread-protection configuration options enabled.
>
> Presto, the error reports are gone !!
>
> I can't be sure if the improvement was due to some bugfix, or the re-configuration, but I suspect the latter.

Im not surprised. Looking at sqlite3.pc in /usr/lib/pckconfig it does 
not have pthread in the libs section meaning thread safe mode is off by 
default in edgy and dapper.

sqlite is by default relying on file locks and these seem to work in my 
case even amongst threads (though I accept they may not work in all 
cases). This might also explain some of the corruption with invalid 
uri's not showing up or data loss.

I will probably inline and static link a private version of the sqlite 
lib with thread safe mode compiled in just to be on the safe side



--
Mr Jamie McCracken
http://jamiemcc.livejournal.com/