PDA

View Full Version : 7.2 Scanner Crashing- Error Log



dougwise
2008-09-05, 10:43
I am having problems getting the 7.2 scanner to make it through my 70,000 songs without crashing. I use MusicIP on windows XP and everything worked fine on 7.1.

The top of the log file had several hundred entries like:

[00:43:57.4646] Slim::Formats::readTags (161) File missing: F:\Music\02 Jazz\Zachary Breaux\1994 Laid Back\Zachary Breaux- Laid Back- 09- Intro.flac

What does file missing mean?


The scanner crashed on the second step; I think it is combining artists if I remember correctly. It stopped on an album called "Greatest Hits." I am having trouble tracking that one down because of how many different versions I have and "Gretest Hits" isn't in the log file.

Here is the bottom of the scanner log file:

[00:43:58.1366] Slim::Formats::readTags (161) File missing: F:\Music\02 Jazz\Zakk Wylde\Book of Shadows\Zakk Wylde- Book of Shadows- 14- peddlers of death.mp3
[00:43:58.1996] Slim::Formats::readTags (161) File missing: C:\Doug\06 Soundtracks\Ultimate Broadway\Zero Mostel- Ultimate Broadway- 22- If I Were a Rich Man [From Fiddler on the Roof].mp3
[00:43:58.5550] Slim::Formats::readTags (161) File missing: C:\Doug\07 Compilations\Body & Soul\Body & Soul\Zhane- Body & Soul- 13- Hey Mr Dj.mp3
[00:43:58.8229] Slim::Formats::readTags (161) File missing: C:\Doug\07 Compilations\Dance Mix USA\3\Zhané- Dance Mix USA- 42- Hey Mr. DJ.mp3
[00:44:00.1336] Slim::Formats::readTags (161) File missing: C:\Doug\07 Compilations\Wedding Classics\Zucchero- Weddings Classics- 005- Senza Una Donna.mp3
[00:44:03.9622] Slim::Formats::readTags (161) File missing: C:\Doug\07 Compilations\Moments of Love\ZZ Top- Moments Of Love- 244- Rough Boy.mp3
[00:44:39.8669] Slim::Schema::Storage::throw_exception (70) Error: Error executing 'SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.musicmagic_mixable, me.musicbrainz_id, me.lossless, me.lyrics, me.replay_gain, me.replay_peak, contributorTracks.role, contributorTracks.contributor, contributorTracks.track FROM tracks me LEFT JOIN contributor_track contributorTracks ON ( contributorTracks.track = me.id ) WHERE ( ( ( contributorTracks.role = ? ) AND ( me.album = ? ) ) ) ORDER BY contributorTracks.track': DBD::mysql::st execute failed: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_240_0.MYD' (Errcode: 13) at C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.
[00:44:39.8674] Slim::Schema::Storage::throw_exception (70) Backtrace:

frame 0: Slim::Utils::Log::logBacktrace (C:/PROGRA~1/SQUEEZ~1/server/Slim/Schema/Storage.pm line 70)
frame 1: Slim::Schema::Storage::throw_exception (C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 773)
frame 2: DBIx::Class::Storage::DBI::_execute (C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 826)
frame 3: DBIx::Class::Storage::DBI::_select (C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 79)
frame 4: DBIx::Class::Storage::DBI::Cursor::next (C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/ResultSet.pm line 701)
frame 5: DBIx::Class::ResultSet::next (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 1378)
frame 6: Slim::Schema::mergeVariousArtistsAlbums (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Music/Import.pm line 382)
frame 7: Slim::Music::Import::runScanPostProcessing (scanner.pl line 225)
frame 8: main::__ANON__ (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Schema.pm line 584)
frame 9: (eval) (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Schema.pm line 572)
frame 10: DBIx::Class::Schema::txn_do (scanner.pl line 225)
frame 11: (eval) (scanner.pl line 225)
frame 12: main::main (scanner.pl line 353)

[00:44:39.8984] Slim::Schema::throw_exception (236) Error: Carp::Clan::__ANON__(): Error executing 'SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.musicmagic_mixable, me.musicbrainz_id, me.lossless, me.lyrics, me.replay_gain, me.replay_peak, contributorTracks.role, contributorTracks.contributor, contributorTracks.track FROM tracks me LEFT JOIN contributor_track contributorTracks ON ( contributorTracks.track = me.id ) WHERE ( ( ( contributorTracks.role = ? ) AND ( me.album = ? ) ) ) ORDER BY contributorTracks.track': DBD::mysql::st execute failed: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_240_0.MYD' (Errcode: 13) at C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.
[00:44:39.8989] Slim::Schema::throw_exception (236) Backtrace:

frame 0: Slim::Utils::Log::logBacktrace (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 236)
frame 1: Slim::Schema::throw_exception (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Schema.pm line 606)
frame 2: DBIx::Class::Schema::txn_do (scanner.pl line 225)
frame 3: (eval) (scanner.pl line 225)
frame 4: main::main (scanner.pl line 353)

Any suggestions?

Thanks,

Doug

Siduhe
2008-09-05, 11:05
This is the most likely issue:


DBD::mysql::st execute failed: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_240_0.MYD' (Errcode: 13) at C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

Set your antivirus program to ignore *.myi or *myd files. These are temp files which SC uses in the scanning process and it is being blocked from writing to them, causing the scan to fail. If your antivirus doesn't allow you to ignore specific extensions, you can usually get around this by setting it to scan documents and programs only.

taconaut
2008-09-16, 23:50
You made my day :) Temporarily deactivating the anti virus software resolved the problem with the same error message as above. Now I have just to find where to set rules for exclusions :)