Sync sqlite3 3.7.0-1.1 (main) from Debian unstable (main)

FYI: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=591298 and https://bugzilla.gnome.org/show_bug.cgi?id=625783 both contain more information on this issue.

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

The bug in sqlite3-0 has now been fixed upstream.
Released in debian as libsqlite3-0_3.7.0-1.1
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=591298

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

This bug was fixed in the package sqlite3 - 3.7.0-1.1

---------------
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.
 -- Chow Loong Jin <email address hidden> Sat, 07 Aug 2010 16:55:51 -0400

SQLite 3.7.1 got released yesterday. For early testers, I prepared Lucid packages in my PPA already:
https://launchpad.net/~aleksander-m/+archive/sqlite3

Cheers.

@Aleksander, the sqlite3 update seems to have helped.

...But I didn't have much time to move around my playlist to fully test it out because Banshee locked up. I ran it in debug mode and it looks like when trying to detect BMPs it freezes. It looks like it was able to detect the BMP of 5 songs and then it locked up.