PDA

View Full Version : SqueezeCenter 7.2 Scanner Problem



brucegrr
2008-09-11, 18:38
I am using Squeeze Center 7.2 on a WIndows XP machine. Squeezebox 3, hardwired.SuperDateTime the only extra plugin I am using.

When I do a look for new/changed music scan it seems the scan does not complete (see attached jpg)It says it is finished but it isn't.

In the scanner log:

[08-09-11 21:24:41.9112] 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 'E:\WINDOWS\TEMP\#sql_728_0.MYI' (Errcode: 17) at E:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.
[08-09-11 21:24:41.9119] Slim::Schema::Storage::throw_exception (70) Backtrace:

frame 0: Slim::Utils::Log::logBacktrace (E:/PROGRA~1/SQUEEZ~1/server/Slim/Schema/Storage.pm line 70)
frame 1: Slim::Schema::Storage::throw_exception (E:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 773)
frame 2: DBIx::Class::Storage::DBI::_execute (E:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 826)
frame 3: DBIx::Class::Storage::DBI::_select (E:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 79)
frame 4: DBIx::Class::Storage::DBI::Cursor::next (E:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/ResultSet.pm line 701)
frame 5: DBIx::Class::ResultSet::next (/<E:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 1378)
frame 6: Slim::Schema::mergeVariousArtistsAlbums (/<E:\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__ (/<E:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Schema.pm line 584)
frame 9: (eval) (/<E:\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)

[08-09-11 21:24:41.9132] 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 'E:\WINDOWS\TEMP\#sql_728_0.MYI' (Errcode: 17) at E:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.
[08-09-11 21:24:41.9136] Slim::Schema::throw_exception (236) Backtrace:

frame 0: Slim::Utils::Log::logBacktrace (/<E:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 236)
frame 1: Slim::Schema::throw_exception (/<E:\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)

Suggestions on how to fix this?

brucegrr
2008-09-11, 19:08
It seems Comodo's Defense+ is the problem. If I disable it the scan works fine. I am now trying to figure out how to "fix" it.

radish
2008-09-11, 19:30
st execute failed: Can't create/write to file 'E:\WINDOWS\TEMP\#sql_728_0.MYI

That's the problem. You need to set your antivirus to exclude *.MYI files from scanning.

brucegrr
2008-09-11, 19:44
SO far I have not found anything in Defense+ that allows for a per file setting.

I am going to uninstall the Defense+ part of the Comodo firewall. I know THAT will fix it. :)

Thanks for your help

Bruce

MrSinatra
2008-09-11, 22:44
can't u exempt file types?

if not, try avast. its free.

brucegrr
2008-09-12, 07:00
I finally uninstalled Comodo..........too many other products out there to use.

Thanks for the help

Bruce