This forum has been archived. All content is frozen. Please use KDE Discuss instead.

Collection empty at Amarok 2

Tags: None
(comma "," separated)
juanignaciosl
Registered Member
Posts
5
Karma
0

Collection empty at Amarok 2

Sun Oct 19, 2008 6:58 pm
I have just upgraded to Amarok 2 (1.92.2) and my collection is empty. I choose the directories and Amarok will begin scanning them. The log (.kde4/share/apps/amarok/collection_scan.log) shows it goes through the entire collection. It stops at the last (alphabetically) file, so everything seems fine. Nevertheless, "local collection" is empty

I'm using Kubuntu and KDE 4.1.2. Linux 2.6.24-21-generic #1 SMP Mon Aug 25 17:32:09 UTC 2008 i686 GNU/Linux .

:redface:
spectral
Registered Member
Posts
6
Karma
0

Re: Collection empty at Amarok 2

Sun Nov 23, 2008 12:38 pm
I have the same problem: scanning goes well and the logfile contains everything that should be there.
However the local collection is empty (and ~/.kde4/share/apps/amarok/mysqle/ is empty).
I compiled from svn just a couple of minutes ago, and everything went fine.
This is on OpenSuse 11.0
User avatar
markey
KDE Developer
Posts
2286
Karma
3
OS

Re: Collection empty at Amarok 2

Sun Nov 23, 2008 1:13 pm
Ok let's first get this out out of way:

Collection scanning has received heavy attention lately in SVN. There were many changes and fixes, so that experience from older versions becomes irrelevant.

Regarding @spectral, since he's a SVN user I'm interested in the case. Could you please start amarok with the -d argument (for debug) and post a full debug log here?


--
Mark Kretschmann - Amarok Developer
spectral
Registered Member
Posts
6
Karma
0

Re: Collection empty at Amarok 2

Sun Nov 23, 2008 2:55 pm
my log looks something like this:
amarok:    Selected collection folders:  ("/windows/D/Mp3/test")                                                                                                                   
amarok: BEGIN: QStringList MountPointManager::collectionFolders()                                                                                                                 
amarok: END__: QStringList MountPointManager::collectionFolders() - Took 0.00031s                                                                                                 
amarok:    MountPointManager collection folders:  ("/windows/D/Mp3/test")                                                                                                         
amarok: BEGIN: void ScanManager::startFullScan()                                                                                                                                   
amarok:      [ERROR!] Tried to perform query on uninitialized MySQLe                                                                                                               

