Update Collection not working

Kolja Dummann k.dummann at gmail.com
Sat Nov 7 16:52:42 CET 2009


Yes it happens in git master, build 10 mins ago.
Seems like some tables are missing?

amarok: BEGIN: void
CollectionManager::checkCollectionChanges()            
amarok:   BEGIN: void
ScanManager::startIncrementalScan()                  
amarok:     BEGIN: void
ScanManager::checkTables(bool)                     
amarok:     END__: void ScanManager::checkTables(bool) - Took
0.00015s     
amarok:     BEGIN: QStringList
ScanManager::getDirsToScan()                
amarok:     END__: QStringList ScanManager::getDirsToScan() - Took
0.16s   
amarok:      GOING TO
SCAN:                                                
amarok:      (a
*lot*)                                                     
amarok:     BEGIN: void
ScanManager::writeBatchIncrementalInfoFile()       
amarok:     END__: void ScanManager::writeBatchIncrementalInfoFile() -
Took
0.043s                                                                    
amarok:     BEGIN: XmlParseJob::XmlParseJob(ScanManager*,
SqlCollection*)  
amarok:       BEGIN: void ProgressBar::setDescription(const
QString&)      
amarok:       END__: void ProgressBar::setDescription(const QString&) -
Took
6.6e-05s                                                                 
amarok:       BEGIN: void
CompoundProgressBar::addProgressBar(ProgressBar*,
QObject*)                                                                 
amarok:         BEGIN: void ProgressBar::setDescription(const
QString&)    
amarok:         END__: void ProgressBar::setDescription(const QString&)
- Took
6.3e-05s                                                               
amarok:       END__: void
CompoundProgressBar::addProgressBar(ProgressBar*, QObject*) - Took
0.00046s                                                 
amarok:       BEGIN: ProgressBar* ProgressBar::setAbortSlot(QObject*,
const
char*)                                                                    
amarok:          Setting abort slot for  "Scanning
music"                  
amarok:          connecting to
1abort()                                   
amarok:       END__: ProgressBar* ProgressBar::setAbortSlot(QObject*,
const char*) - Took
0.00013s                                                    
amarok:     END__: XmlParseJob::XmlParseJob(ScanManager*,
SqlCollection*) - Took
0.0014s                                                              
amarok:     BEGIN: virtual void
XmlParseJob::run()                         
amarok:       BEGIN:
ScanResultProcessor::ScanResultProcessor(SqlCollection*)                                                                         
amarok:       END__: void ScanManager::startIncrementalScan() - Took
0.21s 
amarok:     END__: void CollectionManager::checkCollectionChanges() -
Took
0.21s                                                                      
amarok:   END__:
ScanResultProcessor::ScanResultProcessor(SqlCollection*) - Took
0.011s                                                               
amarok:   BEGIN: void
ScanManager::slotError(QProcess::ProcessError)       
amarok:      Error:
0                                                     
amarok:      Scan error:  "Unknown error: reseting scan manager
state"     
amarok:     BEGIN: void
ScanManager::stopParser()                          
amarok:       BEGIN: virtual void
XmlParseJob::requestAbort()              
amarok:       END__: virtual void XmlParseJob::requestAbort() - Took
4.5e-05s                                                                         
amarok:        Abort
requested.                                            
amarok:       BEGIN: void
DatabaseUpdater::removeTemporaryTables()         
amarok:          [ERROR!] GREPME MySQL query failed! Unknown table
'tracks_temp'  on  "DROP TABLE
tracks_temp;"                                       
amarok:          [ERROR!] GREPME MySQL query failed! Unknown table
'images_temp'  on  "DROP TABLE
images_temp;"                                       
amarok:          [ERROR!] GREPME MySQL query failed! Unknown table
'albums_temp'  on  "DROP TABLE
albums_temp;"                                       
amarok:          [ERROR!] GREPME MySQL query failed! Unknown table
'genres_temp'  on  "DROP TABLE
genres_temp;"                                       
amarok:          [ERROR!] GREPME MySQL query failed! Unknown table
'years_temp'  on  "DROP TABLE
years_temp;"                                         
amarok:          [ERROR!] GREPME MySQL query failed! Unknown table
'composers_temp'  on  "DROP TABLE
composers_temp;"                                 
amarok:          [ERROR!] GREPME MySQL query failed! Unknown table
'artists_temp'  on  "DROP TABLE
artists_temp;"                                     
amarok:          [ERROR!] GREPME MySQL query failed! Unknown table
'urls_temp'  on  "DROP TABLE
urls_temp;"                                           
amarok:          [ERROR!] GREPME MySQL query failed! Unknown table
'directories_temp'  on  "DROP TABLE
directories_temp"                              
amarok:       END__: void DatabaseUpdater::removeTemporaryTables() -
Took
0.00099s                                                                    
amarok:       BEGIN: virtual
ScanResultProcessor::~ScanResultProcessor()   
amarok:       END__: virtual ScanResultProcessor::~ScanResultProcessor()
- Took
3.8e-05s                                                              
amarok:     END__: virtual void XmlParseJob::run() - Took
0.039s           
amarok:   END__: void ScanManager::stopParser() - Took
0.1s                
amarok: END__: void ScanManager::slotError(QProcess::ProcessError) -
Took
0.1s                                                                        
QCoreApplication::postEvent: Unexpected null
receiver                      
amarok: BEGIN: virtual
XmlParseJob::~XmlParseJob()                         
amarok:   BEGIN: void
CompoundProgressBar::childBarComplete(ProgressBar*)  
amarok:     BEGIN: void ProgressBar::setDescription(const
QString&)        
amarok:     END__: void ProgressBar::setDescription(const QString&) -
Took
0.00013s                                                                   
amarok:     BEGIN: void
StatusBar::hideProgress()                          
amarok:     END__: void StatusBar::hideProgress() - Took
0.00083s          
amarok:   END__: void
CompoundProgressBar::childBarComplete(ProgressBar*) - Took
0.0017s                                                              
amarok: END__: virtual XmlParseJob::~XmlParseJob() - Took
0.0019s          
amarok: BEGIN: void
MainWindow::layoutChanged()                            
amarok:   [MainWindow] ignored:
false                                     
amarok: END__: void MainWindow::layoutChanged() - Took
0.00025s            
amarok: BEGIN: void
MainWindow::layoutChanged()                            
amarok:   [MainWindow] ignored:
false                                     
amarok: END__: void MainWindow::layoutChanged() - Took
0.00016s            
amarok: BEGIN: void
MainWindow::layoutChanged()                            
amarok:   [MainWindow] ignored:
false                                     
amarok: END__: void MainWindow::layoutChanged() - Took
0.00016s            
amarok: BEGIN: void
MainWindow::saveLayout()                               
amarok: END__: void MainWindow::saveLayout() - Took
0.023s                 
amarok: BEGIN: void
ScanManager::startIncrementalScan()                    
amarok:   BEGIN: void
ScanManager::checkTables(bool)                       
amarok:     BEGIN: void
DatabaseUpdater::checkTables(bool)                 
amarok:     END__: void DatabaseUpdater::checkTables(bool) - Took
0.3s     
amarok:   END__: void ScanManager::checkTables(bool) - Took
0.3s           
amarok:   BEGIN: QStringList
ScanManager::getDirsToScan()                  
amarok:   END__: QStringList ScanManager::getDirsToScan() - Took
0.075s    
amarok:    GOING TO
SCAN:                                                  
amarok:    (a
*lot*)                                                       
amarok:   BEGIN: void
ScanManager::writeBatchIncrementalInfoFile()         
amarok:   END__: void ScanManager::writeBatchIncrementalInfoFile() -
Took
0.021s                                                                      
amarok:   BEGIN: XmlParseJob::XmlParseJob(ScanManager*,
SqlCollection*)    
amarok:     BEGIN: void ProgressBar::setDescription(const
QString&)        
amarok:     END__: void ProgressBar::setDescription(const QString&) -
Took
6.2e-05s                                                                   
amarok:     BEGIN: void
CompoundProgressBar::addProgressBar(ProgressBar*,
QObject*)                                                                   
amarok:       BEGIN: void ProgressBar::setDescription(const
QString&)      
amarok:       END__: void ProgressBar::setDescription(const QString&) -
Took
6.6e-05s                                                                 
amarok:     END__: void
CompoundProgressBar::addProgressBar(ProgressBar*, QObject*) - Took
0.00045s                                                   
amarok:     BEGIN: ProgressBar* ProgressBar::setAbortSlot(QObject*,
const
char*)                                                                      
amarok:        Setting abort slot for  "Scanning
music"                    
amarok:        connecting to
1abort()                                     
amarok:     END__: ProgressBar* ProgressBar::setAbortSlot(QObject*,
const char*) - Took
0.00011s                                                      
amarok:   END__: XmlParseJob::XmlParseJob(ScanManager*, SqlCollection*)
- Took
0.0014s                                                                
amarok: END__: void ScanManager::startIncrementalScan() - Took
0.4s        
amarok: BEGIN: void
ScanManager::slotError(QProcess::ProcessError)         
amarok:    Error:
0                                                       
amarok:    Scan error:  "Unknown error: reseting scan manager
state"       
amarok:   BEGIN: void
ScanManager::stopParser()                            
amarok:     BEGIN: virtual void
XmlParseJob::run()                         
amarok:       BEGIN: virtual void
XmlParseJob::requestAbort()              
amarok:       END__: virtual void XmlParseJob::requestAbort() - Took
0.0001s                                                                          
amarok:       BEGIN:
ScanResultProcessor::ScanResultProcessor(SqlCollection*)                                                                         
amarok:       END__:
ScanResultProcessor::ScanResultProcessor(SqlCollection*) - Took
0.0037s                                                          
amarok:        Abort
requested.                                            
amarok:       BEGIN: void
DatabaseUpdater::removeTemporaryTables()         
amarok:          [ERROR!] GREPME MySQL query failed! Unknown table
'tracks_temp'  on  "DROP TABLE
tracks_temp;"                                       
amarok:          [ERROR!] GREPME MySQL query failed! Unknown table
'images_temp'  on  "DROP TABLE
images_temp;"                                       
amarok:          [ERROR!] GREPME MySQL query failed! Unknown table
'albums_temp'  on  "DROP TABLE
albums_temp;"                                       
amarok:          [ERROR!] GREPME MySQL query failed! Unknown table
'genres_temp'  on  "DROP TABLE
genres_temp;"                                       
amarok:          [ERROR!] GREPME MySQL query failed! Unknown table
'years_temp'  on  "DROP TABLE
years_temp;"                                         
amarok:          [ERROR!] GREPME MySQL query failed! Unknown table
'composers_temp'  on  "DROP TABLE
composers_temp;"                                 
amarok:          [ERROR!] GREPME MySQL query failed! Unknown table
'artists_temp'  on  "DROP TABLE
artists_temp;"                                     
amarok:          [ERROR!] GREPME MySQL query failed! Unknown table
'urls_temp'  on  "DROP TABLE
urls_temp;"                                           
amarok:          [ERROR!] GREPME MySQL query failed! Unknown table
'directories_temp'  on  "DROP TABLE
directories_temp"                              
amarok:       END__: void DatabaseUpdater::removeTemporaryTables() -
Took
0.00086s                                                                    
amarok:       BEGIN: virtual
ScanResultProcessor::~ScanResultProcessor()   
amarok:       END__: virtual ScanResultProcessor::~ScanResultProcessor()
- Took
5.8e-05s                                                              
amarok:     END__: virtual void XmlParseJob::run() - Took
0.0048s          
amarok:   END__: void ScanManager::stopParser() - Took 0.1s
amarok: END__: void ScanManager::slotError(QProcess::ProcessError) -
Took 0.1s
QCoreApplication::postEvent: Unexpected null receiver
amarok: BEGIN: virtual XmlParseJob::~XmlParseJob()
amarok:   BEGIN: void
CompoundProgressBar::childBarComplete(ProgressBar*)
amarok:     BEGIN: void ProgressBar::setDescription(const QString&)
amarok:     END__: void ProgressBar::setDescription(const QString&) -
Took 0.00015s
amarok:     BEGIN: void StatusBar::hideProgress()
amarok:     END__: void StatusBar::hideProgress() - Took 0.00049s
amarok:   END__: void
CompoundProgressBar::childBarComplete(ProgressBar*) - Took 0.0015s
amarok: END__: virtual XmlParseJob::~XmlParseJob() - Took 0.0017s


On Sa, 2009-11-07 at 10:24 -0500, Jeff Mitchell wrote:
> Kolja Dummann wrote:
> > Hey folks,
> > 
> > I'm experiencing some problems with "Update Collection". At first "watch
> > folders for changes" is not working but I think its related to problem
> > 2. Second the "Update collection" is not working. The progressbar
> > appears but it runs in ~1 sec. to 100% and does not find any new songs
> > in the directories of collection. Only a full rescan of the collection
> > gets these tracks into the collection. 
> > I'm using a git build from yesterday but the problem is there for about
> > an week. Don't know if these is the real date but it was the first time
> > i noticed it. 
> > 
> > What I have tried to solve the problem is:
> 
> Does it still happen with git master? What do you get in the debug log?
> 
> --Jeff
> 
> _______________________________________________
> Amarok-devel mailing list
> Amarok-devel at kde.org
> https://mail.kde.org/mailman/listinfo/amarok-devel

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: This is a digitally signed message part
Url : http://mail.kde.org/pipermail/amarok-devel/attachments/20091107/fa3c1c00/attachment.sig 


More information about the Amarok-devel mailing list