Bug 10329 – Scanner crashed: Can't create/write to temp MySQL file

Bug 10329 - Scanner crashed: Can't create/write to temp MySQL file

Summary:

Scanner crashed: Can't create/write to temp MySQL file

Status:	CLOSED INVALID

Product:	Logitech Media Server
Classification:	Unclassified
Component:	Scanner
Version:	7.3.0
Platform:	PC Windows XP

Importance:	-- normal (vote)
Target Milestone:	---
Assigned To:	James Richardson

URL:
Keywords:

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2008-12-14 18:14 UTC by Edmund Teng
Modified:	2012-02-27 17:19 UTC (History)
CC List:	4 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 Edmund Teng 2008-12-14 18:14:54 UTC

Installed the new SC v7.3 after doing a clean uninstall of the previous version and making sure that cache had been cleared.  The server.log and scanner.log were also cleared.

After installing SC v7.3, scanning started based on profile: Clear library and rescan everything.  However, scanning stopped during the Merging Various Artists step.  I've included the details of the scanner.log and server.log, for your reference.  Let me know if you need any other information or want me to do other tests.


************************
Under Music Scan Details
************************
Directory Scan   (9114  of  9114)   Complete  00:08:15
Playlist Scan   (  of  )   Complete  00:00:10
Merge Various Artists   (208  of  622)   Running  00:24:19

Shostakovich / Tchaikovsky: Trio for Piano, Violin And Cello (Cello: Mischa Maisky, Piano: Martha Argerich, Violin: Gidon Kremer)
SqueezeCenter has finished scanning your music collection. Total Time:00:32:34
 

***************************
Details of the scanner.log:
***************************

[08-12-15 09:44:48.2731] 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_10c0_0.MYD' (Errcode: 17) at /<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 771.
[08-12-15 09:44:48.2838] 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)

[08-12-15 09:44:48.3406] 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_10c0_0.MYD' (Errcode: 17) at /<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 771.
[08-12-15 09:44:48.3411] 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)


**************************
Details of the server.log:
**************************

[08-12-15 09:35:53.9688] Slim::Schema::init (153) Warning: Creating new database - empty database or database from 6.3.x found
[08-12-15 09:36:12.2190] main::checkDataSource (909) Warning: Schema updated or no tracks in the database, initiating scan.
[08-12-15 09:44:52.9064] Slim::Schema::Storage::throw_exception (70) Error: Error executing 'SELECT me.id, me.artwork, me.title, contributor.name, contributor.namesort, me.titlesort, me.musicmagic_mixable, me.disc, me.discc FROM albums me  JOIN contributors contributor ON ( contributor.id = me.contributor ) GROUP BY me.id, me.artwork, me.title, contributor.name, contributor.namesort, me.titlesort, me.musicmagic_mixable, me.disc, me.discc ORDER BY concat('0', contributor.namesort),concat('0', me.titlesort),me.disc LIMIT 661': DBD::mysql::st execute failed: Can't create/write to file 'C:\windows\TEMP\#sql_10c0_0.MYD' (Errcode: 17) at /<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI.pm line 771.
[08-12-15 09:44:52.9069] Slim::Schema::Storage::throw_exception (70) Backtrace:

   frame 0: Slim::Utils::Log::logBacktrace (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Schema/Storage.pm line 70)
   frame 1: Slim::Schema::Storage::throw_exception (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI.pm line 773)
   frame 2: DBIx::Class::Storage::DBI::_execute (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI.pm line 826)
   frame 3: DBIx::Class::Storage::DBI::_select (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI/Cursor.pm line 79)
   frame 4: DBIx::Class::Storage::DBI::Cursor::next (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Cursor.pm line 69)
   frame 5: DBIx::Class::Cursor::all (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI/Cursor.pm line 115)
   frame 6: DBIx::Class::Storage::DBI::Cursor::all (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/ResultSet.pm line 947)
   frame 7: DBIx::Class::ResultSet::all (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/ResultSet.pm line 143)
   frame 8: DBIx::Class::ResultSet::search (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/ResultSet.pm line 661)
   frame 9: DBIx::Class::ResultSet::slice (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Queries.pm line 485)
   frame 10: Slim::Control::Queries::albumsQuery (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 1885)
   frame 11: (eval) (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 1885)
   frame 12: Slim::Control::Request::execute (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 867)
   frame 13: Slim::Control::Request::executeRequest (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Jive.pm line 172)
   frame 14: Slim::Control::Jive::buildCaches (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 2070)
   frame 15: (eval) (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 2070)
   frame 16: Slim::Control::Request::notify (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 846)
   frame 17: Slim::Control::Request::checkNotifications (slimserver.pl line 520)
   frame 18: main::idle (slimserver.pl line 486)
   frame 19: main::main (slimserver.pl line 88)
   frame 20: PerlSvc::Interactive (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>PerlSvc.pm line 99)
   frame 21: PerlSvc::_interactive (slimserver.pl line 0)
   frame 22: (eval) (slimserver.pl line 0)

[08-12-15 09:44:52.9073] Slim::Control::Request::execute (1889) Error: While trying to run function coderef [Slim::Control::Queries::albumsQuery]: [Carp::Clan::__ANON__(): Error executing 'SELECT me.id, me.artwork, me.title, contributor.name, contributor.namesort, me.titlesort, me.musicmagic_mixable, me.disc, me.discc FROM albums me  JOIN contributors contributor ON ( contributor.id = me.contributor ) GROUP BY me.id, me.artwork, me.title, contributor.name, contributor.namesort, me.titlesort, me.musicmagic_mixable, me.disc, me.discc ORDER BY concat('0', contributor.namesort),concat('0', me.titlesort),me.disc LIMIT 661': DBD::mysql::st execute failed: Can't create/write to file 'C:\windows\TEMP\#sql_10c0_0.MYD' (Errcode: 17) at /<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI.pm line 771.
]
[08-12-15 09:44:53.0019] Slim::Schema::Storage::throw_exception (70) Error: Error executing 'SELECT me.id, me.name, me.namesort, me.musicmagic_mixable, me.namesearch, me.musicbrainz_id FROM contributors me LEFT JOIN contributor_album contributorAlbums ON ( contributorAlbums.contributor = me.id )  JOIN albums album ON ( album.id = contributorAlbums.album ) WHERE ( ( ( ( ( album.compilation IS NULL ) OR ( album.compilation = ? ) ) AND contributorAlbums.role IN ( ?, ?, ? ) ) ) ) GROUP BY me.id ORDER BY me.namesort LIMIT 325': DBD::mysql::st execute failed: Can't create/write to file 'C:\windows\TEMP\#sql_10c0_0.MYD' (Errcode: 17) at /<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI.pm line 771.
[08-12-15 09:44:53.0024] Slim::Schema::Storage::throw_exception (70) Backtrace:

   frame 0: Slim::Utils::Log::logBacktrace (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Schema/Storage.pm line 70)
   frame 1: Slim::Schema::Storage::throw_exception (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI.pm line 773)
   frame 2: DBIx::Class::Storage::DBI::_execute (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI.pm line 826)
   frame 3: DBIx::Class::Storage::DBI::_select (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI/Cursor.pm line 79)
   frame 4: DBIx::Class::Storage::DBI::Cursor::next (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Cursor.pm line 69)
   frame 5: DBIx::Class::Cursor::all (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI/Cursor.pm line 115)
   frame 6: DBIx::Class::Storage::DBI::Cursor::all (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/ResultSet.pm line 947)
   frame 7: DBIx::Class::ResultSet::all (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/ResultSet.pm line 143)
   frame 8: DBIx::Class::ResultSet::search (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/ResultSet.pm line 661)
   frame 9: DBIx::Class::ResultSet::slice (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Queries.pm line 844)
   frame 10: Slim::Control::Queries::artistsQuery (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 1885)
   frame 11: (eval) (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 1885)
   frame 12: Slim::Control::Request::execute (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 867)
   frame 13: Slim::Control::Request::executeRequest (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Jive.pm line 180)
   frame 14: Slim::Control::Jive::buildCaches (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 2070)
   frame 15: (eval) (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 2070)
   frame 16: Slim::Control::Request::notify (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 846)
   frame 17: Slim::Control::Request::checkNotifications (slimserver.pl line 520)
   frame 18: main::idle (slimserver.pl line 486)
   frame 19: main::main (slimserver.pl line 88)
   frame 20: PerlSvc::Interactive (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>PerlSvc.pm line 99)
   frame 21: PerlSvc::_interactive (slimserver.pl line 0)
   frame 22: (eval) (slimserver.pl line 0)

[08-12-15 09:44:53.0028] Slim::Control::Request::execute (1889) Error: While trying to run function coderef [Slim::Control::Queries::artistsQuery]: [Carp::Clan::__ANON__(): Error executing 'SELECT me.id, me.name, me.namesort, me.musicmagic_mixable, me.namesearch, me.musicbrainz_id FROM contributors me LEFT JOIN contributor_album contributorAlbums ON ( contributorAlbums.contributor = me.id )  JOIN albums album ON ( album.id = contributorAlbums.album ) WHERE ( ( ( ( ( album.compilation IS NULL ) OR ( album.compilation = ? ) ) AND contributorAlbums.role IN ( ?, ?, ? ) ) ) ) GROUP BY me.id ORDER BY me.namesort LIMIT 325': DBD::mysql::st execute failed: Can't create/write to file 'C:\windows\TEMP\#sql_10c0_0.MYD' (Errcode: 17) at /<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI.pm line 771.
]
[08-12-15 09:44:53.0135] Slim::Schema::Storage::throw_exception (70) Error: Error executing 'SELECT me.id, me.name, me.namesort, me.namesearch, me.musicmagic_mixable FROM genres me GROUP BY me.id, me.name, me.namesort, me.namesearch, me.musicmagic_mixable ORDER BY me.namesort LIMIT 36': DBD::mysql::st execute failed: Can't create/write to file 'C:\windows\TEMP\#sql_10c0_0.MYD' (Errcode: 17) at /<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI.pm line 771.
[08-12-15 09:44:53.0140] Slim::Schema::Storage::throw_exception (70) Backtrace:

   frame 0: Slim::Utils::Log::logBacktrace (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Schema/Storage.pm line 70)
   frame 1: Slim::Schema::Storage::throw_exception (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI.pm line 773)
   frame 2: DBIx::Class::Storage::DBI::_execute (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI.pm line 826)
   frame 3: DBIx::Class::Storage::DBI::_select (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI/Cursor.pm line 79)
   frame 4: DBIx::Class::Storage::DBI::Cursor::next (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Cursor.pm line 69)
   frame 5: DBIx::Class::Cursor::all (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI/Cursor.pm line 115)
   frame 6: DBIx::Class::Storage::DBI::Cursor::all (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/ResultSet.pm line 947)
   frame 7: DBIx::Class::ResultSet::all (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/ResultSet.pm line 143)
   frame 8: DBIx::Class::ResultSet::search (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/ResultSet.pm line 661)
   frame 9: DBIx::Class::ResultSet::slice (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Queries.pm line 1453)
   frame 10: Slim::Control::Queries::genresQuery (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 1885)
   frame 11: (eval) (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 1885)
   frame 12: Slim::Control::Request::execute (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 867)
   frame 13: Slim::Control::Request::executeRequest (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Jive.pm line 186)
   frame 14: Slim::Control::Jive::buildCaches (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 2070)
   frame 15: (eval) (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 2070)
   frame 16: Slim::Control::Request::notify (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 846)
   frame 17: Slim::Control::Request::checkNotifications (slimserver.pl line 520)
   frame 18: main::idle (slimserver.pl line 486)
   frame 19: main::main (slimserver.pl line 88)
   frame 20: PerlSvc::Interactive (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>PerlSvc.pm line 99)
   frame 21: PerlSvc::_interactive (slimserver.pl line 0)
   frame 22: (eval) (slimserver.pl line 0)