amarok: BEGIN: QStringList MountPointManager::collectionFolders()                                                                                                                 
amarok: END__: QStringList MountPointManager::collectionFolders() - Took 0.00047s                                                                                                 
amarok: BEGIN: XmlParseJob::XmlParseJob(ScanManager*, SqlCollection*)                                                                                                             
amarok: BEGIN: void ProgressBarNG::setDescription(const QString&)                                                                                                                 
amarok: END__: void ProgressBarNG::setDescription(const QString&) - Took 0.0063s                                                                                                   
amarok: BEGIN: void CompoundProgressBar::addProgressBar(ProgressBarNG*, QObject*)                                                                                                 
amarok:          setting fixed height:  27  *  1  =  31                                                                                                                           
amarok:          p before:  QPoint(2,-32)                                                                                                                                         
amarok:          p after:  QPoint(4,925)                                                                                                                                           
amarok:          we now have  1  progress ops running                                                                                                                             
amarok: BEGIN: void ProgressBarNG::setDescription(const QString&)                                                                                                                 
amarok: END__: void ProgressBarNG::setDescription(const QString&) - Took 0.00027s                                                                                                 
amarok: END__: void CompoundProgressBar::addProgressBar(ProgressBarNG*, QObject*) - Took 0.0025s                                                                                   
amarok: BEGIN: ProgressBarNG* ProgressBarNG::setAbortSlot(QObject*, const char*)                                                                                                   
amarok:          Setting abort slot for  "Scanning music"                                                                                                                         
amarok:          connecting to  1deleteLater()                                                                                                                                     
amarok: END__: ProgressBarNG* ProgressBarNG::setAbortSlot(QObject*, const char*) - Took 0.00077s                                                                                   
amarok: END__: XmlParseJob::XmlParseJob(ScanManager*, SqlCollection*) - Took 0.012s                                                                                               
amarok: BEGIN: virtual void XmlParseJob::run()                                                                                                                                     
amarok: BEGIN: ScanResultProcessor::ScanResultProcessor(SqlCollection*)                                                                                                           
amarok: END__: ScanResultProcessor::ScanResultProcessor(SqlCollection*) - Took 6.9e-05s                                                                                           
amarok: END__: void ScanManager::startFullScan() - Took 0.037s                                                                                                                     
amarok: END__: void CollectionSetup::writeConfig() - Took 0.043s                                                                                                                   
amarok: BEGIN: virtual bool Amarok2ConfigDialog::hasChanged()                                                                                                                     
amarok: BEGIN: virtual bool CollectionConfig::hasChanged()                                                                                                                         
amarok: BEGIN: bool CollectionSetup::hasChanged() const                                                                                                                           
amarok: BEGIN: QStringList MountPointManager::collectionFolders()                                                                                                                 
amarok: END__: QStringList MountPointManager::collectionFolders() - Took 0.00028s                                                                                                 
amarok: END__: bool CollectionSetup::hasChanged() const - Took 0.00076s                                                                                                           
amarok: END__: virtual bool CollectionConfig::hasChanged() - Took 0.0011s                                                                                                         
amarok: BEGIN: virtual bool ServiceConfig::hasChanged()                                                                                                                           
amarok: END__: virtual bool ServiceConfig::hasChanged() - Took 0.003s                                                                                                             
amarok: END__: virtual bool Amarok2ConfigDialog::hasChanged() - Took 0.0049s                                                                                                       
amarok: BEGIN: void DatabaseUpdater::createTemporaryTables()                                                                                                                       
amarok:      Initialized thread, count== 5                                                                                                                                         
amarok:      [ERROR!] Tried to perform query on uninitialized MySQLe                                                                                                               

amarok: END__: void DatabaseUpdater::createTemporaryTables() - Took 0.001s                                                                                                         
amarok:    [ERROR!] Tried to perform query on uninitialized MySQLe                                                                                                                 

TagLib: MPEG::Header::parse() -- Invalid sample rate.                                                                                                                             
TagLib: MPEG::Header::parse() -- Invalid sample rate.                                                                                                                             
TagLib: MPEG::Header::parse() -- Invalid sample rate.                                                                                                                             
TagLib: MPEG::Header::parse() -- Invalid sample rate.                                                                                                                             
amarok:    [ERROR!] Tried to perform query on uninitialized MySQLe                                                                                                                 
amarok:    [ERROR!] Tried to perform insert on uninitialized MySQLe                                                                                                               
amarok: BEGIN: void ScanManager::slotFinished()                                                                                                                                   
amarok: END__: void ScanManager::slotFinished() - Took 0.00021s                                                                                                                   
amarok:    [ERROR!] Tried to perform query on uninitialized MySQLe                                                                                                                 

amarok: BEGIN: void DatabaseUpdater::copyToPermanentTables()
amarok:      [ERROR!] Tried to perform query on uninitialized MySQLe

