First Last Prev Next    This bug is not in your last search results.
Bug 13849 - "music scan terminated unexpectedly (Merge Various Artists)"
: "music scan terminated unexpectedly (Merge Various Artists)"
Status: NEW
Product: Logitech Media Server
Classification: Unclassified
Component: Scanner
: 7.4.0
: PC Windows 7
: P3 normal with 3 votes (vote)
: 8.0.1
Assigned To: Andy Grundman
:
Depends on:
Blocks:
  Show dependency tree / graph
 
Reported: 2009-09-04 08:26 UTC by Chris Tashjian
Modified: 2011-08-16 08:16 UTC (History)
5 users (show)

See Also:
Category: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Chris Tashjian 2009-09-04 08:26:34 UTC 
I noticed that I had no artists in my library anymore (been running the 7.4 nightly builds).  I upgraded to 28429 and did a clear & rescan.  I have artists in my library now, but when it was done I got a "music scan terminated unexpectedly (Merge Various Artists)" error.  I checked the logs and see:

main::main (310) Error: Failed when running scan post-process: [Carp::Clan::__ANON__(): Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::st execute failed: Can't create/write to file 'C:\ProgramData\Squeezebox\Cache\MySQL\#sql_948_0.MYD' (Errcode: 13) [for Statement "SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.primary_artist, 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"] at /<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Schema/Storage.pm line 86
]
main::main (311) Error: Not updating lastRescanTime!
Comment 1 Ross Levine 2009-09-04 16:20:15 UTC 
Andy is there anything helpful in this log? Do you need anything from QA for this bug?
Comment 2 Chris Tashjian 2009-09-30 03:22:50 UTC 
Got this again with 7.4.1 r28676 --

Slim::Music::Import::runScanPostProcessing (425) Starting merge of various artists albums
Slim::Schema::Storage::throw_exception (82) Error: DBI Exception: DBD::mysql::st execute failed: Can't create/write to file 'C:\ProgramData\Squeezebox\Cache\MySQL\#sql_183c_0.MYD' (Errcode: 13) [for Statement "SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.primary_artist, 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"]
Slim::Schema::Storage::throw_exception (82) Backtrace:

   frame 0: Slim::Utils::Log::logBacktrace (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Schema/Storage.pm line 82)
   frame 1: Slim::Schema::Storage::throw_exception (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 957)
   frame 2: DBIx::Class::Storage::DBI::__ANON__ (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 1217)
   frame 3: DBIx::Class::Storage::DBI::_dbh_execute (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 532)
   frame 4: DBIx::Class::Storage::DBI::dbh_do (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 1227)
   frame 5: DBIx::Class::Storage::DBI::_execute (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 1451)
   frame 6: DBIx::Class::Storage::DBI::_select (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI/Cursor.pm line 82)
   frame 7: DBIx::Class::Storage::DBI::Cursor::_dbh_next (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 547)
   frame 8: (eval) (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 540)
   frame 9: DBIx::Class::Storage::DBI::dbh_do (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI/Cursor.pm line 101)
   frame 10: DBIx::Class::Storage::DBI::Cursor::next (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>DBIx/Class/ResultSet.pm line 953)
   frame 11: DBIx::Class::ResultSet::next (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 1496)
   frame 12: Slim::Schema::mergeSingleVAAlbum (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 1457)
   frame 13: Slim::Schema::mergeVariousArtistsAlbums (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Music/Import.pm line 429)
   frame 14: Slim::Music::Import::runScanPostProcessing (scanner.pl line 306)
   frame 15: (eval) (scanner.pl line 306)
   frame 16: main::main (scanner.pl line 439)

Slim::Schema::Storage::throw_exception (82) Error: Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::st execute failed: Can't create/write to file 'C:\ProgramData\Squeezebox\Cache\MySQL\#sql_183c_0.MYD' (Errcode: 13) [for Statement "SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.primary_artist, 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"] at /<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Schema/Storage.pm line 86
Slim::Schema::Storage::throw_exception (82) Backtrace:

   frame 0: Slim::Utils::Log::logBacktrace (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Schema/Storage.pm line 82)
   frame 1: Slim::Schema::Storage::throw_exception (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 562)
   frame 2: DBIx::Class::Storage::DBI::dbh_do (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI/Cursor.pm line 101)
   frame 3: DBIx::Class::Storage::DBI::Cursor::next (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>DBIx/Class/ResultSet.pm line 953)
   frame 4: DBIx::Class::ResultSet::next (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 1496)
   frame 5: Slim::Schema::mergeSingleVAAlbum (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 1457)
   frame 6: Slim::Schema::mergeVariousArtistsAlbums (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Music/Import.pm line 429)
   frame 7: Slim::Music::Import::runScanPostProcessing (scanner.pl line 306)
   frame 8: (eval) (scanner.pl line 306)
   frame 9: main::main (scanner.pl line 439)

