Bug 193481 - Local collection hangs at " Counting"
Summary: Local collection hangs at " Counting"
Status: RESOLVED DOWNSTREAM
Alias: None
Product: amarok
Classification: Applications
Component: general (show other bugs)
Version: 2.0.96
Platform: unspecified Linux
: NOR normal
Target Milestone: ---
Assignee: Amarok Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-05-21 12:45 UTC by Frits Spieker
Modified: 2009-08-17 21:22 UTC (History)
6 users (show)

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Frits Spieker 2009-05-21 12:45:11 UTC
Version:           2.0.96 (using 4.2.86 (KDE 4.2.86 (KDE 4.3 >= 20090514)) "release 125", KDE:KDE4:Factory:Desktop / openSUSE_11.1)
Compiler:          gcc
OS:                Linux (x86_64) release 2.6.27.21-0.1-default

Amarok imports collection (can be seen in teh status message at the bottom), but the collection never shows. The message that Amarok shows in the collection window is the "Local Collection" icon with a "counting" message underneath. Let is run overnight, still no collection.

If files are dragged from the "Files" window to the playlist they play just fine.
Comment 1 Michal Gaspar 2009-05-21 18:55:59 UTC
I have same problem with identical versions of Amarok and KDE, but in 32-bit openSUSE 11.1.
Comment 2 nusch 2009-05-28 21:13:59 UTC
Same problem here, during the "Calculating" there is no higher CPU usage, hard disk LED also doesn't blink, but there is a problem with mysql when I run it with --debug flag:

amarok: BEGIN: ScanManager::ScanManager(SqlCollection*) 
amarok: END__: ScanManager::ScanManager(SqlCollection*) - Took 9.5e-05s 
amarok:              [ERROR!] MySQL library initialization failed.      
amarok:              [ERROR!] GREPME MySQLe query failed! mysql_embedded: unknown option '--loose-skip-innodb'  on  "init" 
amarok:             [PluginManager] Trying to load:  "libamarok_collection-daapcollection"                                 
amarok:             [PluginManager]

Using amarok 2.1-SVN, KDE 4.2.3
Comment 3 Mark Kretschmann 2009-05-28 21:39:57 UTC
This debug output strongly indicates a packaging problem:

Apparently the MySQL version on your system is unsuitable for Amarok. Please report this problem to SUSE directly. They might be able to fix the packaging in an update.
Comment 4 Frits Spieker 2009-05-30 17:11:16 UTC
It was not so much that the MySQL version is unsuitable, it was that Amarok during install does not check whether MySQL is installed at all (still a packaging issue). Manually installing MySQL solved the problem.
Comment 5 Mark Kretschmann 2009-05-30 17:22:22 UTC
Hum, that's a bit frustrating to hear, as SUSE has had this missing dependency problem for ages... I had thought they'd fixed it by now :(
Comment 6 nusch 2009-05-30 19:05:53 UTC
In my case I compiled Amarok with mysql from svn and probably later ubuntu updater overwrited mysql. But I believe it's still Amarok problem also, before "Counting" it should display "Connecting to db..." or after error "DB Error" or "MySQL error".
Comment 7 Pedro de Carvalho Gomes 2009-06-05 22:14:30 UTC
Hi all,

I am facing the same problem with Amarok 2.1. I can't really tell if this is an OpenSuse or an Amarok issue, but I don't get why this bug is marked as "RESOLVED".

Anyway, if I run Amarok with --debug, I get many MYSQLe erros, such as this one:

amarok: BEGIN: void DatabaseUpdater::createTemporaryTables()
amarok:                                                                                                                                                                                                                                                                                                                                                                                                                                                        [ERROR!] Tried to perform query on uninitialized MySQLe
amarok:                                                                                                                                                                                                                                                                                                                                                                                                                                                        [ERROR!] Tried to perform query on uninitialized MySQLe
amarok:                                                                                                                                                                                                                                                                                                                                                                                                                                                        [ERROR!] Tried to perform query on uninitialized MySQLe
Tried to perform query on uninitialized MySQLe
amarok:                                                                                                                                                                                                                                                                                                                                                                                                                                                        [ERROR!] Tried to perform escape() on uninitialized MySQLe
amarok:                                                                                                                                                                                                                                                                                                                                                                                                                                                        [ERROR!] Tried to perform insert on uninitialized MySQLe
amarok:                                                                                                                                                                                                                                                                                                                                                                                                                                                        [ERROR!] Tried to perform escape() on uninitialized MySQLe
Comment 8 Pedro de Carvalho Gomes 2009-06-05 22:26:04 UTC
Sorry, I've just figured out that I was missing the "mysql" package. I've just retrived the mysql-5.0.67-12.15 package from OpenSuse and now Amarok is OK
Comment 9 Aaron Digulla 2009-06-21 22:33:10 UTC
I ran into the same issue two days ago. Amarok should really show an error message when mysql is not available. If it doesn't, most of the UI will simply "not work" which is extremely annoying.
Comment 10 Myriam Schweingruber 2009-06-22 19:50:40 UTC
(In reply to comment #9)
> I ran into the same issue two days ago. Amarok should really show an error
> message when mysql is not available. If it doesn't, most of the UI will simply
> "not work" which is extremely annoying.

Aaron, please check with your distribution, Amarok needs an embedded mysqle, the dependencies are clearly documented and if the distribution does not package this correctly, we can do nothing about it.
Comment 11 Aaron Digulla 2009-06-22 21:27:50 UTC
You can show an error instead of starting a half-lived version. But I'm also reporting an error ... at least I'll try but the package comes from the openSUSE build service (i.e. an half-official source) and I have to report it by mail to someone I found in the changelog :(
Comment 12 wuselwu 2009-08-14 04:38:27 UTC
I have been experiencing the same problem for months (openSUSE factory)

Is it possible that openSUSE has been shipping an dysfunctional combination of Amarok / MySQL for such a long time?

Is the bug already reported in openSUSE?
Comment 13 wuselwu 2009-08-17 21:22:35 UTC
For all those openSUSE users who can't get rid of this bug despite installing all possible mySQL-Packages: I could only solve this problem by installing the package amarok-2.1.60git20090813-3.1 from some community repo. Suddenly everything seems to work.