Bug 450318 - Amarok2 no longer builds music collection
Summary: Amarok2 no longer builds music collection
Status: RESOLVED FIXED
: 462345 465160 (view as bug list)
Alias: None
Product: openSUSE 11.1
Classification: openSUSE
Component: KDE4 Applications (show other bugs)
Version: RC 1
Hardware: Other Other
: P2 - High : Major with 25 votes (vote)
Target Milestone: ---
Assignee: E-mail List
QA Contact: E-mail List
URL:
Whiteboard: maint:released:11.1:22050
Keywords:
Depends on:
Blocks: 509815
  Show dependency treegraph
 
Reported: 2008-11-30 16:13 UTC by Nkoli Ukpabi
Modified: 2009-06-29 09:48 UTC (History)
17 users (show)

See Also:
Found By: ---
Services Priority:
Business Priority:
Blocker: ---
Marketing QA Status: ---
IT Deployment: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Nkoli Ukpabi 2008-11-30 16:13:14 UTC
I've been using amarok2 for the past few months and never ran into this issue until I did a clean install of opensuse 11.1 RC1 yesterday. I removed my ~/.kde4 directory, so all configuration was from scratch.

When I first opened up amarok, the configuration dialog popped up. I went to Collection and added the folder containing all my music. After hitting Apply, the Scanning Music message came up, along with a progress indicator. The indicator reached 100% and disappeared, but no songs appeared in my collection. Rescanning the collection has the same effect and Update Collection does nothing. I can play the songs fine if I open them individually.

When the scan is running, I can see '/usr/bin/amarokcollectionscanner --nocrashhandler -p -r /home/nkoli/Desktop/downloads' under the list of running processes. Also, a lot of messages like the one below appear in the command line, which leads me to believe amarok is really scanning through the songs in the directory.

TagLib: MPEG::Header::parse() -- Invalid sample rate.                                                                                           
TagLib: ID3v2.4 no longer supports the frame type TSIZ.  It will be discarded from the tag.
Comment 1 Alex Breidenbroich 2008-12-01 16:59:49 UTC
Having the same problem here, also with fresh install of RC1, but for me the progressbar disappears at 85%...

This also happens, if i select only one Directory in my Collection...

The only thing that changes in /home/xyz/.kde4/share/apps/amarok is the file collection_scan.files, it lists all scanned files, but in Directory mysqle (I assume that's for the db), there's nothing...
Comment 2 Martin Schlander 2008-12-01 18:52:48 UTC
Same here. Can't build magnatune.com collection either. And can't even add songs to playlist. Somehow it's completely b0rked.

.kde4/share/apps/amarok/mysqle remains empty - even though collection_scan.files shows it's found the files.

The database support is complete gone I guess for whatever reason.. maybe a missing package? 

I did:
cb400f@dhcppc0:~> rpm -qa *sql*
sqlite2-2.8.17-133.38
libmysqlclient_r15-5.0.67-12.12
libsqlite3-0-3.6.4-1.7
libmysqlclient15-5.0.67-12.12
libqt4-sql-4.4.3-4.3
libqt4-sql-mysql-4.4.3-4.3
sqlite3-3.6.4-1.7
cb400f@dhcppc0:~>

Even if Amarok1 is switched back to default in final, it's very bad to ship amarok2 in this horribly broken shape as a non-default part of the distro.
Comment 3 Graham Anderson 2008-12-02 11:14:26 UTC
Another confirmation here, I have been using Amarok2 from build service repos prior to installing RC1. Using an existing home profile with an already built collection, my collection is unavailable and rebuilding it doesnt solve anything.
Comment 4 Johan Persson 2008-12-02 21:15:48 UTC
I can also confirm this bug. Since Amarok2 is the default player for SuSE distribution I vote for that this defect should be classified as major (or possible even critical) since it basically renders Amarok2 useless in 11.1 RC1

(Unfortunately my QT4 skills is not good enough to help fix this annoying defect myself)
Comment 5 Klaas van Gend 2008-12-03 01:48:08 UTC
Same here - fresh install of 11.1RC1 on a new machine.
Comment 6 Quentin Jackson 2008-12-03 07:15:52 UTC
Put me in for a "Me too" :)  Kinda hard to play music when there isn't any.....
Comment 7 Jannick Kuhr 2008-12-06 16:19:44 UTC
Installing mysql and mysql-client fixed this issue for me.