amarok: END__: void DatabaseUpdater::copyToPermanentTables() - Took 0.00083s
amarok: BEGIN: void DatabaseUpdater::removeTemporaryTables()
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
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
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
amarok: END__: void DatabaseUpdater::removeTemporaryTables() - Took 0.0003s
amarok:    Sending changed signal
amarok: BEGIN: virtual ScanResultProcessor::~ScanResultProcessor()
amarok: END__: virtual ScanResultProcessor::~ScanResultProcessor() - Took 5.2e-05s
amarok: END__: virtual void XmlParseJob::run() - Took 0.77s
amarok: BEGIN: void SqlCollection::updateTrackUrls(TrackUrls)
amarok: END__: void SqlCollection::updateTrackUrls(TrackUrls) - Took 0.00019s
amarok: BEGIN: virtual XmlParseJob::~XmlParseJob()
amarok: BEGIN: void CompoundProgressBar::childBarComplete(ProgressBarNG*)
amarok:      p before:  QPoint(2,-9)
amarok:      p after:  QPoint(4,948)
amarok: BEGIN: void ProgressBarNG::setDescription(const QString&)
amarok: END__: void ProgressBarNG::setDescription(const QString&) - Took 9.5e-05s
amarok: BEGIN: void StatusBar::hideProgress()
amarok: END__: void StatusBar::hideProgress() - Took 0.001s
amarok: END__: void CompoundProgressBar::childBarComplete(ProgressBarNG*) - Took 0.0017s
amarok: END__: virtual XmlParseJob::~XmlParseJob() - Took 0.0035s


as it seems there is no database created (also indicated by the empty mysqle dir), but why this is.. no idea. any ideas?

and in case you wanted, here is the whole output when amarok starts: http://pastebin.com/m82f1024

Last edited by spectral on Sun Nov 23, 2008 3:02 pm, edited 1 time in total.
User avatar
markey
KDE Developer
Posts
2286
Karma
3
OS

Re: Collection empty at Amarok 2

Mon Nov 24, 2008 7:27 am
This is your problem:

"amarok:      [ERROR!] Tried to perform query on uninitialized MySQLe"

It's not the scanning itself, but your MySQL Embedded. Read up here:

http://amarok.kde.org/wiki/Development/MySQL_Embedded


--
Mark Kretschmann - Amarok Developer
spectral
Registered Member
Posts
6
Karma
0

Re: Collection empty at Amarok 2

Mon Nov 24, 2008 9:36 am
Yes that's what i thought, but it's weird that it does indeed compile and everything. On the wiki page it says to install libmysqlclient-devel for OpenSuse 11, but the only version I can find in the repos is 5.0.51 (and someone provided a 5.1.29 package via buildservice, but that doesn't work according to the wiki). I will try again to build against the suse rpm, if that doesn't work i suppose I will have to compile it from source..

EDIT:
After removing the silly 5.1.29 package I had apparently installed everything now works. Thanks.

Last edited by spectral on Mon Nov 24, 2008 9:48 am, edited 1 time in total.
weadley2004
Registered Member
Posts
9
Karma
0

Re: Collection empty at Amarok 2

Tue Jan 13, 2009 2:36 pm
I am experiencing the same problem described here. Amarok scans my directories but does not add anything to the collection.  It can load and play the files.  The log has the same error described here ([ERROR!] Tried to perform query on uninitialized MySQLe).  I am running on OpenSuse 11.1. I am running Amarok 2.0-1.1.  I have MySQL-shared, -embedded, -client and -devel installed, versions 5.1.30.  I also have libmysqlclient15, libmysqlclient_r15, libmysqlclient-devel and libqt4-sql-mysql each of which is at 5.0.67.  Any suggestions or pointers?
User avatar
markey
KDE Developer
Posts
2286
Karma
3
OS

Re: Collection empty at Amarok 2

Tue Jan 13, 2009 3:32 pm
weadley2004 wrote:I am experiencing the same problem described here. Amarok scans my directories but does not add anything to the collection.  It can load and play the files.  The log has the same error described here ([ERROR!] Tried to perform query on uninitialized MySQLe).  I am running on OpenSuse 11.1. I am running Amarok 2.0-1.1.  I have MySQL-shared, -embedded, -client and -devel installed, versions 5.1.30.  I also have libmysqlclient15, libmysqlclient_r15, libmysqlclient-devel and libqt4-sql-mysql each of which is at 5.0.67.  Any suggestions or pointers?


Please ask directly on the SUSE forums for this, as it is very likely a packaging mistake on their side.

They will likely be able to help you better than we could :)


