PDA

View Full Version : Getting there RE: Scanning music library.....but cant merge Various Artists



Gazjam
2008-10-03, 08:10
As title,
I deleted a couple of "rogue" mp3's and I could scan my library (Wha-hey!) but I still have a wee problem

please see log below.
Thanks.

-----------------------------------------
[08-10-03 16:07:19.4821] Slim::Music::Import::runScanPostProcessing (378) Starting mergeVariousArtistsAlbums().
[08-10-03 16:07:24.6652] 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_d78_0.MYI' (Errcode: 17) at C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.
[08-10-03 16:07:24.6657] 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 1380)
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)

[08-10-03 16:07:24.6668] 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_d78_0.MYI' (Errcode: 17) at C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.
[08-10-03 16:07:24.6671] 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)

Siduhe
2008-10-03, 08:55
Can't create/write to file 'C:\WINDOWS\TEMP\#sql_d78_0.MYI' (Errcode: 17)

That's your problem. Your antivirus program isn't letting SC write to temporary files during the scanning process. Add a specific exception for squeezecenter.exe and scanner.exe and that should sort the problem out. What antivirus are you using?

Gazjam
2008-10-03, 12:09
Thanks Siduhe,

I'm using Avast Antivirus 4.8.1229

Siduhe
2008-10-03, 16:44
Don't know Avant that well, but it's supposed to be pretty configurable, so you should be able to add an exception by editing the Exclusion list. Let us know if you run into any more problems - hopefully this will sort you out for a bit!