I have just scanned my 40000+ title music collection and found that
after that, only about 20000+ titles had made it into the database.
Looking into the slimserver log, I found this one:
Code:
--------------------
2006-09-15 11:44:44.3703 About to look for files in /music/m
2006-09-15 11:44:44.3716 For files with extensions in:
[(?i-xsm:\.(?:ape|wma|shn|wav|wave|mp3|mp2|flc|flac|m4a|mov|m4b|mp4|mp+|mpc|ogg|aif|aiff|cue)$)]
2006-09-15 11:47:53.8033 Found 40312 files in /music/m
Size mismatch on COMM
at /usr/local/SlimServer_trunk_v6.5b3/server/Slim/Formats/MP3.pm line 129
2006-09-15 12:40:18.8265 ERROR: Error executing 'SELECT me.id, me.titlesort,
me.compilation, me.year, me.artwork, me.disc, me.discc, me.musicmagic_mixable,
me.titlesearch, me.replay_gain, me.replay_peak, me.musicbrainz_id, me.title
FROM albums me LEFT JOIN tracks tracks ON ( tracks.album = me.id ) WHERE (
me.disc IS NULL AND me.discc IS NULL AND me.title = ? AND tracks.url LIKE ? )
GROUP BY me.id': DBD::mysql::st execute failed: Got error 28 from storage
engine at
/usr/local/SlimServer_trunk_v6.5b3/server/CPAN/DBIx/Class/Storage/DBI.pm line
771.
2006-09-15 12:40:18.9175 ERROR: Backtrace follows:
2006-09-15 12:40:18.9179 Backtrace:
frame 0: Slim::Schema::Storage::throw_exception
(/usr/local/SlimServer_trunk_v6.5b3/server/CPAN/DBIx/Class/Storage/DBI.pm line
773)
frame 1: DBIx::Class::Storage::DBI::_execute
(/usr/local/SlimServer_trunk_v6.5b3/server/CPAN/DBIx/Class/Storage/DBI.pm line
826)
frame 2: DBIx::Class::Storage::DBI::_select
(/usr/local/SlimServer_trunk_v6.5b3/server/CPAN/DBIx/Class/Storage/DBI.pm line
852)
frame 3: DBIx::Class::Storage::DBI::select_single
(/usr/local/SlimServer_trunk_v6.5b3/server/Slim/Schema/Storage.pm line 55)
frame 4: Slim::Schema::Storage::select_single
(/usr/local/SlimServer_trunk_v6.5b3/server/CPAN/DBIx/Class/ResultSet.pm line
509)
frame 5: DBIx::Class::ResultSet::single
(/usr/local/SlimServer_trunk_v6.5b3/server/Slim/Schema.pm line 1958)
frame 6: Slim::Schema::_postCheckAttributes
(/usr/local/SlimServer_trunk_v6.5b3/server/Slim/Schema.pm line 807)
frame 7: Slim::Schema::newTrack
(/usr/local/SlimServer_trunk_v6.5b3/server/Slim/Utils/Scanner.pm line 322)
frame 8: Slim::Utils::Scanner::scanDirectory
(/usr/local/SlimServer_trunk_v6.5b3/server/Slim/Music/MusicFolderScan.pm line
72)
frame 9: Slim::Music::MusicFolderScan::startScan
(/usr/local/SlimServer_trunk_v6.5b3/server/Slim/Music/Import.pm line 390)
frame 10: Slim::Music::Import::runImporter
(/usr/local/SlimServer_trunk_v6.5b3/server/Slim/Music/Import.pm line 233)
frame 11: Slim::Music::Import::runScan
(/usr/local/SlimServer_trunk_v6.5b3/server/scanner.pl line 179)
frame 12: (eval) (/usr/local/SlimServer_trunk_v6.5b3/server/scanner.pl line
173)
frame 13: main::main (/usr/local/SlimServer_trunk_v6.5b3/server/scanner.pl
line 330)
2006-09-15 12:40:18.9376 ERROR: Scanner: Failed when running main scan:
[DBD::mysql::st fetchrow_array failed: fetch() without execute() at
/usr/local/SlimServer_trunk_v6.5b3/server/CPAN/DBIx/Class/Storage/DBI.pm line
853.
]
2006-09-15 12:40:18.9381 ERROR: Scanner: Skipping post-process & Not updating
lastRescanTime!
--------------------
I won't dive into this one. Maybe the message "Size mismatch on COMM"
has something to do with too large MySQL requests?
--
meyergru
------------------------------------------------------------------------
meyergru's Profile: http://forums.slimdevices.com/member.php?userid=1980
View this thread: http://forums.slimdevices.com/showthread.php?t=27425
_______________________________________________
discuss mailing list
discuss@lists.slimdevices.com
http://lists.slimdevices.com/lists/listinfo/discuss
