PDA

View Full Version : MySQL problem with 6.5b3



meyergru
2006-09-15, 05:09
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:



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!



As you can see, all 40000+ file have actually been found. Maybe the message "Size mismatch on COMM" has something to do with too large MySQL requests?

<edit>
Maybe, this was a space problem. I might just have filled up my storage...
</edit>