Scan Terminated Unexpectedly

[DavidFl2]

on Merge. Here's the log:


[09-10-01 10:42:08.1104] Slim::Music::Import::runScanPostProcessing (425) Starting merge of various artists albums
[09-10-01 10:42:17.9642] 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_9d4_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-10-01 10:42:17.9734] 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_9d4_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-10-01 10:42:17.9741] main::main (311) Error: Not updating lastRescanTime!

[snarlydwarf]

on Merge. Here's the log:


[09-10-01 10:42:08.1104] Slim::Music::Import::runScanPostProcessing (425) Starting merge of various artists albums
[09-10-01 10:42:17.9642] 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_9d4_0. MYI' (Errcode: 13)

Mysql could not write to its index file.

This is almost certainly your Antivirus software "helping" (some AV products like scanning every file on open, which gets in the way of MySQL actually using it... mysql gets mad about not being able to create its own file, and aborts).

Convince your AV software to stop scanning MYD and MYI files.. they're not executable anyway.