[08-12-15 09:44:53.0143] Slim::Control::Request::execute (1889) Error: While trying to run function coderef [Slim::Control::Queries::genresQuery]: [Carp::Clan::__ANON__(): Error executing 'SELECT me.id, me.name, me.namesort, me.namesearch, me.musicmagic_mixable FROM genres me GROUP BY me.id, me.name, me.namesort, me.namesearch, me.musicmagic_mixable ORDER BY me.namesort LIMIT 36': DBD::mysql::st execute failed: Can't create/write to file 'C:\windows\TEMP\#sql_10c0_0.MYD' (Errcode: 17) at /<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI.pm line 771.
]
[08-12-15 09:44:53.0276] Slim::Schema::Storage::throw_exception (70) Error: Error executing 'SELECT me.id, me.artwork, me.title, contributor.name, contributor.namesort, me.titlesort, me.musicmagic_mixable, me.disc, me.discc FROM albums me  JOIN contributors contributor ON ( contributor.id = me.contributor ) GROUP BY me.id, me.artwork, me.title, contributor.name, contributor.namesort, me.titlesort, me.musicmagic_mixable, me.disc, me.discc ORDER BY concat('0', contributor.namesort),concat('0', me.titlesort),me.disc LIMIT 661': DBD::mysql::st execute failed: Can't create/write to file 'C:\windows\TEMP\#sql_10c0_0.MYD' (Errcode: 17) at /<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI.pm line 771.
[08-12-15 09:44:53.0280] Slim::Schema::Storage::throw_exception (70) Backtrace:

   frame 0: Slim::Utils::Log::logBacktrace (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Schema/Storage.pm line 70)
   frame 1: Slim::Schema::Storage::throw_exception (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI.pm line 773)
   frame 2: DBIx::Class::Storage::DBI::_execute (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI.pm line 826)
   frame 3: DBIx::Class::Storage::DBI::_select (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI/Cursor.pm line 79)
   frame 4: DBIx::Class::Storage::DBI::Cursor::next (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Cursor.pm line 69)
   frame 5: DBIx::Class::Cursor::all (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI/Cursor.pm line 115)
   frame 6: DBIx::Class::Storage::DBI::Cursor::all (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/ResultSet.pm line 947)
   frame 7: DBIx::Class::ResultSet::all (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/ResultSet.pm line 143)
   frame 8: DBIx::Class::ResultSet::search (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/ResultSet.pm line 661)
   frame 9: DBIx::Class::ResultSet::slice (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Queries.pm line 485)
   frame 10: Slim::Control::Queries::albumsQuery (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 1885)
   frame 11: (eval) (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 1885)
   frame 12: Slim::Control::Request::execute (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 867)
   frame 13: Slim::Control::Request::executeRequest (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Jive.pm line 172)
   frame 14: Slim::Control::Jive::buildCaches (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 2070)
   frame 15: (eval) (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 2070)
   frame 16: Slim::Control::Request::notify (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 846)
   frame 17: Slim::Control::Request::checkNotifications (slimserver.pl line 520)
   frame 18: main::idle (slimserver.pl line 486)
   frame 19: main::main (slimserver.pl line 88)
   frame 20: PerlSvc::Interactive (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>PerlSvc.pm line 99)
   frame 21: PerlSvc::_interactive (slimserver.pl line 0)
   frame 22: (eval) (slimserver.pl line 0)

[08-12-15 09:44:53.0284] Slim::Control::Request::execute (1889) Error: While trying to run function coderef [Slim::Control::Queries::albumsQuery]: [Carp::Clan::__ANON__(): Error executing 'SELECT me.id, me.artwork, me.title, contributor.name, contributor.namesort, me.titlesort, me.musicmagic_mixable, me.disc, me.discc FROM albums me  JOIN contributors contributor ON ( contributor.id = me.contributor ) GROUP BY me.id, me.artwork, me.title, contributor.name, contributor.namesort, me.titlesort, me.musicmagic_mixable, me.disc, me.discc ORDER BY concat('0', contributor.namesort),concat('0', me.titlesort),me.disc LIMIT 661': DBD::mysql::st execute failed: Can't create/write to file 'C:\windows\TEMP\#sql_10c0_0.MYD' (Errcode: 17) at /<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI.pm line 771.
]
[08-12-15 09:44:53.0506] Slim::Schema::Storage::throw_exception (70) Error: Error executing 'SELECT me.id, me.name, me.namesort, me.musicmagic_mixable, me.namesearch, me.musicbrainz_id FROM contributors me LEFT JOIN contributor_album contributorAlbums ON ( contributorAlbums.contributor = me.id )  JOIN albums album ON ( album.id = contributorAlbums.album ) WHERE ( ( ( ( ( album.compilation IS NULL ) OR ( album.compilation = ? ) ) AND contributorAlbums.role IN ( ?, ?, ? ) ) ) ) GROUP BY me.id ORDER BY me.namesort LIMIT 325': DBD::mysql::st execute failed: Can't create/write to file 'C:\windows\TEMP\#sql_10c0_0.MYD' (Errcode: 17) at /<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI.pm line 771.
[08-12-15 09:44:53.0511] Slim::Schema::Storage::throw_exception (70) Backtrace:

   frame 0: Slim::Utils::Log::logBacktrace (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Schema/Storage.pm line 70)
   frame 1: Slim::Schema::Storage::throw_exception (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI.pm line 773)
   frame 2: DBIx::Class::Storage::DBI::_execute (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI.pm line 826)
   frame 3: DBIx::Class::Storage::DBI::_select (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI/Cursor.pm line 79)
   frame 4: DBIx::Class::Storage::DBI::Cursor::next (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Cursor.pm line 69)
   frame 5: DBIx::Class::Cursor::all (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI/Cursor.pm line 115)
   frame 6: DBIx::Class::Storage::DBI::Cursor::all (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/ResultSet.pm line 947)
   frame 7: DBIx::Class::ResultSet::all (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/ResultSet.pm line 143)
   frame 8: DBIx::Class::ResultSet::search (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/ResultSet.pm line 661)
   frame 9: DBIx::Class::ResultSet::slice (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Queries.pm line 844)
   frame 10: Slim::Control::Queries::artistsQuery (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 1885)
   frame 11: (eval) (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 1885)
   frame 12: Slim::Control::Request::execute (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 867)
   frame 13: Slim::Control::Request::executeRequest (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Jive.pm line 180)
   frame 14: Slim::Control::Jive::buildCaches (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 2070)
   frame 15: (eval) (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 2070)
   frame 16: Slim::Control::Request::notify (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 846)
   frame 17: Slim::Control::Request::checkNotifications (slimserver.pl line 520)
   frame 18: main::idle (slimserver.pl line 486)
   frame 19: main::main (slimserver.pl line 88)
   frame 20: PerlSvc::Interactive (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>PerlSvc.pm line 99)
   frame 21: PerlSvc::_interactive (slimserver.pl line 0)
   frame 22: (eval) (slimserver.pl line 0)

[08-12-15 09:44:53.0515] Slim::Control::Request::execute (1889) Error: While trying to run function coderef [Slim::Control::Queries::artistsQuery]: [Carp::Clan::__ANON__(): Error executing 'SELECT me.id, me.name, me.namesort, me.musicmagic_mixable, me.namesearch, me.musicbrainz_id FROM contributors me LEFT JOIN contributor_album contributorAlbums ON ( contributorAlbums.contributor = me.id )  JOIN albums album ON ( album.id = contributorAlbums.album ) WHERE ( ( ( ( ( album.compilation IS NULL ) OR ( album.compilation = ? ) ) AND contributorAlbums.role IN ( ?, ?, ? ) ) ) ) GROUP BY me.id ORDER BY me.namesort LIMIT 325': DBD::mysql::st execute failed: Can't create/write to file 'C:\windows\TEMP\#sql_10c0_0.MYD' (Errcode: 17) at /<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI.pm line 771.
]
[08-12-15 09:44:53.0635] Slim::Schema::Storage::throw_exception (70) Error: Error executing 'SELECT me.id, me.name, me.namesort, me.namesearch, me.musicmagic_mixable FROM genres me GROUP BY me.id, me.name, me.namesort, me.namesearch, me.musicmagic_mixable ORDER BY me.namesort LIMIT 36': DBD::mysql::st execute failed: Can't create/write to file 'C:\windows\TEMP\#sql_10c0_0.MYD' (Errcode: 17) at /<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI.pm line 771.
[08-12-15 09:44:53.0640] Slim::Schema::Storage::throw_exception (70) Backtrace:

   frame 0: Slim::Utils::Log::logBacktrace (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Schema/Storage.pm line 70)
   frame 1: Slim::Schema::Storage::throw_exception (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI.pm line 773)
   frame 2: DBIx::Class::Storage::DBI::_execute (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI.pm line 826)
   frame 3: DBIx::Class::Storage::DBI::_select (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI/Cursor.pm line 79)
   frame 4: DBIx::Class::Storage::DBI::Cursor::next (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Cursor.pm line 69)
   frame 5: DBIx::Class::Cursor::all (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI/Cursor.pm line 115)
   frame 6: DBIx::Class::Storage::DBI::Cursor::all (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/ResultSet.pm line 947)
   frame 7: DBIx::Class::ResultSet::all (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/ResultSet.pm line 143)
   frame 8: DBIx::Class::ResultSet::search (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/ResultSet.pm line 661)
   frame 9: DBIx::Class::ResultSet::slice (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Queries.pm line 1453)
   frame 10: Slim::Control::Queries::genresQuery (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 1885)
   frame 11: (eval) (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 1885)
   frame 12: Slim::Control::Request::execute (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 867)
   frame 13: Slim::Control::Request::executeRequest (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Jive.pm line 186)
   frame 14: Slim::Control::Jive::buildCaches (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 2070)
   frame 15: (eval) (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 2070)
   frame 16: Slim::Control::Request::notify (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Control/Request.pm line 846)
   frame 17: Slim::Control::Request::checkNotifications (slimserver.pl line 520)
   frame 18: main::idle (slimserver.pl line 486)
   frame 19: main::main (slimserver.pl line 88)
   frame 20: PerlSvc::Interactive (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>PerlSvc.pm line 99)
   frame 21: PerlSvc::_interactive (slimserver.pl line 0)
   frame 22: (eval) (slimserver.pl line 0)

