Summary: | Problem scaning collection after upgrade | ||
---|---|---|---|
Product: | [Applications] amarok | Reporter: | ayllu <ayllu.comunidad> |
Component: | Collections/Local | Assignee: | Amarok Developers <amarok-bugs-dist> |
Status: | RESOLVED DOWNSTREAM | ||
Severity: | normal | CC: | damien.cassou, faiyaza, jr, jzeimen, maximilian.kossick, mitchell, rhm47, sa4amz |
Priority: | HI | ||
Version: | 2.3.0 | ||
Target Milestone: | --- | ||
Platform: | unspecified | ||
OS: | Linux | ||
Latest Commit: | Version Fixed In: | ||
Sentry Crash Report: | |||
Attachments: |
output after running amarok --debug and updating the collection
Full output from running amarok --debug Output of amarok --debug strace output |
Description
ayllu
2010-03-16 04:12:51 UTC
I am having the same problem. I tell Amarok to rescan my entire collection after seeing nothing in my collection after the upgrade. It takes a while to scan then under local collection where it says how many tracks there are it says "counting." After a few seconds it says 0 tracks and displays nothing under local collection. I'm using Ubuntu 9.10 with a recently upgraded 2.2.2 to 2.3.0 version of Amarok. Having Amarok recreate the ~/.kde/share/amarok/ folder by removing it then running Amarok again give the same results. Confirmed by comment #1 *** Bug 230971 has been marked as a duplicate of this bug. *** This bug should probably be classified with a 'Major' severity. It makes Amarok mostly useless for most users who have the bug. This is not necessarily a bug in Amaork but a problem with the Kubuntu package, so far no other distribution has reported problems. What versions of mysql, and are you using the embedded or external database plugins? I've haven't touched the configuration of Amarok at all. I guess I'm using an embedded database. $ aptitude show mysql-common Package: mysql-common State: installed Automatically installed: no Version: 5.1.37-1ubuntu5.1 $ aptitude show libmysqlclient16 Package: libmysqlclient16 State: installed Automatically installed: no Version: 5.1.37-1ubuntu5.1 Was there a mysql upgrade at the same time as the Amarok one? (Just trying to establish a baseline here) Paquete: mysql-common Estado: instalado (insatalled) Instalado automáticamente: sí (yes) Versión: 5.1.37-1ubuntu5.1 Prioridad: opcional Sección: database Desarrollador: Ubuntu Developers <ubuntu-devel-discuss@lists.ubuntu.com> Tamaño sin comprimir: 164k Tiene conflictos con: mysql-common-4.1 Reemplaza: mysql-common-4.1 Proporciona: mysql-common-4.1 Descripción: MySQL database common files (e.g. /etc/mysql/my.cnf) nop, I just was amarok upgrade, and app installer upgrade (In reply to comment #8) > Was there a mysql upgrade at the same time as the Amarok one? (Just trying to > establish a baseline here) No, last mysql update dates from February. (I'm on #amarok IRC channel with the DamienCassou nickname if you want to go faster). I a ubuntu gnome user, maybe could be a conflict with gnome. (In reply to comment #12) > I a ubuntu gnome user, maybe could be a conflict with gnome. I'm also on Ubuntu and Gnome. I have a laptop and netbook, laptop is running Amarok fine and the netbook is the one having issues with the collection. I keep both of the computers almost the same they currently have all the same repositories selected and are up to date they are both running Ubuntu 9.10. I have the same version of mysql-common and libmysqlclient16 (5.1.37-1ubuntu5.1). I just let Amarok handle the database stuff with out changing any of those settings so I believe I am using the same embedded database. What else can I help check between these two computers to see what the difference is on the netbook that is causing these problems? Created attachment 41692 [details]
output after running amarok --debug and updating the collection
Can you try opening up a terminal, running "kbuildsycoca4 --noincremental" and seeing if that helps? (In reply to comment #15) > Created an attachment (id=41692) [details] > output after running amarok --debug and updating the collection It would be far more useful if you gave me the output from the beginning, not after updating the collection. amarok: BEGIN: void SqlCollection::updateTrackUrlsUids(const ChangedTrackUrls&, const QHash<QString, QString>&) amarok: END__: void SqlCollection::updateTrackUrlsUids(const ChangedTrackUrls&, const QHash<QString, QString>&) - Took 7.5e-05s amarok: BEGIN: virtual XmlParseJob::~XmlParseJob() amarok: BEGIN: void StatusBar::hideProgress() amarok: END__: void StatusBar::hideProgress() - Took 0.00054s amarok: END__: virtual XmlParseJob::~XmlParseJob() - Took 0.00085s amarok: [ERROR!] Tried to perform query on uninitialized MySQL amarok: [ERROR!] Tried to perform query on uninitialized MySQL amarok: [ERROR!] Tried to perform query on uninitialized MySQL felipe@felipe-desktop:~$ amarok: BEGIN: void ScanManager::startIncrementalScan(const QString&) amarok: BEGIN: void ScanManager::checkTables(bool) amarok: END__: void ScanManager::checkTables(bool) - Took 0.00011s amarok: BEGIN: QStringList ScanManager::getDirsToScan() amarok: [ERROR!] Tried to perform query on uninitialized MySQL amarok: END__: QStringList ScanManager::getDirsToScan() - Took 0.00016s amarok: GOING TO SCAN: amarok: BEGIN: void ScanManager::writeBatchIncrementalInfoFile() amarok: END__: void ScanManager::writeBatchIncrementalInfoFile() - Took 0.00026s amarok: Scanning nothing, return. amarok: END__: void ScanManager::startIncrementalScan(const QString&) - Took 0.00094s Please stop pasting junk. Created attachment 41695 [details]
Full output from running amarok --debug
Here is all of the debugging output since I don't know what exactly you need. line 1180 is where it starts output from when I pressed "Fully Rescan Entire Collection."
Thanks for helping us with this bug!
Oh and Jeff, That command in (In reply to comment #16) > Can you try opening up a terminal, running "kbuildsycoca4 --noincremental" and > seeing if that helps? I tried this command and no luck. I'll be watching this bug if you think of anything else I could try. Thanks again for trying to help fix this! Sure -- but at the moment I have no ideas for you... Created attachment 41697 [details]
Output of amarok --debug
$ strace -o /tmp/amarok.strace.out amarok --debug &> /tmp/amarok.debug.out
Then went to Settings, Scan Entire Collection.
Created attachment 41698 [details]
strace output
strace -o /tmp/amarok.strace.out amarok --debug &> /tmp/amarok.debug.out
Then Settings, Scan Entire Collection.
Hi, It seems like I'm having the same issue as Joe. I installed amarok 2.3.0 out of ppa on ubuntu 9.10. The attachments above are the respective outputs from strace + amarok --debug. I can't seem to find the collection database anywhere. I created a dummy sqlite db (using directions found here http://amarok.kde.org/wiki/MySQL_HowTo#SQLite_-.3E_MySQL) and still no joy. I was hoping the strace would yield the right path, but I couldnt find it by back searching for fd3. Is it possible the db file just isn't being created. What would be the path? I've been looking in ~/.kde/share/apps/amarok/* with no luck. Thanks in advance and thank you for looking in to this. You do realize that Amarok 2 doesn't use sqlite, right? I don't know what you're doing with sqlite or what's on that wiki page, but it's certainly not going to result in a collection. If you're using the embedded database it'll be at ~/.kde/share/apps/amarok/mysqle What I'd really like at this point is to see if this is limited to Ubuntu users or not. I suspect a bad package. What PPA are you guys all getting this from? Is there anyone here that is running Kubuntu with KDE, as opposed to Ubuntu with GNOME? Note that I am asking what distribution you're running, not where you got this specific Amarok package from (which is what I asked above, and which I'd also like to know...) IOW, I want to not only find out where everyone is getting their package but also if this is somehow limited strictly to Ubuntu/GNOME users. (In reply to comment #26) > You do realize that Amarok 2 doesn't use sqlite, right? I don't know what > you're doing with sqlite or what's on that wiki page, but it's certainly not > going to result in a collection. Clearly not or I wouldn't have asked. Apologies. > > If you're using the embedded database it'll be at > ~/.kde/share/apps/amarok/mysqle Since mysqld isn't installed on my box, and the database settings does not have an external mysql server specified (or checked off as it were), yes, it's configured for the embedded database. > What I'd really like at this point is to see if this is limited to Ubuntu users > or not. I suspect a bad package. What PPA are you guys all getting this from? $ dpkg -l | grep amarok ii amarok 2:2.3.0-0ubuntu1~karmic1~ppa1 easy to use media player based on the KDE 4 ii amarok-common 2:2.3.0-0ubuntu1~karmic1~ppa1 architecture independent files for Amarok ii amarok-utils 2:2.3.0-0ubuntu1~karmic1~ppa1 utilities for Amarok media player $ dpkg -s amarok Package: amarok Status: install ok installed Priority: optional Section: sound Installed-Size: 21984 Maintainer: Kubuntu Developers <kubuntu-devel@ubuntu.com> Architecture: i386 Version: 2:2.3.0-0ubuntu1~karmic1~ppa1 Replaces: amarok-kde4 Depends: amarok-common (= 2:2.3.0-0ubuntu1~karmic1~ppa1), amarok-utils (= 2:2.3.0-0ubuntu1~karmic1~ppa1), phonon-backend-xine | phonon-backend, kdebase-runtime (>= 4:4.3.95), kdelibs5 (>= 4:4.4.1), libc6 (>= 2.8), libcurl3-gnutls (>= 7.16.2-1), libgcc1 (>= 1:4.1.1), libgcrypt11 (>= 1.4.2), libglib2.0-0 (>= 2.14.0), libgpod4 (>= 0.7.0), libgtk2.0-0 (>= 2.8.0), liblastfm0, libloudmouth1-0 (>= 1.1.4-2), libmtp8 (>= 0.3.1), libmysqlclient16 (>= 5.1.21-1), libphonon4 (>= 4:4.3.0), libplasma3, libqca2, libqt4-dbus (>= 4:4.5.3), libqt4-network (>= 4:4.5.3), libqt4-script (>= 4:4.5.3), libqt4-sql (>= 4:4.5.3), libqt4-svg (>= 4:4.5.3), libqt4-webkit (>= 4:4.5.3), libqt4-xml (>= 4:4.5.3), libqtcore4 (>= 4:4.6.2-0ubuntu1~karmic1~ppa2), libqtgui4 (>= 4:4.6.2-0ubuntu1~karmic1~ppa2), libstdc++6 (>= 4.4.0), libstreamanalyzer0 (>= 0.7.0), libstreams0 (>= 0.7.0), libtag-extras1 (>= 1.0.1), libtag1c2a (>= 1.6-2~), libxml2 (>= 2.7.4), phonon (>= 4:4.5.2), zlib1g (>= 1:1.1.4), libqtscript4-core, libqtscript4-gui, libqtscript4-network, libqtscript4-xml, libqtscript4-sql, libqtscript4-uitools Recommends: kdemultimedia-kio-plugins (>= 4:4.2.0), libqt4-sql-sqlite Suggests: libxine1-ffmpeg, libqt4-sql-mysql, libqt4-sql-psql Conflicts: amarok-engine-xine (<< 2), amarok-engine-yauap (<< 2), amarok-kde4 Description: easy to use media player based on the KDE 4 technology platform Amarok is a powerful music player with an intuitive interface. It makes playing the music you love and discovering new music easier than ever before and it looks good doing it! Amarok is based on the powerful Qt4 / KDE4 technology platform and nicely integrates with KDE desktop. . Much work has been invested into integrating Amarok 2 with various Web services: - Ampache - Jamendo Service - Last.fm - Librivox - MP3tunes - Magnatune - OPML Podcast Directory . Amarok comes with a lot of features including but not limited to: - Scripts - enhance your Amarok experience with community developed scripts. - Dynamic Playlists - create playlists that automatically update. - Context View - customize interface with the Plasma powered Context View. - PopUp Dropper - simplify drag&drop actions with revolutionary menu system. - Multiple Language Translations - Collection Management - organizing your music collection has never been easier with Amarok's powerful tagging, renaming, and sorting abilities. - Database Importing - import collections from Amarok 1.4 or iTunes. - Scriptable Services - integrate other web services into Amarok. Homepage: http://amarok.kde.org Original-Maintainer: Modestas Vainius <modax@debian.org> $grep ppa /etc/apt/sources* deb http://ppa.launchpad.net/kubuntu-ppa/ppa/ubuntu karmic main deb http://ppa.launchpad.net/kubuntu-ppa/backports/ubuntu karmic main Does that help? Please let me know if you need anything else. FYI-~/.kde/share/apps/amarok/mysqle is empty. Is there a way to manually bootstrap the db? Thanks a ton and thank you for your patience. I look into /home/.../.kde/share/apps/amarok/mysqle, and are two folders, amarok and mysql, seem to be ok. Because there is a lot of files inside mysql/amarok; but maybe could be the mysql configuration file, y look insde my.cnf at /home/.../.kde/share/apps/amarok/ and the file is empty. I look into /home/.../.kde/share/apps/amarok/mysqle, and are two folders, amarok and mysql, seem to be ok. Because there is a lot of files inside mysql/amarok; but maybe could be the mysql configuration file, y look insde my.cnf at /home/.../.kde/share/apps/amarok/ and the file is empty. I installed amaraok by the same PPA I can confirm that the collection works on Amarok 2.3 on Ubuntu 9.10 if you use an external database. (In reply to comment #31) > I can confirm that the collection works on Amarok 2.3 on Ubuntu 9.10 if you use > an external database. Does it not work for you if you switch to the embedded database? (In reply to comment #28) > FYI-~/.kde/share/apps/amarok/mysqle is empty. Is there a way to manually > bootstrap the db? No, there isn't. Do make sure that the user running Amarok has permissions in all of those directories, though. Martin's comment matches my suspicion that this is some issue with the Kubuntu package and embedded mysql -- I'd be interested in knowing both if he also has problems with embedded mysql, and if you all have problems with external mysql. (In reply to comment #33) > No, there isn't. Do make sure that the user running Amarok has permissions in > all of those directories, though. permissions are ok > I'd be interested in knowing [...] if you all have problems with external mysql. external MySQL works *fine* for me. If I remove the mysql server and switch back to embedded mysql, the database becomes empty again. (In reply to comment #26) > What I'd really like at this point is to see if this is limited to Ubuntu users > or not. I suspect a bad package. What PPA are you guys all getting this from? http://ppa.launchpad.net/kubuntu-ppa/backports/ubuntu/ I confirmed with Jonathan Riddell of Kubuntu that this is a known problem in the *buntu package. He's updated the news page with that information ( http://www.kubuntu.org/news/amarok-2.3.0 ). Marking as DOWNSTREAM for now. Jeff, thank you so much for taking the time to look in to this and for poking downstream to get to the bottom of it. I know we all appreciate it. No problem. Feel free to comment back about progress downstream. I'd encourage someone to see if there is already an open bug about this (probably) and perhaps link to it from here. (In reply to comment #38) > I'd encourage someone to see if there is already an open bug about this > (probably) and perhaps link to it from here. There is none I can see so far, I had an eye on that from the start. (In reply to comment #39) > (In reply to comment #38) > > > I'd encourage someone to see if there is already an open bug about this > > (probably) and perhaps link to it from here. > > There is none I can see so far, I had an eye on that from the start. Hm. OK. I'd encourage someone to open such a bug on Launchpad and then link to it from here :-) Can anyone see if installing the below packages fixes things? libhtml-template-perl (2.9-1) mysql-server (5.1.41-3ubuntu6) mysql-server-5.1 (5.1.41-3ubuntu6) mysql-server-core-5.1 (5.1.41-3ubuntu6) (No, I don't know where/how to get them :-) I just know that they are newer versions than the 5.1.37 some of you have.) This solved things for some people with a different but somewhat related problem. The magic incantation to install the above is $ sudo apt-get install mysql-server libhtml-template-perl mysql-server-5.1 mysql-server-core-5.1 And it worked like a charm. It seems installing mysql-server-5.1 starts up mysqld by default, but it doesn't look like it needs to be running for amarok to add a collection. I'm removing it from my rc scripts. Amarok seems pretty happy now. Thanks a bunch Jeff! F I fixed; i deleted the folder amarok in /home/.../.kde/share/apps/amarok and when I start again Amarok make a new folder and rescan my collection, and nows works. (In reply to comment #42) > The magic incantation to install the above is > > $ sudo apt-get install mysql-server libhtml-template-perl mysql-server-5.1 > mysql-server-core-5.1 > > And it worked like a charm. It seems installing mysql-server-5.1 starts up > mysqld by default, but it doesn't look like it needs to be running for amarok > to add a collection. I'm removing it from my rc scripts. Amarok seems pretty > happy now. I confirm things are working quite well now. *** Bug 231239 has been marked as a duplicate of this bug. *** I've added the missing dependency on mysql, my appologies for the problem. Version 2.3.0-0ubuntu1~karmic1~ppa2 should be appearing in the PPA soon (In reply to comment #47) > I've added the missing dependency on mysql, my appologies for the problem. > Version 2.3.0-0ubuntu1~karmic1~ppa2 should be appearing in the PPA soon Thanks for looking in to it Jonathan! We all really appreciate your efforts! *** Bug 231441 has been marked as a duplicate of this bug. *** |