Local Collection Not Building Right
Alejandro Wainzinger
aikawarazuni at gmail.com
Sun Jul 6 09:05:59 CEST 2008
For a few weeks now, my rescan of the local collection has given me
only "Various Artists," and an empty "Unknown" album within it. Often
it reaches about 70'ish percent on the bar, and then stops. I don't
think I have any problematic files, as Amarok 1.4 handles this scan
perfectly. Here's the debug output:
amarok: BEGIN: void ScanManager::startFullScan()
amarok(11071) KDE::ProgressBar::ProgressBar: " "
amarok: p before: QPoint(0,-18)
amarok: p after: QPoint(0,951)
amarok: END__: void ScanManager::startFullScan() - Took 0.098s
amarok: BEGIN: virtual void XmlParseJob::run()
amarok: BEGIN: ScanResultProcessor::ScanResultProcessor(SqlCollection*)
amarok: END__: ScanResultProcessor::ScanResultProcessor(SqlCollection*)
- Took 0.00012s
amarok: BEGIN: void DatabaseUpdater::createTemporaryTables()
amarok: END__: void DatabaseUpdater::createTemporaryTables() - Took 0.27s
amarok: BEGIN: void ScanManager::slotFinished()
amarok: END__: void ScanManager::slotFinished() - Took 0.0001s
amarok: [ERROR!] sqlite3_compile error:
amarok: [ERROR!] no such table: images
amarok: [ERROR!] on query: "DELETE FROM images;"
amarok: BEGIN: void DatabaseUpdater::copyToPermanentTables()
amarok: [ERROR!] sqlite3_compile error:
amarok: [ERROR!] no such table: images
amarok: [ERROR!] on query: "DELETE FROM images;"
amarok: [ERROR!] sqlite3_compile error:
amarok: [ERROR!] no such table: images
amarok: [ERROR!] on insert: "INSERT INTO images SELECT * FROM
images_temp;"
amarok: [ERROR!] sqlite3_compile error:
amarok: [ERROR!] table albums has 3 columns but 4 values were supplied
amarok: [ERROR!] on insert: "INSERT INTO albums SELECT * FROM
albums_temp WHERE albums_temp.id NOT IN ( -1 );"
amarok: END__: void DatabaseUpdater::copyToPermanentTables() - Took 0.073s
amarok: BEGIN: void DatabaseUpdater::removeTemporaryTables()
amarok: END__: void DatabaseUpdater::removeTemporaryTables() - Took 0.015s
amarok: BEGIN: ScanResultProcessor::~ScanResultProcessor()
amarok: END__: ScanResultProcessor::~ScanResultProcessor() - Took 4e-05s
amarok: END__: virtual void XmlParseJob::run() - Took 8.3s
amarok: BEGIN: void Dynamic::BiasedPlaylist::startSolver()
amarok: END__: void Dynamic::BiasedPlaylist::startSolver() - Took 8.9e-05s
amarok: BEGIN: void CollectionTreeItemModel::update()
amarok: thread starting up
amarok: END__: void CollectionTreeItemModel::update() - Took 0.0025s
amarok: BEGIN: void Dynamic::BiasedPlaylist::startSolver()
amarok: END__: void Dynamic::BiasedPlaylist::startSolver() - Took 6.2e-05s
amarok: BEGIN: void CollectionTreeItemModel::update()
amarok: Calling runQuery()
amarok: END__: void CollectionTreeItemModel::update() - Took 0.00061s
amarok(11071) KDE::ProgressBar::~ProgressBar: ""
amarok: thread starting up
amarok: Calling runQuery()
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 100 , 0.48 , 2.03704e-11 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 200 , 0.46 , 4.14952e-21 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 300 , 0.45 , 8.45271e-31 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 400 , 0.44 , 1.72185e-40 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 500 , 0.41 , 3.50747e-50 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 600 , 0.39 , 7.14483e-60 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 700 , 0.38 , 1.45543e-69 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 800 , 0.36 , 2.96476e-79 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 900 , 0.34 , 6.03932e-89 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 1000 , 0.34 , 1.23023e-98 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 1100 , 0.33 , 2.50603e-108 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 1200 , 0.29 , 5.10487e-118 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 1300 , 0.28 , 1.03988e-127 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 1400 , 0.27 , 2.11827e-137 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 1500 , 0.27 , 4.315e-147 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 1600 , 0.26 , 8.7898e-157 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 1700 , 0.25 , 1.79051e-166 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 1800 , 0.23 , 3.64734e-176 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 1900 , 0.2 , 7.42977e-186 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 2000 , 0.2 , 1.51347e-195 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 2100 , 0.2 , 3.08299e-205 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 2200 , 0.19 , 6.28017e-215 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 2300 , 0.18 , 1.27929e-224 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 2400 , 0.17 , 2.60597e-234 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 2500 , 0.14 , 5.30845e-244 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 2600 , 0.13 , 1.08135e-253 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 2700 , 0.13 , 2.20275e-263 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 2800 , 0.13 , 4.48708e-273 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 2900 , 0.12 , 9.14034e-283 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 3000 , 0.11 , 1.86192e-292 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 3100 , 0.11 , 3.7928e-302 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 3200 , 0.1 , 7.72607e-312 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 3300 , 0.09 , 1.57113e-321 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 3400 , 0.07 , 9.88131e-324 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 3500 , 0.07 , 9.88131e-324 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 3600 , 0.06 , 9.88131e-324 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 3700 , 0.06 , 9.88131e-324 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 3800 , 0.06 , 9.88131e-324 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 3900 , 0.04 , 9.88131e-324 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 4000 , 0.03 , 9.88131e-324 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 4100 , 0.02 , 9.88131e-324 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 4200 , 0.02 , 9.88131e-324 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: BiasSolver: (i, E, T) = ( 4300 , 0.01 , 9.88131e-324 )
amarok: thread starting up
amarok: Calling runQuery()
amarok: [ERROR!] sqlite3_compile error:
amarok: [ERROR!] no such table: images
amarok: [ERROR!] on query: "SELECT path FROM images, albums WHERE
albums.image = images.id AND albums.id = 0;"
More information about the Amarok-devel
mailing list