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 _______________________________________________ tracker-list mailing list tracker-list@gnome.org http://mail.gnome.org/mailman/listinfo/tracker-list