[ubuntu-mono] [Bug 612370] Re: Bug#591298: regarding SQLite3 3.7.0 slowness with banshee

[Iain Lane]

tags 591298 + fixed-upstream
forwarded 591298 http://www.sqlite.org/src/info/13f033c865f878
thanks

Hello,

[ ccing the Launchpad report too ]

On Wed, Aug 04, 2010 at 06:29:43PM +0100, Iain Lane wrote:
>Hiya,
>
>On Wed, Aug 04, 2010 at 06:40:39PM +0200, Laszlo Boszormenyi wrote:
>>Hi Iain,
>>
>>On Wed, 2010-08-04 at 17:20 +0100, Iain Lane wrote:
>>>forwarded 519298 http://article.gmane.org/gmane.comp.db.sqlite.general/58588
>>I've read that 3.7.0.1 won't contain the fix for this bug. Still,
>>reading the commits[1]:
>>[5074b85967] Update the version number to 3.7.0.1. (user: drh, tags: branch-3.7.0)
>>[3f367fe00e] Backport fix 267492d3a7eff7b for the performance regression caused by automatic indexing and reported by ticket 8011086c85c6c4040. (user: drh, tags: branch-3.7.0)
>>
>>Ticket 8011086c85c6c4040 seems to be your bugreport[2] and it said to be
>>backported to the 3.7.0 branch and targeted at 3.7.0.1 .
>>
>>>I also reproduced it using HEAD,
>>>and upstream also confirms that it's still present.
>>Strange, are you sure you've commit 3f367fe00e [3] in your tree?
>
>That's the ticket that drh had me test, and yes I do have that commit
>in my tree. Bug is still present regardless. See the URLs present in
>my mail to the upstream list (for reference, they are [0]) if you wish
>to reproduce for yourself. :)

This has now been fixed upstream. Here's the bug:

      http://www.sqlite.org/src/info/13f033c865f878

Would you like to backport the fix (presumably after updating to
3.7.0.1)? I will prepare the patch if so.

Cheers,
Iain

-- 
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.