[ubuntu-mono] [Bug 612370] Re: Sync sqlite3 3.7.0-1.1 (main) from Debian unstable (main)

[Bug Watch Updater]

** Changed in: banshee
       Status: Invalid => Unknown

** Changed in: banshee
   Importance: Unknown => High

-- 
Sync sqlite3 3.7.0-1.1 (main) from Debian unstable (main)
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: Invalid
Status in “sqlite3” package in Ubuntu: Fix Released
Status in “banshee” package in Debian: Confirmed
Status in “sqlite3” package in Debian: Confirmed

Bug description:
Hi,

For the rationale, please see the original description and discussion below.

Please sync sqlite3 3.7.0-1.1 from Debian unstable (main)

Changelog since 3.7.0:

sqlite3 (3.7.0-1.1) unstable; urgency=high

  [ Iain Lane ]
  * Non-maintainer upload.
  * Backport fix from upstream bug 13f033c865 to fix performance
    regression introduced in 3.7.0-1. (Closes: #591298)

  [ Julien Cristau ]
  * High urgency upload for RC bugfix.

 -- Julien Cristau <jcristau at debian.org>  Sat, 07 Aug 2010 16:55:51 -0400

Cheers,
Iain

-- Original description follows --

  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.