Re: [Tracker] Too much pain with Evolution 2.24 and Tracker 0.6.9x

[Philip Van Hoof <spam pvanhoof be>]

On Sun, 2009-03-15 at 10:20 +0000, Martyn Russell wrote:

> It should be said that the current solution of looking into the database 
> and trying to deduce what Evolution sees is a really bad idea. This is a 
> temporary solution and we are asking for pain if we stick with it. 

Agreed

> Evolution can do whatever they want here with the database schema (i.e. 
> change it).
>
> Are you able to debug this at all and give us any indication of where 
> the problem is?

Probably at the point where we are doing a rather large SELECT, and
SQLite not allowing Evolution's sqlite3_open itself to interfere with
our process' SELECT until it's finished. Or something like that.

Maybe because Evolution uses large transactions, just like we do for our
non-Evolution database stuff, to increase their performance? ie. while
we are in SELECT is Evolution's TRANSACTION waiting for us to be
finished.

> > It is only recently that I found that tracker-indexer is guilty. In
> > fact, Evolution stops to loop forever when I kill tracker-indexer.
> >
> > "evolution-imap-db.c" uses sqlite3_open(). Perhaps SQLite3 opens
> > Evolution's databases as read-only databases? Or, is Fedora 10 SQLite3
> > that uses particular parameters?

I think it's caused by use of large transactions in Evolution vs. a
large SELECT in Tracker on the same database.

> There might be some issues here. We haven't received many/any? reports 
> of anything like this yet. Maybe it hasn't been used by many people yet. 
> I certainly haven't had any issues with it yet but I am not a heavy user.
>
> > I use latest Tracker version of trunk.
>
> We have another solution in TRUNK too, which allows evolution to push 
> the data to Tracker instead of Tracker dipping in and pull data from 
> Evolution's database. This was done by Philip. Unfortunately the change 
> requires a newer version of Evolution and to be configured to enable in 
> Tracker (since Evolution hasn't been released yet? with these changes).

Right.

> As soon as possible, we will use this method since it is much more 
> reliable than the current solution.

Very much agree. So distributions should as soon as possible start
shipping Evolution > 2.25.2 and enable the feature in Tracker.

More information here: http://live.gnome.org/Evolution/Metadata


-- 
Philip Van Hoof, freelance software developer
home: me at pvanhoof dot be 
gnome: pvanhoof at gnome dot org 
http://pvanhoof.be/blog
http://codeminded.be