Home of the Squeezebox™ & Transporter® network music players.
Results 1 to 4 of 4
  1. #1
    Senior Member
    Join Date
    Jul 2008
    Posts
    677

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

    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:BI::_execute (C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 826)
    frame 3: DBIx::Class::Storage:BI::_select (C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 79)
    frame 4: DBIx::Class::Storage:BI::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)

  2. #2
    Senior Member Siduhe's Avatar
    Join Date
    Jun 2005
    Location
    deepest, darkest, south-east London
    Posts
    3,238
    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?
    Who am I on LAST.FM?
    "Siduhe Loved Tracks radio got the thumbs up. Feedback included: yeah, it's good... got the odd dodgy track tho..." (c) ModelCitizen

  3. #3
    Senior Member
    Join Date
    Jul 2008
    Posts
    677
    Thanks Siduhe,

    I'm using Avast Antivirus 4.8.1229

  4. #4
    Senior Member Siduhe's Avatar
    Join Date
    Jun 2005
    Location
    deepest, darkest, south-east London
    Posts
    3,238
    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!
    Who am I on LAST.FM?
    "Siduhe Loved Tracks radio got the thumbs up. Feedback included: yeah, it's good... got the odd dodgy track tho..." (c) ModelCitizen

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •