Ticket #090111-002488

Environment:
Windows XP
Squeezecenter 7.3.1
No Antivirus (uninstalled)
No Security software (uninstalled)

Symptom:

When performing a scan of the music library, scanner hangs on merge various artist

Troubleshooting Steps.

Uninstalled Antivirus
Uninstall Security Software
Performed a clean install of SqueezeCenter 7.3.1
Unchecked "Use Itunes" (customer doesn't use)

Please see log

[09-01-14 18:26:06.6401] Carp::carp (271) Warning: OLE exception from "<Unknown Source>":

The artwork has been deleted.

Win32::OLE(0.1707) error 0xa0040202
    in METHOD/PROPERTYGET "isDownloadedArtwork" at C:/PROGRA~1/SQUEEZ~1/server/Slim/Plugin/iTunes/Importer/Artwork/Win32.pm line 73
[09-01-14 18:26:06.8020] Carp::carp (271) Warning: OLE exception from "<Unknown Source>":

The artwork has been deleted.

Win32::OLE(0.1707) error 0xa0040202
    in METHOD/PROPERTYGET "isDownloadedArtwork" at C:/PROGRA~1/SQUEEZ~1/server/Slim/Plugin/iTunes/Importer/Artwork/Win32.pm line 73
[09-01-14 18:50:52.4745] 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, me.extid, 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_fa4_0.MYI' (Errcode: 17) at /<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 771.
[09-01-14 18:50:52.4758] Slim::Schema::Storage::throw_exception (70) Backtrace:

   frame 0: Slim::Utils::Log::logBacktrace (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema/Storage.pm line 70)
   frame 1: Slim::Schema::Storage::throw_exception (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 773)
   frame 2: DBIx::Class::Storage::DBI::_execute (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 826)
   frame 3: DBIx::Class::Storage::DBI::_select (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI/Cursor.pm line 79)
   frame 4: DBIx::Class::Storage::DBI::Cursor::next (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/ResultSet.pm line 703)
   frame 5: DBIx::Class::ResultSet::next (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 1372)
   frame 6: Slim::Schema::mergeVariousArtistsAlbums (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Music/Import.pm line 375)
   frame 7: Slim::Music::Import::runScanPostProcessing (scanner.pl line 235)
   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 235)
   frame 11: (eval) (scanner.pl line 235)
   frame 12: main::main (scanner.pl line 363)

[09-01-14 18:50:52.4920] Slim::Schema::throw_exception (228) 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, me.extid, 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_fa4_0.MYI' (Errcode: 17) at /<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 771.
[09-01-14 18:50:52.4928] Slim::Schema::throw_exception (228) Backtrace:

   frame 0: Slim::Utils::Log::logBacktrace (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 228)
   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 235)
   frame 3: (eval) (scanner.pl line 235)
   frame 4: main::main (scanner.pl line 363)
 
I am in the process of asking the customer to try SqueezeCenter 7.3.2, and will let you know if this fixes the issue.