Hello, On Tue, Aug 17, 2010 at 03:28:39PM +0100, Will Thompson wrote:
Package: sqlite3 Version: 3.7.0.1-1 Severity: normalHi, Unfortunately, this problem seems to be unfixed by 3.7.0-1.1 or by 3.7.0.1-1. With either version, Banshee freezes for several seconds whenever I hit Next, claiming that it is “Querying model for track to play in album:Next mode”. Downgrading libsqlite3-0 to 3.6.23.1-4 avoids the problem.
That's interesting. Could you please run banshee with --debug-sql, and try to identify a failing query? Or attach the entire log here. I suspect this is a different problem to the one that upstream fixed — I can confirm that the specific fix that I backported and is still in 3.7.0.1-1 is still working. It might be that we need to file yet another upstream bug. In short, I recommend that everyone experiencing problems attempt to isolate queries that have regressed, and file upstream bugs/report them to the BTS. To verify my fix: wget http://people.ubuntu.com/~laney/sqlite/banshee.sql wget http://people.ubuntu.com/~laney/sqlite/banshee.db.copy time sqlite3 banshee.db.copy < banshee.sql This should return in less than half a second on a reasonable machine. If it takes much longer than a second then you can reproduce the original bug. Cheers, Iain
signature.asc
Description: Digital signature