Missing dependency?
Comment 8 Klaas van Gend 2008-12-09 00:23:00 UTC
I can confirm that installing mysql (and its dependency mysql-client) solves this issue. 

Moving severity to major because this seriously affects how AmaroK2 operates for people who do not automatically install the database.

Fixing the SPEC file to include the dependencies should do, however I'm not certain that the KDE developers are willing to do this - it's rather late in the development life cycle.
Comment 9 Quentin Jackson 2008-12-09 00:37:45 UTC
Yep, fixed it for me!

Q
Comment 10 Stephan Binner 2008-12-15 20:29:59 UTC
Installing mysql is just a work-around, not the correct fix.
Comment 11 Stephan Binner 2008-12-19 05:33:27 UTC
Can you please try the following? Deinstall the mysql and mysql-client packages if you installed it and update Amarok2 with the kde4-amarok package from http://download.opensuse.org/repositories/KDE:/KDE4:/STABLE:/Desktop/openSUSE_11.1/ repository (no need to update any other rpm too). Does this fix it?

The relevant changelog entry is:

* Mon Dec 15 2008 dmueller@suse.de
- add missing requirement on qt4-sql-sqlite
- use mysql embedded instead of mysql server
Comment 12 Martin Schlander 2008-12-19 12:37:28 UTC
Doesn't work for me.

I installed the new package kde4-amarok package, it installs qt4-sql-sqlite as a dependency. But the collection will still not build.

I tried removing .kde4/share/[apps|config]/amarok*. But that didn't help any.

This is on a fresh 11.1 installation btw. It never had mysql and mysql-client installed.

Comment 13 Forgotten User zOWss6Gs9u 2008-12-20 20:01:04 UTC
No, the update from KDE:KDE4:STABLE:Desktop doesn't fixs the problem.
Comment 14 reen mehl 2008-12-21 13:25:49 UTC
I have the same problem on a fresh 11.1 installation. Neither the kde4-amarok package form KDE:KDE4:STABLE:Desktop nor from KDE:KDE4:Factory:Desktop works for me. I also tried the workaround with mysql and mysql-client but without success.
Comment 15 Philipp Niehues 2008-12-21 13:29:40 UTC
I had the same problem:
Amarok2 was not able to build a music library. I installed mysql, started the service and restarted Amarok. Now it works.

Perhaps mysql should become a dependency of the kde4-amarok-package.
Comment 16 reen mehl 2008-12-21 13:38:04 UTC
I installed mysql for the second time and now it works for me too.
Comment 17 Stephan Binner 2008-12-24 12:37:51 UTC
*** Bug 462345 has been marked as a duplicate of this bug. ***
Comment 18 Stephan Binner 2008-12-30 22:27:51 UTC
Please try comment #11 again with the rpm with changelog entry

* Tue Dec 30 2008 stbinner@suse.de
- don't require errmsg.sys from mysql package (bnc#450318)
Comment 19 Forgotten User zOWss6Gs9u 2008-12-31 01:57:16 UTC
Works.

Every time I restart Amarok I get:
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!           
081231  2:54:33  InnoDB: Database was not shut down normally! 
InnoDB: Starting crash recovery.                              
InnoDB: Reading tablespace information from the .ibd files... 
InnoDB: Restoring possible half-written data pages from the doublewrite

But I suppose that's a different bug, and isn't causing visible problems.
Comment 20 Alex Minton 2008-12-31 13:17:28 UTC
Yes, updating from KDE4:STABLE solved this issue, thank you!
Comment 22 Klaas van Gend 2008-12-31 20:11:28 UTC
This is what I did:
* removed kde4-amarok and kde4-amarok-lang packages
* removed mysql and mysql-client packages
* removed everything that contained 'amarok' in the file name
  in the ~/.kde4 directory