main::main (310) Error: Failed when running scan post-process: [Carp::Clan::__ANON__(): Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::st execute failed: Can't create/write to file 'C:\ProgramData\Squeezebox\Cache\MySQL\#sql_183c_0.MYD' (Errcode: 13) [for Statement "SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.primary_artist, 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"] at /<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Schema/Storage.pm line 86
]
main::main (311) Error: Not updating lastRescanTime!
Comment 3 hansuelik1 2009-12-27 17:33:45 UTC 
Andy, I guess this is the same error during scan. See below

[09-12-27 19:30:16.4687] main::main (184) Starting Squeezebox Server scanner (v7.4.1, r28947, Tue Oct 20 08:13:15 PDT 2009) perl 5.010000
[09-12-27 19:30:17.5474] Slim::Music::Import::runImporter (567) Starting Slim::Music::MusicFolderScan scan
[09-12-27 19:30:35.2345] Slim::Music::Import::endImporter (701) Completed Slim::Music::MusicFolderScan Scan in 17 seconds.
[09-12-27 19:30:35.2374] Slim::Music::Import::runImporter (567) Starting Slim::Music::PlaylistFolderScan scan
[09-12-27 19:30:35.2976] Slim::Music::Import::runImporter (567) Starting Slim::Plugin::iTunes::Importer scan
[09-12-27 19:30:35.3584] Slim::Music::Import::endImporter (701) Completed Slim::Plugin::iTunes::Importer Scan in 0 seconds.
[09-12-27 19:30:35.3622] Slim::Music::Import::runScanPostProcessing (430) Starting merge of various artists albums
[09-12-27 19:30:43.0312] Slim::Schema::Storage::throw_exception (82) Error: DBI Exception: DBD::mysql::st execute failed: Can't create/write to file 'C:\Documents and Settings\All Users\Application Data\Squeezebox\Cache\MySQL\#sql_9e4_0.MYI' (Errcode: 13) [for Statement "SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.primary_artist, 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"]
[09-12-27 19:30:43.0322] Slim::Schema::Storage::throw_exception (82) Backtrace:

   frame 0: Slim::Utils::Log::logBacktrace (/<C:\PROGRA~1\SQUEEZ~2\server\scanner.exe>Slim/Schema/Storage.pm line 82)
   frame 1: Slim::Schema::Storage::throw_exception (/<C:\PROGRA~1\SQUEEZ~2\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 957)
   frame 2: DBIx::Class::Storage::DBI::__ANON__ (/<C:\PROGRA~1\SQUEEZ~2\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 1217)
   frame 3: DBIx::Class::Storage::DBI::_dbh_execute (/<C:\PROGRA~1\SQUEEZ~2\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 532)
   frame 4: DBIx::Class::Storage::DBI::dbh_do (/<C:\PROGRA~1\SQUEEZ~2\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 1227)
   frame 5: DBIx::Class::Storage::DBI::_execute (/<C:\PROGRA~1\SQUEEZ~2\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 1451)
   frame 6: DBIx::Class::Storage::DBI::_select (/<C:\PROGRA~1\SQUEEZ~2\server\scanner.exe>DBIx/Class/Storage/DBI/Cursor.pm line 82)
   frame 7: DBIx::Class::Storage::DBI::Cursor::_dbh_next (/<C:\PROGRA~1\SQUEEZ~2\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 547)
   frame 8: (eval) (/<C:\PROGRA~1\SQUEEZ~2\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 540)
   frame 9: DBIx::Class::Storage::DBI::dbh_do (/<C:\PROGRA~1\SQUEEZ~2\server\scanner.exe>DBIx/Class/Storage/DBI/Cursor.pm line 101)
   frame 10: DBIx::Class::Storage::DBI::Cursor::next (/<C:\PROGRA~1\SQUEEZ~2\server\scanner.exe>DBIx/Class/ResultSet.pm line 953)
   frame 11: DBIx::Class::ResultSet::next (/<C:\PROGRA~1\SQUEEZ~2\server\scanner.exe>Slim/Schema.pm line 1496)
   frame 12: Slim::Schema::mergeSingleVAAlbum (/<C:\PROGRA~1\SQUEEZ~2\server\scanner.exe>Slim/Schema.pm line 1457)
   frame 13: Slim::Schema::mergeVariousArtistsAlbums (/<C:\PROGRA~1\SQUEEZ~2\server\scanner.exe>Slim/Music/Import.pm line 434)
   frame 14: Slim::Music::Import::runScanPostProcessing (scanner.pl line 306)
   frame 15: (eval) (scanner.pl line 306)
   frame 16: main::main (scanner.pl line 439)