[08-12-15 09:44:53.0643] Slim::Control::Request::execute (1889) Error: While trying to run function coderef [Slim::Control::Queries::genresQuery]: [Carp::Clan::__ANON__(): Error executing 'SELECT me.id, me.name, me.namesort, me.namesearch, me.musicmagic_mixable FROM genres me GROUP BY me.id, me.name, me.namesort, me.namesearch, me.musicmagic_mixable ORDER BY me.namesort LIMIT 36': DBD::mysql::st execute failed: Can't create/write to file 'C:\windows\TEMP\#sql_10c0_0.MYD' (Errcode: 17) at /<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI.pm line 771.
]

Comment 1 Michael Herger 2008-12-15 01:37:51 UTC

That's an issue with your antivirus scanner blocking access to *.my* files. Tell it not to do so. 

Please contact support if this didn't help.

Comment 2 Edmund Teng 2008-12-28 23:37:23 UTC

At first I thought you were right, because I found that many people were saying that on the internet.  So then I removed my anti-virus software and re-installed the SqueezeCenter.  The same problem still exist.  I think there is still a problem.  Funny why there was no problem with version 7.0 and earlier versions.  Perhaps you guys want to seriously look into it, rather than just brush it off as someone's problem.  Attached please find the error message from the scanner.log:

****************************************************************************
[08-12-29 13:16:33.2827] 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_77c_0.MYD' (Errcode: 17) at /<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 771.
[08-12-29 13:16:33.2910] 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)

[08-12-29 13:16:33.3426] 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_77c_0.MYD' (Errcode: 17) at /<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 771.
[08-12-29 13:16:33.3432] 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)

****************************************************************************

Comment 3 James Richardson 2008-12-29 12:11:39 UTC

Alan: your comments on the error log?

Comment 4 Alan Young 2009-01-04 04:12:25 UTC

This is not my area of expertise. Maybe Andy or Michael can comment.

Comment 5 Andy Grundman 2009-01-04 06:19:47 UTC

I don't believe this error has ever been seen where it was not caused by anti-virus.

Comment 6 KDF 2009-01-04 13:40:55 UTC

Some scans will pass while AV software is running.  Sometimes they get stopped.  Even when AV program are shut off, they are not always off.  As Andy says there is no cause to date that hasn't eventually been traced to AV software interfering with MySQL.  Instead of brushing it off as a lack off effort, perhaps it's work look at your software installs again.  Look for a setting to ignore *.MYD and *.MYI files.  A lot of time has been given in other reports and forum threads to help folks dig down and find the same causes over and over.  

Thankfully, one benefit with 8.0 and moving to SQLite is that this only seemed to happen once MySQL was in the picture.

Comment 7 Michael Herger 2009-01-04 21:55:53 UTC

One other reason I've seen causing similar issues is limited disk space (reported for QNAP NAS devices). But Windows would complain if it hadn't any space left on C:. Please check anyways.

Comment 8 James Richardson 2009-01-07 15:16:01 UTC

Edmund: any feed back on the last few comments made? are you still seeing this issue?

Have you tried the nightly version of 7.3.2 yet?

Comment 9 James Richardson 2009-01-08 10:59:11 UTC

Moving to monitor, awaiting feed back from customer.

Comment 10 James Richardson 2009-01-13 13:03:27 UTC

no new information from customer, closing bug for now.  If you still see the issue, please comment and reopen the bug.

Comment 11 James Richardson 2012-02-27 17:19:14 UTC

Closing resolved bugs - if you feel this bug still exists please first re-test with the latest SW/FW version.  If you are able to reproduce then feel free to reopen and attach new logs / steps to reproduce.