* Added the KDE4 STABLE repository
* Installed kde4-amarok and kde4-amarok-lang from those repositories

Of course, it didn't remember any of my settings :-)

But after setting it all up again, Amarok does keep the list of all music i have on my system.

Sounds like you've solved the problem!
Thank you!

Comment 23 Stephan Binner 2009-01-03 11:15:50 UTC
Candidate for online update.
Comment 24 Stephan Binner 2009-01-07 12:36:33 UTC
Reopening for update.
Comment 25 Stephan Binner 2009-01-07 12:38:38 UTC
Please assign a Swamp ID for an update to 2.0.1 to fix this, bnc#463169, bnc#458677 and other problems.
Comment 28 David Montero Isusi 2009-01-10 09:35:09 UTC
doing as in comment #22 (except removing mysql) works! i removed everything in ~/.kde and ~/.kde4 and installed from that repo.
Comment 29 Stephan Binner 2009-01-11 09:33:31 UTC
*** Bug 465160 has been marked as a duplicate of this bug. ***
Comment 30 Stephan Binner 2009-01-11 09:35:53 UTC
Please help to test the kde4-amarok 2.0.1.1 package within the KDE:KDE4:STABLE:Desktop repository for regressions.
Comment 31 Raghu GS 2009-01-11 14:22:28 UTC
Even after removing Amarok folder from .kde4/share/apps and all amarok files from .kde4/share/config i got no collection plugins error upon first startup and asked to restart Amarok.

Then after that everything was flawless
Comment 32 Raghu GS 2009-01-16 05:17:33 UTC
@ Stephan Binner

Why is the bug still not closed?
Are you waiting for more feedback?
Comment 33 Stephan Binner 2009-01-16 09:52:07 UTC
No more feedback required, new package is in the online update queue.
Comment 34 Swamp Workflow Management 2009-01-20 15:07:50 UTC
Update released for: kde4-amarok, kde4-amarok-debuginfo, kde4-amarok-debugsource, kde4-amarok-lang
Products:
openSUSE 11.1 (debug, i586, ppc, x86_64)
Comment 35 Thomas Biege 2009-01-20 15:08:29 UTC
packages released
Comment 36 Aaron Digulla 2009-06-23 19:09:34 UTC
I have the same bug (or a pretty similar one) with amarok 2.1-13.1 (DSA/SHA1, Mi 03 Jun 2009 08:42:58 CEST, Key ID 58d8ff412e1efa87)

When I start amarok without mysql installed, I get lots of errors:

"Tried to perform query on uninitialized MySQLe"

The UI comes up but the playlist and the local collection are completely unusable. You can open a single song in "Files" and play it but that's it.

Another bug (https://bugs.kde.org/show_bug.cgi?id=193481#c10) clearly states that Amarok needs MySQLe (which seems to be an embedded version of MySQL).

So I saved my config and restarted amarok. Same error:

amarok: BEGIN: void CurrentTrack::dataUpdated(const QString&, const QHash<QString, QVariant>&)
amarok:                                                                                                                                                                                                                                                                                                                                                                                                  Initialized thread, count== 2
amarok:                                                                                                                                                                                                                                                                                                                                                                                                  [ERROR!] Tried to perform query on uninitialized MySQLe
amarok: BEGIN: void CurrentEngine::setupTracksData()
amarok: BEGIN: void CurrentTrack::dataUpdated(const QString&, const QHash<QString, QVariant>&)

After installing the "mysql" package, the error goes away, I can add files to my collection.

So for me, this means that amarok depends on the mysql package and you should really make that a hard dependency in the RPM.
Comment 37 Stephan Binner 2009-06-29 09:48:01 UTC
Re comment #36, the bug should be fixed in Amarok 2.1.1 packages (and later revisions of 2.1).