Amarok --debug showing the sql queries that fail

amarok_debug (text/plain), 24.59 KB, created by Thomas Pegeot on 2009-07-14 09:32:34 UTC

amarok --debug : 
Object::connect: No such signal BrowserCategoryList::leavingTree()
Object::connect:  (sender name:   'internet')                     
InnoDB: use atomic builtins.                                      
InnoDB: The first specified data file /home/thomas/.kde4/share/apps/amarok/mysqle/ibdata1 did not exist:
InnoDB: a new database to be created!                                                                   
090714 10:59:48  InnoDB: Setting file /home/thomas/.kde4/share/apps/amarok/mysqle/ibdata1 size to 10 MB 
InnoDB: Database physically writes the file full: wait...                                               
090714 10:59:48  InnoDB: Log file /home/thomas/.kde4/share/apps/amarok/mysqle/ib_logfile0 did not exist: new to be created
InnoDB: Setting log file /home/thomas/.kde4/share/apps/amarok/mysqle/ib_logfile0 size to 5 MB                             
InnoDB: Database physically writes the file full: wait...                                                                 
090714 10:59:49  InnoDB: Log file /home/thomas/.kde4/share/apps/amarok/mysqle/ib_logfile1 did not exist: new to be created
InnoDB: Setting log file /home/thomas/.kde4/share/apps/amarok/mysqle/ib_logfile1 size to 5 MB                             
InnoDB: Database physically writes the file full: wait...                                                                 
InnoDB: Doublewrite buffer not found: creating new                                                                        
InnoDB: Doublewrite buffer created                                                                                        
InnoDB: Creating foreign key constraint system tables                                                                     
InnoDB: Foreign key constraint system tables created                                                                      
Couldn't resolve property: linearGradient5167                                                                             
link XMLID_9_ hasn't been detected!                                                                                       
Couldn't resolve property: linearGradient3563                                                                             
link XMLID_9_ hasn't been detected!                                                                                       
link XMLID_9_ hasn't been detected!                                                                                       
link XMLID_9_ hasn't been detected!                                                                                       
Object::connect: No such signal BrowserCategoryList::leavingTree()                                                        
Object::connect:  (sender name:   'root list')                                                                            
Object::connect: No such slot BrowserWidget::categoryChanged()                                                            
Object::connect:  (sender name:   'root list')                                                                            
QLayout: Attempting to add QLayout "" to Playlist::SortWidget "", which already has a layout                              
Object::connect: No such signal BrowserWidget::widgetActivated( int )                                                     
Object::connect:  (receiver name: 'MainWindow')                                                                           
Object::connect: No such signal CollectionWidget::home()                                                                  
Object::connect:  (sender name:   'collections')                                                                          
Object::connect:  (receiver name: 'root list')                                                                            
Object::connect: No such signal ServiceBrowser::home()                                                                    
Object::connect:  (sender name:   'internet')                                                                             
Object::connect:  (receiver name: 'root list')                                                                            
Object::connect: No such signal BrowserCategoryList::leavingTree()                                                        
Object::connect:  (sender name:   'playlists')                                                                            
Object::connect: No such signal PlaylistBrowserNS::DynamicCategory::home()                                                
Object::connect:  (receiver name: 'playlists')                                                                            
Object::connect: No such signal PlaylistBrowserNS::PlaylistCategory::home()                                               
Object::connect:  (receiver name: 'playlists')                                                                            
Object::connect: No such signal PlaylistBrowserNS::PodcastCategory::home()                                                
Object::connect:  (receiver name: 'playlists')                                                                            
Object::connect: No such signal PlaylistBrowserNS::PlaylistBrowser::home()                                                
Object::connect:  (sender name:   'playlists')                                                                            
Object::connect:  (receiver name: 'root list')                                                                            
Object::connect: No such signal FileBrowser::Widget::home()                                                               
Object::connect:  (sender name:   'files')                                                                                
Object::connect:  (receiver name: 'root list')                                                                            
amarok:  ************************************************************************************************************     
amarok:  ** DEBUGGING OUTPUT IS NOW ENABLED. PLEASE NOTE THAT YOU WILL ONLY SEE THE FULL OUTPUT ON THE NEXT START. **     
amarok:  ************************************************************************************************************     
amarok: END__: static void App::handleCliArgs() - Took 0.00045s                                                           
amarok: END__: virtual int App::newInstance() - Took 0.00057s                                                             
thomas@gentoo ~ % amarok: [MountPointManager] [WARNING!] NOT-IMPLEMENTED:  void MountPointManager::startStatisticsUpdateJob() 