--
Mark Kretschmann - Amarok Developer
naringas
Registered Member
Posts
7
Karma
0

Re: Collection empty at Amarok 2

Thu Apr 09, 2009 1:32 am
I have the same problem. Amarok scans my collection, but it never fills the database.
amarok -d revealed:
Code: Select all
amarok:      [ERROR!] GREPME MySQLe query failed! No database selected  on  "DELETE FROM tracks;"              
amarok:      [ERROR!] GREPME MySQLe query failed! No database selected  on  "DELETE FROM genres;"              
amarok:      [ERROR!] GREPME MySQLe query failed! No database selected  on  "DELETE FROM years;"               
amarok:      [ERROR!] GREPME MySQLe query failed! No database selected  on  "DELETE FROM composers;"           
amarok:      [ERROR!] GREPME MySQLe query failed! No database selected  on  "DELETE FROM albums;"              
amarok:      [ERROR!] GREPME MySQLe query failed! No database selected  on  "DELETE FROM artists;"             
amarok: END__: void ScanManager::cleanTables() - Took 0.0003s                                                  
amarok: BEGIN: QStringList MountPointManager::collectionFolders()                                              
amarok: END__: QStringList MountPointManager::collectionFolders() - Took 0.00014s                              
amarok: BEGIN: XmlParseJob::XmlParseJob(ScanManager*, SqlCollection*)                                          
amarok: BEGIN: void ProgressBarNG::setDescription(const QString&)                                              
amarok: END__: void ProgressBarNG::setDescription(const QString&) - Took 6.4e-05s                              
amarok: BEGIN: void CompoundProgressBar::addProgressBar(ProgressBarNG*, QObject*)                              
amarok:        setting fixed height:  25  *  1  =  29                                                          
amarok:        p before:  QPoint(2,-49)                                                                        
amarok:        p after:  QPoint(4,926)                                                                         
amarok:        we now have  1  progress ops running                                                            
amarok: BEGIN: void ProgressBarNG::setDescription(const QString&)                                              
amarok: END__: void ProgressBarNG::setDescription(const QString&) - Took 5.2e-05s                              
amarok: END__: void CompoundProgressBar::addProgressBar(ProgressBarNG*, QObject*) - Took 0.00059s              
amarok: BEGIN: ProgressBarNG* ProgressBarNG::setAbortSlot(QObject*, const char*)                               
amarok:        Setting abort slot for  "Scanning music"                                                        
amarok:        connecting to  1deleteLater()                                                                   
amarok: END__: ProgressBarNG* ProgressBarNG::setAbortSlot(QObject*, const char*) - Took 0.00011s               
amarok: END__: XmlParseJob::XmlParseJob(ScanManager*, SqlCollection*) - Took 0.0022s                           
amarok: END__: void ScanManager::startFullScan() - Took 0.009s                                                 
amarok: BEGIN: virtual void XmlParseJob::run()                                                                 
amarok: BEGIN: ScanResultProcessor::ScanResultProcessor(SqlCollection*)                                        
amarok: END__: ScanResultProcessor::ScanResultProcessor(SqlCollection*) - Took 3.3e-05s                        
amarok: BEGIN: void DatabaseUpdater::createTemporaryTables()                                                   
amarok:      [ERROR!] GREPME MySQLe query failed! No database selected  on  "CREATE TEMPORARY TABLE urls_temp (id INTEGER PRIMARY KEY AUTO_INCREMENT,deviceid INTEGER,rpath VARCHAR(1024),directory INTEGER,uniqueid VARCHAR(128) UNIQUE);"                                                                                                    
amarok:      [ERROR!] GREPME MySQLe query failed! No database selected  on  "CREATE UNIQUE INDEX urls_id_rpath_temp ON urls_temp(deviceid, rpath);


