Re: [SlimDevices: SqueezeCenter] Scan taking hours instead of minutes on recent nightlies
mherger wrote: > > Still taking a long time for me: > > Thanks for your file! So... you have 10 playlists with 10k+ tracks? One > > with close to 30k tracks. Do you really use those? They seem to be > imported from iTunes. Unless you're serious about using them I suggest > you add them to the ignore list in the iTunes plugin settings. This > should speed up the import considerably. > > -- > > Michael Thanks, looks like I need a tidy up! Ade_AV's Profile: http://forums.slimdevices.com/member.php?userid=69532 View this thread: http://forums.slimdevices.com/showthread.php?t=112920 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Scan taking hours instead of minutes on recent nightlies
Still taking a long time for me: Code: [20-09-26 08:09:47.0649] main::main (206) Starting Logitech Media Server scanner (v8.0.0, 1601033329, Fri Sep 25 13:53:32 CEST 2020) perl 5.018004 [20-09-26 08:27:31.4928] Slim::Music::Import::runImporter (577) Starting Slim::Plugin::FullTextSearch::Plugin scan [20-09-26 08:27:31.4933] Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (445) Starting fulltext index build [20-09-26 08:27:31.4934] Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (449) Initialize fulltext table [20-09-26 08:27:31.5326] Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (462) Create fulltext index for tracks [20-09-26 08:27:36.0543] Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (472) Create fulltext index for albums [20-09-26 08:27:37.9209] Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (481) Create fulltext index for contributors [20-09-26 08:27:38.0669] Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (491) Create fulltext index for playlists [20-09-26 10:41:00.4914] Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (506) Optimize fulltext index [20-09-26 10:41:00.9810] Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (521) Fulltext index build done! [20-09-26 10:41:00.9812] Slim::Music::Import::endImporter (709) Completed Slim::Plugin::FullTextSearch::Plugin Scan in 8009 seconds. Ade_AV's Profile: http://forums.slimdevices.com/member.php?userid=69532 View this thread: http://forums.slimdevices.com/showthread.php?t=112920 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Scan taking hours instead of minutes on recent nightlies
mherger wrote: > > [20-09-25 18:29:07.5107] > Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (479) Create > fulltext index for playlists > >[20-09-25 18:29:10.5696] Slim::Schema::Storage::throw_exception > (121) Error: DBI Exception: DBD::SQLite::db do failed: malformed MATCH > expression: [file:///Volumes/Ade_iTunes/iTunes/iTunes > Media/Music/Metz/Metz/11 --))--.m4a] [for Statement " > > What LMS build is this? > > -- > > Michael Code: [20-09-25 17:56:17.1967] main::main (206) Starting Logitech Media Server scanner (v8.0.0, 1600976618, Thu Sep 24 22:15:54 CEST 2020) perl 5.018004 [20-09-25 17:56:17.3779] Slim::Schema::forceCommit (2157) Warning: Trying to commit transactions before DB is initialized! Ade_AV's Profile: http://forums.slimdevices.com/member.php?userid=69532 View this thread: http://forums.slimdevices.com/showthread.php?t=112920 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter
Re: [SlimDevices: SqueezeCenter] Scan taking hours instead of minutes on recent nightlies
Code: [20-09-25 18:29:07.5107] Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (479) Create fulltext index for playlists [20-09-25 18:29:10.5696] Slim::Schema::Storage::throw_exception (121) Error: DBI Exception: DBD::SQLite::db do failed: malformed MATCH expression: [file:///Volumes/Ade_iTunes/iTunes/iTunes Media/Music/Metz/Metz/11 --))--.m4a] [for Statement " INSERT INTO fulltext (id, type, w10, w5, w3, w1) SELECT playlist_track.playlist, 'playlist', ?, '', ?, GROUP_CONCAT(w10 || ' ' || w5 || ' ' || w3 || ' ' || w1) FROM playlist_track LEFT JOIN tracks ON tracks.url = playlist_track.track LEFT JOIN fulltext ON fulltext MATCH REPLACE(playlist_track.track, '%20', ' ') AND type = 'track' WHERE playlist_track.playlist = ? "] [20-09-25 18:29:10.5700] Slim::Schema::Storage::throw_exception (121) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Schema/Storage.pm line 121) frame 1: Slim::Schema::Storage::throw_exception (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/CPAN/DBIx/Class/Storage/DBI.pm line 1006) frame 2: DBIx::Class::Storage::DBI::__ANON__ (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Plugin/FullTextSearch/Plugin.pm line 520) frame 3: Slim::Plugin::FullTextSearch::Plugin::_createPlaylistItem (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Plugin/FullTextSearch/Plugin.pm line 488) frame 4: Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Plugin/FullTextSearch/Plugin.pm line 157) frame 5: Slim::Plugin::FullTextSearch::Plugin::startScan (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Music/Import.pm line 579) frame 6: Slim::Music::Import::runImporter (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Music/Import.pm line 455) frame 7: Slim::Music::Import::runScanPostProcessing (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/scanner.pl line 344) frame 8: (eval) (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/scanner.pl line 344) frame 9: main::main (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/scanner.pl line 499) [20-09-25 18:29:10.5724] main::main (348) Error: Failed when running scan post-process: [Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db do failed: malformed MATCH expression: [file:///Volumes/Ade_iTunes/iTunes/iTunes Media/Music/Metz/Metz/11 --))--.m4a] [for Statement " INSERT INTO fulltext (id, type, w10, w5, w3, w1) SELECT playlist_track.playlist, 'playlist', ?, '', ?, GROUP_CONCAT(w10 || ' ' || w5 || ' ' || w3 || ' ' || w1) FROM playlist_track LEFT JOIN tracks ON tracks.url = playlist_track.track LEFT JOIN fulltext ON fulltext MATCH REPLACE(playlist_track.track, '%20', ' ') AND type = 'track' WHERE playlist_track.playlist = ? "] at /Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Schema/Storage.pm line 125 ] [20-09-25 18:29:10.5726] main::main (349) Error: Not updating lastRescanTime! Ade_AV's Profile: http://forums.slimdevices.com/member.php?userid=69532 View this thread: http://forums.slimdevices.com/showthread.php?t=112920 ___ Squeezecenter mailing list Squeezecenter@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/squeezecenter