amarok: BEGIN: void DaapCollectionFactory::connectToManualServers() 
amarok: END__: void DaapCollectionFactory::connectToManualServers() - Took 0.00017s 
amarok: BEGIN: bool AmarokScript::ScriptImporter::loadQtBinding(const QString&)     
amarok:    importing qt bindings  "qt.network"                                      
amarok: END__: bool AmarokScript::ScriptImporter::loadQtBinding(const QString&) - Took 0.025s 
amarok:  Success. Committing result to database.                                              
amarok:  ERROR: Database temporary table setup did not complete.  This is probably a result of no directories being scanned. 
amarok: BEGIN: virtual ScanResultProcessor::~ScanResultProcessor()                                                           
amarok: END__: virtual ScanResultProcessor::~ScanResultProcessor() - Took 2.9e-05s                                           
amarok: END__: virtual void XmlParseJob::run() - Took 0.59s                                                                  
amarok: BEGIN: void ScanManager::slotFinished()                                                                              
amarok: END__: void ScanManager::slotFinished() - Took 0.00011s                                                              
amarok: BEGIN: bool AmarokScript::ScriptImporter::loadQtBinding(const QString&)                                              
amarok:    importing qt bindings  "qt.gui"                                                                                   
amarok: END__: bool AmarokScript::ScriptImporter::loadQtBinding(const QString&) - Took 0.063s                                
amarok: BEGIN: void CurrentEngine::stoppedState()                                                                            
amarok:    Initialized thread, count== 2                                                                                     
amarok:    [ERROR!] GREPME MySQL query failed! No database selected  on  "SELECT urls.deviceid, urls.rpath, urls.uniqueid, tracks.id, tracks.title, tracks.comment, tracks.tracknumber, tracks.discnumber, statistics.score, statistics.rating, tracks.bitrate, tracks.length, tracks.filesize, tracks.samplerate, statistics.createdate, statistics.accessdate, statistics.playcount, tracks.filetype, tracks.bpm, tracks.albumgain, tracks.albumpeakgain, tracks.trackgain, tracks.trackpeakgain, artists.name, artists.id, albums.name, albums.id, albums.artist, genres.name, genres.id, composers.name, composers.id, years.name, years.id FROM  tracks INNER JOIN urls ON tracks.url = urls.id LEFT JOIN artists ON tracks.artist = artists.id LEFT JOIN albums ON tracks.album = albums.id LEFT JOIN genres ON tracks.genre = genres.id LEFT JOIN composers ON tracks.composer = composers.id LEFT JOIN years ON tracks.year = years.id LEFT JOIN statistics ON urls.id = statistics.url WHERE 1  AND ( 1   AND  NOT tracks.title  = ''   )  ORDER BY statistics.accessdate DESC  LIMIT 5 OFFSET 0 ;"            
amarok: END__: void CurrentEngine::stoppedState() - Took 0.0011s                                                                                                                    
amarok: BEGIN: void CurrentTrack::dataUpdated(const QString&, const QHash<QString, QVariant>&)                                                                                      
amarok: END__: void CurrentTrack::dataUpdated(const QString&, const QHash<QString, QVariant>&) - Took 0.00026s                                                                      
amarok: BEGIN: virtual XmlParseJob::~XmlParseJob()                                                                                                                                  
amarok:   BEGIN: void CompoundProgressBar::childBarComplete(ProgressBar*)                                                                                                           
amarok:      p before:  QPoint(2,-9)                                                                                                                                                
amarok:      p after:  QPoint(4,650)                                                                                                                                                
amarok:     BEGIN: void ProgressBar::setDescription(const QString&)                                                                                                                 
amarok:     END__: void ProgressBar::setDescription(const QString&) - Took 0.00012s                                                                                                 
amarok:     BEGIN: void StatusBar::hideProgress()                                                                                                                                   
amarok:     END__: void StatusBar::hideProgress() - Took 0.2s                                                                                                                       
amarok:   END__: void CompoundProgressBar::childBarComplete(ProgressBar*) - Took 0.2s                                                                                               
amarok: END__: virtual XmlParseJob::~XmlParseJob() - Took 0.2s                                                                                                                      
amarok: BEGIN: void CurrentEngine::setupTracksData()                                                                                                                                
amarok: END__: void CurrentEngine::setupTracksData() - Took 0.00026s                                                                                                                
amarok: BEGIN: void CurrentTrack::dataUpdated(const QString&, const QHash<QString, QVariant>&)                                                                                      
amarok: END__: void CurrentTrack::dataUpdated(const QString&, const QHash<QString, QVariant>&) - Took 0.00018s                                                                      
amarok:  SCRIPT "Librivox.org" :  "creating service..."                                                                                                                             
amarok: BEGIN: static QScriptValue ScriptableServiceScript::ScriptableServiceScript_prototype_ctor(QScriptContext*, QScriptEngine*)                                                 
amarok:   BEGIN: bool ScriptableServiceManager::initService(const QString&, int, const QString&, const QString&, bool)                                                              
amarok:      initializing scripted service:  "Librivox.org"                                                                                                                         
amarok:     BEGIN: ServiceBase::ServiceBase(const QString&, ServiceFactory*, bool, const QString&)                                                                                  
amarok:     END__: ServiceBase::ServiceBase(const QString&, ServiceFactory*, bool, const QString&) - Took 0.0019s                                                                   
amarok:     BEGIN: ScriptableService::ScriptableService(const QString&)                                                                                                             
amarok:        creating ScriptableService  "Librivox.org"                                                                                                                           
amarok:     END__: ScriptableService::ScriptableService(const QString&) - Took 0.00018s                                                                                             
amarok:     BEGIN: void ScriptableService::init(int, const QString&, bool)                                                                                                          
amarok:       BEGIN: ScriptableServiceCollection::ScriptableServiceCollection(const QString&)                                                                                       
amarok:       END__: ScriptableServiceCollection::ScriptableServiceCollection(const QString&) - Took 0.0001s                                                                        
amarok:     END__: void ScriptableService::init(int, const QString&, bool) - Took 0.00031s                                                                                          
amarok:      emitting scripted service  "Librivox.org"                                                                                                                              
amarok:     BEGIN: void ServiceBrowser::addService(ServiceBase*)                                                                                                                    
amarok:     END__: void ServiceBrowser::addService(ServiceBase*) - Took 0.00014s                                                                                                    
amarok:   END__: bool ScriptableServiceManager::initService(const QString&, int, const QString&, const QString&, bool) - Took 0.0034s                                               
amarok: END__: static QScriptValue ScriptableServiceScript::ScriptableServiceScript_prototype_ctor(QScriptContext*, QScriptEngine*) - Took 0.004s                                   
amarok:  SCRIPT "Librivox.org" :  "done creating service!"                                                                                                                          
amarok: BEGIN: void ScriptableServiceScript::slotCustomize(const QString&)                                                                                                          
amarok:    SCRIPT "Librivox.org" :  "customizing Librivox service"                                                                                                                  
amarok:    SCRIPT "Librivox.org" :  "loading icon: /usr/share/apps/amarok/scripts/librivox_service/LibrivoxIcon.png"                                                                
amarok:   BEGIN: void ScriptableServiceManager::setIcon(const QString&, const QPixmap&)                                                                                             
amarok:      service:  "Librivox.org"                                                                                                                                               
amarok:   END__: void ScriptableServiceManager::setIcon(const QString&, const QPixmap&) - Took 0.00026s                                                                             
amarok: END__: void ScriptableServiceScript::slotCustomize(const QString&) - Took 0.0016s                                                                                           
amarok: END__: bool ScriptManager::slotRunScript(QString, bool) - Took 0.9s                                                                                                         
amarok: BEGIN: bool ScriptManager::slotRunScript(QString, bool)                                                                                                                     
amarok:   BEGIN: void ScriptManager::startScriptEngine(QString)                                                                                                                     
amarok:     BEGIN: ScriptableServiceScript::ScriptableServiceScript(QScriptEngine*)                                                                                                 
amarok:     END__: ScriptableServiceScript::ScriptableServiceScript(QScriptEngine*) - Took 0.00012s                                                                                 
amarok:     BEGIN: Downloader::Downloader(QScriptEngine*)                                                                                                                           
amarok:     END__: Downloader::Downloader(QScriptEngine*) - Took 0.00011s                                                                                                           
amarok:   END__: void ScriptManager::startScriptEngine(QString) - Took 0.0011s                                                                                                      
amarok:   BEGIN: bool AmarokScript::ScriptImporter::loadQtBinding(const QString&)                                                                                                   
amarok:      importing qt bindings  "qt.core"                                                                                                                                       
amarok:   END__: bool AmarokScript::ScriptImporter::loadQtBinding(const QString&) - Took 0.03s                                                                                      
amarok:   BEGIN: bool AmarokScript::ScriptImporter::loadQtBinding(const QString&)                                                                                                   
amarok:      importing qt bindings  "qt.xml"                                                                                                                                        
amarok:   END__: bool AmarokScript::ScriptImporter::loadQtBinding(const QString&) - Took 0.035s                                                                                     
amarok: END__: bool ScriptManager::slotRunScript(QString, bool) - Took 0.12s                                                                                                        
amarok: END__: void ScriptManager::slotConfigChanged(bool) - Took 1s                                                                                                                
amarok: END__: void ScriptManager::findScripts() - Took 1.1s                                                                                                                        
amarok: BEGIN: void ScanManager::startIncrementalScan()                                                                                                                             
amarok:   BEGIN: QStringList ScanManager::getDirsToScan()
amarok:      [ERROR!] GREPME MySQL query failed! No database selected  on  "SELECT id, deviceid, dir, changedate FROM directories WHERE deviceid IN (-1);"
amarok:   END__: QStringList ScanManager::getDirsToScan() - Took 0.0002s
amarok:    GOING TO SCAN:
amarok:    Scanning nothing, return.
amarok:   BEGIN: void ScanManager::writeBatchIncrementalInfoFile()
amarok:   END__: void ScanManager::writeBatchIncrementalInfoFile() - Took 0.00016s
amarok: END__: void ScanManager::startIncrementalScan() - Took 0.00058s
amarok: BEGIN: InfoProxy::InfoProxy()
amarok:   BEGIN: void InfoProxy::loadHomePage()
amarok:   END__: void InfoProxy::loadHomePage() - Took 0.0002s
amarok: END__: InfoProxy::InfoProxy() - Took 0.00034s
amarok: BEGIN: void BrowserCategoryList::categoryActivated(const QModelIndex&)
amarok:    Show service:  "files"
amarok:   BEGIN: void BrowserCategoryList::showCategory(const QString&)
amarok:     BEGIN: void BreadcrumbWidget::updateBreadcrumbs()
amarok:       BEGIN: void BreadcrumbWidget::addLevel(BrowserCategoryList*)
amarok:       END__: void BreadcrumbWidget::addLevel(BrowserCategoryList*) - Took 0.0017s
amarok:     END__: void BreadcrumbWidget::updateBreadcrumbs() - Took 0.0069s
amarok:   END__: void BrowserCategoryList::showCategory(const QString&) - Took 0.016s
amarok:   BEGIN: void BreadcrumbWidget::updateBreadcrumbs()
amarok:     BEGIN: void BreadcrumbWidget::addLevel(BrowserCategoryList*)
amarok:     END__: void BreadcrumbWidget::addLevel(BrowserCategoryList*) - Took 0.0034s
amarok:   END__: void BreadcrumbWidget::updateBreadcrumbs() - Took 0.0061s
amarok: END__: void BrowserCategoryList::categoryActivated(const QModelIndex&) - Took 0.023s
amarok: BEGIN: void BreadcrumbWidget::updateBreadcrumbs()
amarok:   BEGIN: void BreadcrumbWidget::addLevel(BrowserCategoryList*)
amarok:   END__: void BreadcrumbWidget::addLevel(BrowserCategoryList*) - Took 0.00065s
amarok: END__: void BreadcrumbWidget::updateBreadcrumbs() - Took 0.0017s
amarok: BEGIN: void BrowserCategoryList::categoryActivated(const QModelIndex&)
amarok:    Show service:  "collections"
amarok:   BEGIN: void BrowserCategoryList::showCategory(const QString&)
amarok:      Initialized thread, count== 3
amarok:      [ERROR!] GREPME MySQL query failed! No database selected  on  "SELECT DISTINCT albums.name, albums.id, albums.artist FROM  tracks LEFT JOIN albums ON tracks.album = albums.id WHERE 1  AND albums.artist IS NULL ;"
amarok:      [ERROR!] GREPME MySQL query failed! No database selected  on  "SELECT DISTINCT artists.name, artists.id FROM  tracks LEFT JOIN artists ON tracks.artist = artists.id LEFT JOIN albums ON tracks.album = albums.id WHERE 1  AND albums.artist IS NOT NULL ;"
amarok:      [ERROR!] GREPME MySQL query failed! No database selected  on  "SELECT COUNT(urls.rpath) FROM  tracks INNER JOIN urls ON tracks.url = urls.id WHERE 1 ;"
amarok:     BEGIN: void BreadcrumbWidget::updateBreadcrumbs()
amarok:       BEGIN: void BreadcrumbWidget::addLevel(BrowserCategoryList*)
amarok:       END__: void BreadcrumbWidget::addLevel(BrowserCategoryList*) - Took 0.0016s
amarok:     END__: void BreadcrumbWidget::updateBreadcrumbs() - Took 0.0022s
amarok:   END__: void BrowserCategoryList::showCategory(const QString&) - Took 0.0057s
amarok:   BEGIN: void BreadcrumbWidget::updateBreadcrumbs()
amarok:     BEGIN: void BreadcrumbWidget::addLevel(BrowserCategoryList*)
amarok:     END__: void BreadcrumbWidget::addLevel(BrowserCategoryList*) - Took 0.0018s
amarok:   END__: void BreadcrumbWidget::updateBreadcrumbs() - Took 0.0062s
amarok: END__: void BrowserCategoryList::categoryActivated(const QModelIndex&) - Took 0.012s
amarok: BEGIN: void CollectionManager::checkCollectionChanges()
amarok:   BEGIN: void ScanManager::startIncrementalScan()
amarok:     BEGIN: QStringList ScanManager::getDirsToScan()
amarok:        [ERROR!] GREPME MySQL query failed! No database selected  on  "SELECT id, deviceid, dir, changedate FROM directories WHERE deviceid IN (-1);"
amarok:     END__: QStringList ScanManager::getDirsToScan() - Took 0.00015s
amarok:      GOING TO SCAN:
amarok:      Scanning nothing, return.
amarok:     BEGIN: void ScanManager::writeBatchIncrementalInfoFile()
amarok:     END__: void ScanManager::writeBatchIncrementalInfoFile() - Took 0.00017s
amarok:   END__: void ScanManager::startIncrementalScan() - Took 0.00047s
amarok: END__: void CollectionManager::checkCollectionChanges() - Took 0.00058s