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

[Chow Loong Jin]

** Bug watch added: GNOME Bug Tracker #625783
   https://bugzilla.gnome.org/show_bug.cgi?id=625783

** Also affects: banshee via
   https://bugzilla.gnome.org/show_bug.cgi?id=625783
   Importance: Unknown
       Status: Unknown

-- 
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: Unknown
Status in “banshee” package in Ubuntu: Confirmed
Status in “sqlite3” package in Ubuntu: New
Status in “banshee” package in Debian: Unknown
Status in “sqlite3” package in Debian: Unknown

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.