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

[Iain Lane]

Yes, that was my NMU. I've asked for sponsorship for the sync now.
Should be fixed soon.

** Changed in: banshee (Ubuntu)
       Status: Confirmed => Invalid

** Changed in: sqlite3 (Ubuntu)
       Status: Triaged => New

** Summary changed:

- Banshee becomes extremely slow after sqlite3 3.6.23.1-4 => 3.7.0-1 upgrade
+ Sync sqlite3 3.7.0-1.1 (main) from Debian unstable (main)

** Description changed:

-   affects ubuntu/banshee
-   status confirmed
-   affects ubuntu/sqlite3
-   status new
-   subscribe tsmithe
+ 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.

-- 
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: Invalid
Status in “banshee” package in Ubuntu: Invalid
Status in “sqlite3” package in Ubuntu: New
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.