[09-12-27 19:30:43.0418] Slim::Schema::Storage::throw_exception (82) Error: Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::st execute failed: Can't create/write to file 'C:\Documents and Settings\All Users\Application Data\Squeezebox\Cache\MySQL\#sql_9e4_0.MYI' (Errcode: 13) [for Statement "SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.primary_artist, 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"] at /<C:\PROGRA~1\SQUEEZ~2\server\scanner.exe>Slim/Schema/Storage.pm line 86
[09-12-27 19:30:43.0427] Slim::Schema::Storage::throw_exception (82) Backtrace:

   frame 0: Slim::Utils::Log::logBacktrace (/<C:\PROGRA~1\SQUEEZ~2\server\scanner.exe>Slim/Schema/Storage.pm line 82)
   frame 1: Slim::Schema::Storage::throw_exception (/<C:\PROGRA~1\SQUEEZ~2\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 562)
   frame 2: DBIx::Class::Storage::DBI::dbh_do (/<C:\PROGRA~1\SQUEEZ~2\server\scanner.exe>DBIx/Class/Storage/DBI/Cursor.pm line 101)
   frame 3: DBIx::Class::Storage::DBI::Cursor::next (/<C:\PROGRA~1\SQUEEZ~2\server\scanner.exe>DBIx/Class/ResultSet.pm line 953)
   frame 4: DBIx::Class::ResultSet::next (/<C:\PROGRA~1\SQUEEZ~2\server\scanner.exe>Slim/Schema.pm line 1496)
   frame 5: Slim::Schema::mergeSingleVAAlbum (/<C:\PROGRA~1\SQUEEZ~2\server\scanner.exe>Slim/Schema.pm line 1457)
   frame 6: Slim::Schema::mergeVariousArtistsAlbums (/<C:\PROGRA~1\SQUEEZ~2\server\scanner.exe>Slim/Music/Import.pm line 434)
   frame 7: Slim::Music::Import::runScanPostProcessing (scanner.pl line 306)
   frame 8: (eval) (scanner.pl line 306)
   frame 9: main::main (scanner.pl line 439)

[09-12-27 19:30:43.0470] main::main (310) Error: Failed when running scan post-process: [Carp::Clan::__ANON__(): Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::st execute failed: Can't create/write to file 'C:\Documents and Settings\All Users\Application Data\Squeezebox\Cache\MySQL\#sql_9e4_0.MYI' (Errcode: 13) [for Statement "SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.primary_artist, 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"] at /<C:\PROGRA~1\SQUEEZ~2\server\scanner.exe>Slim/Schema/Storage.pm line 86
]
[09-12-27 19:30:43.0481] main::main (311) Error: Not updating lastRescanTime!
Comment 4 Andy Grundman 2009-12-27 17:42:13 UTC 
That error is because your virus scanner is blocking access to the MySQL temp file.
Comment 5 Michael Sundberg 2011-04-18 10:01:16 UTC 
I am getting the same error.  Just upgraded: Version: 7.5.4 - r32171 @ Thu Apr 14 09:19:34 PDT 2011
But not new to this version. I was getting it on the previous version as well.
I tried removing the album where the error occurred, and that looked like it resolved the problem on rescan, but a complete fresh scan resulted in the error again, but at a different album.
[11-04-18 12:38:41.6738] Slim::Schema::Storage::throw_exception (82) Error: Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::st execute failed: Can't create/write to file 'C:\Documents and Settings\All Users\Application Data\Squeezebox\Cache\MySQL\#sql_2a0_0.MYI' (Errcode: 13) [for Statement "SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.primary_artist, 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"] at /<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema/Storage.pm line 86
Comment 6 Michael Sundberg 2011-04-18 10:04:29 UTC 
I only have MS Security Essentials running.  Is that interfering?
Comment 7 Michael Sundberg 2011-04-18 10:21:59 UTC 
(In reply to comment #6)
> I only have MS Security Essentials running.  Is that interfering?
Confirmed: I disabled Security Essentials and rescanned.  The error did not repeat.
Comment 8 Brian Gregory [UK] 2011-07-03 16:12:21 UTC 
Excluding "C:\Documents and Settings\All Users\Application
Data\Squeezebox\Cache\MySQL" in settings / excluded files and locations in my Microsoft Security Essentials has proved to be a reasonable work around for me.

(That directory is correct for my Windows XP PC. Go to the SqueezeBox Server Settings web page to find where the cache folder is on your server PC and add \MySQL to the end of what you find)
Comment 9 Till 2011-08-16 07:33:48 UTC 
Try if this bug still shows with v7.6
Comment 10 Brian Gregory [UK] 2011-08-16 08:16:53 UTC 
(In reply to comment #9)
> Try if this bug still shows with v7.6

No, for me at least, V7.6 fixes it.
I can remove the exclude I put in my AV program as a work around and the scan still completes okay.

Thanks.
First Last Prev Next    This bug is not in your last search results.