[Pkg-kde-extras] Bug#681121: Bug#681121: Bug#681121: amarok: attempts to upgrade MySQL database on every application start

[Modestas Vainius]

Control: severity -1 normal
Control: title -1 amarok database is stuck at version 7 (amarok 2.2.0)
Control: tags -1 upstream

Hello,

On Thursday 12 July 2012 15:02:44 Ira Rice wrote:
> 0000020   A   C   K soh nul nul nul nul soh nul dc1 nul   ~  nl   D   B
>            4341    014b    0000    0000    0001    0011    0afe    4244
> 0000040   _   V   E   R   S   I   O   N bel nul nul nul soh nul nak nul
>            565f    5245    4953    4e4f    0007    0000    0001    0015
                                             ^^^^
It seems that your database is at version 7 (which is amarok 2.2.0) while 
current version is 14. Apparently, amarok has not fully succeeded in updating 
the database since then...

So each time amarok starts, it runs (or not) 7 upgrade scripts some of which 
have already been completed probably. Since the code does not appear to have a 
sence of database transactions (as far as I can tell anyway, I might be 
wrong), your database might already be in inconsistent state. Therefore, I 
strongly recommend to backup and purge database, then start from scratch (and 
export playlists/other data to external files beforehand).

Alternatively you could run:

$ amarok --debug --nofork 2>&1 | tee amarok-debug.log

wait for amarok to start, close it and then attach amarok-debug.log. What is 
more, take notice of which statement amarok gets stuck at if any. However, I 
doubt this will take us far since the only way to fix your dabatase is to hack 
it manually.

I'm marking this bug as normal since 2.2.0 has never been in stable (first 
version in stable is 2.4.3) and iirc, < 2.3 series had some nasty bugs which 
might have led to this state after all.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part.
URL: <http://lists.alioth.debian.org/pipermail/pkg-kde-extras/attachments/20120818/f33eb3f0/attachment.pgp>