Bug 270715 - Amarok fails to show collection if $HOME/.my.cnf exists
Summary: Amarok fails to show collection if $HOME/.my.cnf exists
Status: RESOLVED WORKSFORME
Alias: None
Product: amarok
Classification: Applications
Component: Collections/Local (show other bugs)
Version: 2.5.0
Platform: Ubuntu Linux
: NOR normal
Target Milestone: 2.6
Assignee: Amarok Developers
URL:
Keywords:
: 276298 (view as bug list)
Depends on:
Blocks:
 
Reported: 2011-04-11 22:35 UTC by Gunter Ohrner
Modified: 2012-11-29 10:39 UTC (History)
3 users (show)

See Also:
Latest Commit:
Version Fixed In: 2.6


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Gunter Ohrner 2011-04-11 22:35:03 UTC
Version:           2.4.0 (using KDE 4.6.2) 
OS:                Linux

This is the same issue I reported as bug 223216 some time ago and which has been closed as fixed.
However, unfortunately the problem still appears, or there's a regression.

Amarok 2.4.0 will not show any titles in the local music collection, as long as a .my.cnf file is present in my $HOME.

Reproducible: Always

Steps to Reproduce:
Create a .my.cnf file in your $HOME directory and start Amarok.

Actual Results:  
Amarok displays "0" titles in the local collection.

Expected Results:  
Amarok displays all titles in my local collection which it knows about if the .my.cnf file is not present.
Comment 1 Gunter Ohrner 2011-04-11 22:51:03 UTC
BTW, Amarok also seems to lose its collection settings when this happens (or maybe this is an unrelated bug and I'm accidentally mixing them up?) and sets the collection root to my $HOME - which really is no bright idea, given the size of my $HOME directory...
Comment 2 Myriam Schweingruber 2011-04-12 09:09:18 UTC
Could you please test with Amarok 2.4.1 beta? There has been a lot of change in the code since 2.4.0
Comment 3 Gunter Ohrner 2011-04-12 22:44:38 UTC
I'd like to, but I'm currently not in a position to compile it from source.
Apparently (according to http://www.kubuntu-de.org/nachrichten/software/kde/amarok/amarok-testversion/2065-amarok-2-4-1-beta-1-ringscape-mit-kubuntu-pa) Kubuntu packages for Amarok 2.4.1 should exist, yet I was not able to find them. Natty does only have 2.4.0 (which is the package I'm using right now) and the PPA mentioned in this article does not seem to carry Natty packages...
Comment 4 Myriam Schweingruber 2011-04-14 11:20:31 UTC
See here: http://www.kubuntu.org/news/amarok-2.4.1-beta-1

you need to add the kubuntu beta PPA to your repositories as indicated in that news page, I can find it here without problems. The packeges are called amarok* 2:2.4.0.90-0ubuntu2
Comment 5 Gunter Ohrner 2011-04-14 22:28:43 UTC
Thanks for the PPA, I just updated Amarok.

   Amarok
   Version 2.4.0.90
   Unter KDE 4.6.2 (4.6.2)

It still fails, but now gives the following error message:

   The amarok database reported the following errors:
   GREPME MySQLe query failed! (0) Unknown database 'XXX' on na
   In most cases you will need to resolve these errors before Amarok will run
   properly.

(Where XXX is the name of a local database on my system.)

Unsurprisingly, if I dismiss the error dialog, I get the same behavior as before: The collection is emtpy.
Comment 6 Myriam Schweingruber 2011-04-17 17:10:49 UTC
Ralf, any ideas?
Comment 7 Myriam Schweingruber 2011-06-04 12:25:49 UTC
This is an automated message from the triager:

Amarok 2.4.1 has been released on May 8 already. Could you please upgrade and test if you can still reproduce this bug?

Without feedback within a month we will close this bug as resolved.

Thank you for your understanding.
Comment 8 Gunter Ohrner 2011-06-04 12:59:06 UTC
Yes, I can.
Comment 9 Myriam Schweingruber 2011-06-04 14:15:48 UTC
Thank you for the fast feedback.
Comment 10 Ivan D Vasin 2011-07-31 21:43:05 UTC
*** Bug 276298 has been marked as a duplicate of this bug. ***
Comment 11 Ivan D Vasin 2011-10-03 18:36:45 UTC
still present in 2.4.3.

here's a snippet of the output given by ``amarok --debug`` when this happens:

----
amarok:         BEGIN: void CollectionManager::init(const QList<Plugins::PluginFactory*>&) 
amarok:           BEGIN: void CollectionManager::loadPlugins(const QList<Collections::CollectionFactory*>&) 
amarok:             [CollectionManager] initializing "amarok_collection-mysqlecollection" 
amarok:             [ERROR__] Could not connect to mysql! 
amarok:             [ERROR__] [MySqlStorage] "GREPME MySQLe query failed! (0) Unknown database 'test' on na" 
amarok:             [MySqlStorage] Initialized thread, count== 1 
amarok:             BEGIN: bool DatabaseUpdater::update() 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               Database version:  0 
amarok:               BEGIN: void DatabaseUpdater::createTables() const 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:                 [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:               END__: void DatabaseUpdater::createTables() const [Took: 0.001s] 
amarok:               [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:             END__: bool DatabaseUpdater::update() [Took: 0.001s] 
amarok:             [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:             [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:             [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:             [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:             [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:             [ERROR__] [MySqlStorage] Tried to perform query on uninitialized MySQL 
amarok:             BEGIN: virtual int App::newInstance() 
amarok:               BEGIN: static void App::handleCliArgs() 
amarok:               END__: static void App::handleCliArgs() [Took: 0s] 
amarok:             END__: virtual int App::newInstance() [Took: 0s]
----

more ERRORs follow with messages like "Tried to perform {X} on uninitialized MySQL".
Comment 12 Myriam Schweingruber 2011-10-04 05:54:14 UTC
Confirmed by another user.
Comment 13 Gunter Ohrner 2012-01-22 01:30:38 UTC
Amarok 2.5.0 is still affected, same message dialog as with 2.4.x.
Comment 14 Myriam Schweingruber 2012-11-29 10:39:02 UTC
I can't reproduce this with Amarok 2.6, please upgrade.