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

[<tpgww onepost net>]

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.

Regards
Tom


> On 10/31/06, tpgww onepost net <tpgww onepost net> wrote:
> > I've been trying to run a fresh install of trackerd (recent CVS). When the
> > daemon starts, and churns through its initial interrogation of my files,
> > among all the presumably-normal messages I get _lots_ of these:
> >
> > ERROR : prepared query InsertPendingFile failed due to SQL logic error or
> > missing database
> >
> > and fewer, but still a lot, of
> >
> > ERROR : prepared query CreateService failed due to SQL logic error or
> > missing database
> > and
> > ERROR : prepared query InsertServiceWord failed due to SQL logic error or
> > missing database
> >
> > I've stepped through the startup process, and can confirm:
> >
> > - other SQL procedures are working
> > - sampled data supplied to the InsertPendingFile procedure seems to be
> > consistent with that procedure, and with the table affected  by the
> > procedure (but I'm very small on SQL)
> >
> > The database (data and depots) exists. I'm using sqlite 3.3.6.
> >
> > Any suggestions about how to deal with this ?
> >
> > Regards
> > Tom
> > _______________________________________________
> > tracker-list mailing list
> > tracker-list gnome org
> > http://mail.gnome.org/mailman/listinfo/tracker-list