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

[Ira Rice]

Package: amarok
Version: 2.6~beta1+75.g47e75df-1
Severity: grave
Justification: renders package unusable

In the NEWS file for 2.6~beta1, it mentioned that for smaller playlists,
there
would be a few minute delay while it updated the database format. However, I
have a larger database (4600+ tracks in a playlist, with more on disk), and
this takes more along the lines of 1 1/2 to 2 hours, where it then doesn't
give
any obvious indication that it is then doing anything (but which I can
verify
that it's upgrading the tables through MySQL Workbench).

If this only happened once, I could understand it, but it attempts to do
this
upgrade on every application restart, no matter how many times it has done
it
before. And this is despite never having interrupted the process for taking
so
long, having cleared my current playlist and resaving it, hoping that
saving it
in the new format would remove the need to upgrade the tables again,
ensuring
that there isn't a disk space issue causing it to prematurely stop during
upgrade, and ensuring that Amarok is able to read and write to the database.

This currently imposes a rather severe usability break on my system, making
it
so that closing Amarok or it crashing at all are a lot more painful, and
should
block this version from release for Wheezy, IMO, if it can't be resolved
easily. To me, it's currently looking like the code which is checking
whether
the database is up-to-date is failing to either check something which it's
supposed to be writing to the SQL database which the new format has but the
old
one doesn't, or that the code is breaking somewhere within the upgrade
process,
and it doesn't catch it.

If you need more information (for instance, my SQL dump, which is around
300+MB
for amarok last time I checked), then email me in private for what you
need. I
don't want to attach unnecessary personal information to this bug in public.



-- System Information:
Debian Release: wheezy/sid
  APT prefers unstable
  APT policy: (500, 'unstable'), (1, 'experimental')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 3.4.0-4.dmz.2-liquorix-amd64 (SMP w/2 CPU cores; PREEMPT)
Locale: LANG=en_US.utf8, LC_CTYPE=en_US.utf8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages amarok depends on:
ii  amarok-common             2.6~beta1+75.g47e75df-1
ii  amarok-utils              2.6~beta1+75.g47e75df-1
ii  kde-runtime               4:4.8.4-1
ii  libaio1                   0.3.109-3
ii  libavcodec53              7:0.10.3-dmo1
ii  libavformat53             7:0.10.3-dmo1
ii  libc6                     2.13-34
ii  libcurl3-gnutls           7.26.0-1
ii  libgcc1                   1:4.7.1-4
ii  libgcrypt11               1.5.0-3
ii  libgdk-pixbuf2.0-0        2.26.1-1
ii  libgl1-mesa-glx [libgl1]  8.0.3-1
ii  libglib2.0-0              2.32.3-1
ii  libgpod4                  0.8.2-6
ii  libkcmutils4              4:4.8.4-3
ii  libkdecore5               4:4.8.4-3
ii  libkdeui5                 4:4.8.4-3
ii  libkdewebkit5             4:4.8.4-3
ii  libkdnssd4                4:4.8.4-3
ii  libkfile4                 4:4.8.4-3
ii  libkio5                   4:4.8.4-3
ii  libknewstuff3-4           4:4.8.4-3
ii  liblastfm0                0.4.0~git20090710-1
ii  libloudmouth1-0           1.4.3-8
ii  libmtp9                   1.1.3-35-g0ece104-1
ii  libmysqlclient18          5.5.24+dfsg-4
ii  libofa0                   0.9.3-5
ii  libphonon4                4:4.6.0.0-2
ii  libplasma3                4:4.8.4-3
ii  libqjson0                 0.7.1-6
ii  libqt4-dbus               4:4.8.2-1
ii  libqt4-network            4:4.8.2-1
ii  libqt4-opengl             4:4.8.2-1
ii  libqt4-script             4:4.8.2-1
ii  libqt4-sql                4:4.8.2-1
ii  libqt4-svg                4:4.8.2-1
ii  libqt4-xml                4:4.8.2-1
ii  libqtcore4                4:4.8.2-1
ii  libqtgui4                 4:4.8.2-1
ii  libqtscript4-core         0.2.0-1
ii  libqtscript4-gui          0.2.0-1
ii  libqtscript4-network      0.2.0-1
ii  libqtscript4-sql          0.2.0-1
ii  libqtscript4-uitools      0.2.0-1
ii  libqtscript4-xml          0.2.0-1
ii  libqtwebkit4              2.2.1-4+b1
ii  libsolid4                 4:4.8.4-3
ii  libstdc++6                4.7.1-4
ii  libtag-extras1            1.0.1-3
ii  libtag1c2a                1.7.2-1
ii  libthreadweaver4          4:4.8.4-3
ii  libx11-6                  2:1.5.0-1
ii  libxml2                   2.8.0+dfsg1-4
ii  phonon                    4:4.6.0.0-2

Versions of packages amarok recommends:
pn  kdemultimedia-kio-plugins  <none>

Versions of packages amarok suggests:
pn  amarok-doc         <none>
ii  libqt4-sql-mysql   4:4.8.2-1
ii  libqt4-sql-psql    4:4.8.2-1
ii  libqt4-sql-sqlite  4:4.8.2-1
ii  moodbar            0.1.2-3

Versions of packages amarok-common depends on:
ii  perl  5.14.2-12

amarok-common recommends no packages.

Versions of packages amarok is related to:
ii  phonon-backend-gstreamer [phonon-backend]  4:4.6.0.0-2

-- no debconf information
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.alioth.debian.org/pipermail/pkg-kde-extras/attachments/20120710/2d34ad52/attachment-0001.html>