[ubuntu-mono] [Bug 612370] Re: Banshee becomes extremely slow after sqlite3 3.6.23.1-4 => 3.7.0-1 upgrade

[papukaija]

** Tags added: maverick

-- 
Banshee becomes extremely slow after sqlite3 3.6.23.1-4 => 3.7.0-1 upgrade
https://bugs.launchpad.net/bugs/612370
You received this bug notification because you are a member of Ubuntu
CLI/Mono Uploaders, which is subscribed to banshee in ubuntu.

Status in Banshee Music Player: Confirmed
Status in “banshee” package in Ubuntu: Confirmed
Status in “sqlite3” package in Ubuntu: Triaged
Status in “banshee” package in Debian: Confirmed
Status in “sqlite3” package in Debian: Confirmed

Bug description:
  affects ubuntu/banshee
  status confirmed
  affects ubuntu/sqlite3
  status new
  subscribe tsmithe

[This is a transplanted Debian bug, that also applies to Ubuntu]
[Not sure whether this is a Banshee or SQLite bug.]

After I upgraded sqlite3 (and its libs) from 3.6.23.1-4 to 3.7.0-1, Banshee
becomes extremely slow. For instance, it hangs for a minute right after
startup, and also for many seconds in between songs. Fwiw, strace(1)'ing the
process shows nothing special.

Downgrading SQLite and its libs to the old version fixes the problem. Note
that the problem occurs with both Banshee 1.6.x and 1.7.x.

Attached is a log of banshee --debug --debug-sql which shows the SQL queries
performed, and the time taken for each one.