My server has stopped working. I've uninstalled and cleaned up and installed 6.5.1 with same results. Exactly the same procedure on another machine does NOT fail. I need ideas about what to look for.
A symptom is that if I try to add something to the current (empty) playlist using the Web UI, the server web UI totally or partially hangs. Particularly, the right hand (player) pane stays totally blank. Even with the UI hung, I can to some extent get at music from a client. There is nothing in the event log of interest. The server log shows: Warning: Migrating from 6.3.x used with MySQL! ERROR: Error executing 'SELECT contributor.id, contributor.name, contributor.namesort, contributor.moodlogic_id, contributor.moodlogic_mixable, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_track me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.track = ? ) ) ) GROUP BY contributor.id ORDER BY role desc': DBD::mysql::st execute failed: Can't create/write to file 'D:|WINDOWS\TEMP\#sql_fac_0.MYI' (Errcode: 22) at C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 771. ERROR: Backtrace follows: Backtrace: frame 0: Slim::Schema::Storage::throw_exception (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 773) frame 1: DBIx::Class::Storage::DBI::_execute (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 826) frame 2: DBIx::Class::Storage::DBI::_select (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 852) frame 3: DBIx::Class::Storage::DBI::select_single (C:\Program Files\SlimServer\server/Slim/Schema/Storage.pm line 94) frame 4: Slim::Schema::Storage::select_single (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/ResultSet.pm line 509) frame 5: DBIx::Class::ResultSet::single (C:\Program Files\SlimServer\server/Slim/Schema/Track.pm line 95) frame 6: Slim::Schema::Track::artist (C:\Program Files\SlimServer\server/Slim/Schema/Track.pm line 390) frame 7: Slim::Schema::Track::displayAsHTML (/PerlApp/Slim/Web/Pages/Status.pm line 153) frame 8: Slim::Web::Pages::Status::status (/PerlApp/Slim/Web/Pages/Status.pm line 35) frame 9: Slim::Web::Pages::Status::status_header (/PerlApp/Slim/Web/HTTP.pm line 824) frame 10: Slim::Web::HTTP::generateHTTPResponse (/PerlApp/Slim/Web/HTTP.pm line 690) frame 11: Slim::Web::HTTP::processURL (/PerlApp/Slim/Web/HTTP.pm line 536) frame 12: Slim::Web::HTTP::processHTTP (/PerlApp/Slim/Networking/Select.pm line 238) frame 13: (eval) (/PerlApp/Slim/Networking/Select.pm line 238) frame 14: Slim::Networking::Select::select (slimserver.pl line 492) frame 15: main::idle (slimserver.pl line 35) frame 16: PerlSvc::Startup (perlsvc.pl line 1482) frame 17: PerlSvc::_startup (slimserver.pl line 0) frame 18: (eval) (slimserver.pl line 0) Select task failed: Carp::Clan::__ANON__(): Error executing 'SELECT contributor.id, contributor.name, contributor.namesort, contributor.moodlogic_id, contributor.moodlogic_mixable, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_track me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.track = ? ) ) ) GROUP BY contributor.id ORDER BY role desc': DBD::mysql::st execute failed: Can't create/write to file 'D:|WINDOWS\TEMP\#sql_fac_0.MYI' (Errcode: 22) at C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 771. -- Millwood ------------------------------------------------------------------------ Millwood's Profile: http://forums.slimdevices.com/member.php?userid=3600 View this thread: http://forums.slimdevices.com/showthread.php?t=33667 _______________________________________________ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