so the problem is
amarok:      [ERROR!] GREPME MySQLe query failed! No database selected
I get one of those errors for every file in my library.

I'm running Gentoo on amd64. Amarok 2.0.2 and mysql 5.00.76
User avatar
markey
KDE Developer
Posts
2286
Karma
3
OS

Re: Collection empty at Amarok 2

Thu Apr 09, 2009 11:29 am
naringas wrote:I have the same problem. Amarok scans my collection, but it never fills the database.
amarok -d revealed:
amarok:      [ERROR!] GREPME MySQLe query failed! No database selected  on  "DELETE FROM tracks;"             


The same is true for you: Your Amarok is probably using an unsuitable version of MySQL, so please approach your distro (Gentoo) about this.

It's not quite easy to package MySQL correctly for Amarok 2, as we are using the relatively new Embedded version. Therefore these problems are still rather common, until the distros have sorted out all the little kinks.


--
Mark Kretschmann - Amarok Developer
naringas
Registered Member
Posts
7
Karma
0

Re: Collection empty at Amarok 2

Fri Apr 10, 2009 4:28 pm
well, the problem for me wasn't the unsuitable mysql ebuild (package). The problem with that was patched (http://blogs.gentoo.org/jmbsvicetto/200 ... -and-mysql) (https://bugs.gentoo.org/show_bug.cgi?id=238487)

The problem was solved recompiling amarok with the --as-needed LDFLAG
User avatar
tobik
Registered Member
Posts
72
Karma
0

Re: Collection empty at Amarok 2

Fri Apr 17, 2009 6:39 pm
naringas wrote:well, the problem for me wasn't the unsuitable mysql ebuild (package). The problem with that was patched (http://blogs.gentoo.org/jmbsvicetto/200 ... -and-mysql) (https://bugs.gentoo.org/show_bug.cgi?id=238487)

The problem was solved recompiling amarok with the --as-needed LDFLAG


Hi, I've also Gentoo amd64 and I'm also getting the error messages with "No database found". I tried to recompile with --as-needed LDFLAG but it didn't help and I'm not sure if I did it right. I just run: LDFLAGS="--as-needed" emerge amarok ...but it's not working for me.

It also seems to me, that the problem is in mysql-5.0.76. According to your post, you have been getting problems with amarok 2.0.2 and this version of mysql. But amarok 2.0.2 with some older version of mysql (it's probably last stable version .70) worked perfectly for me. But I wanted to upgrade to amarok 2.1 beta and this made me to upgrade mysql to newer version. And since that amarok doesn't work and shows errors with "No database found".


bad english teacher -> bad english -> sorry
naringas
Registered Member
Posts
7
Karma
0

Re: Collection empty at Amarok 2

Sat Apr 18, 2009 3:38 pm
uhhhhhmm, what I compiled with the --as-needed flag wasn't amarok but mysql.

the flags you want are LDFLAGS="-Wl,--as-needed"
User avatar
tobik
Registered Member
Posts
72
Karma
0

Re: Collection empty at Amarok 2

Sat Apr 18, 2009 4:58 pm
naringas wrote:uhhhhhmm, what I compiled with the --as-needed flag wasn't amarok but mysql.

the flags you want are LDFLAGS="-Wl,--as-needed"


Oh yes! Finally it's working again. It was few very bad days without my music :-D


bad english teacher -> bad english -> sorry
Tomte
Registered Member
Posts
2
Karma
0

Re: Collection empty at Amarok 2

Sat Apr 18, 2009 5:22 pm
I had the same problem today -- whatever --as-needed does, it helped also to rebuild amarok with the flag (not mysql) - I have a collection again :)


Bookmarks



Who is online

Registered users: Bing [Bot], Google [Bot], Sogou [Bot]