Slim stopped working - need ideas.

[Millwood]

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:BI::_execute (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 826)
frame 2: DBIx::Class::Storage:BI::_select (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 852)
frame 3: DBIx::Class::Storage:BI::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:rocessURL (/PerlApp/Slim/Web/HTTP.pm line 536)
frame 12: Slim::Web::HTTP:rocessHTTP (/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.

[kdf]

Quoting Millwood <Millwood.2nk05b1174074601 (AT) no-mx (DOT) forums.slimdevices.com>:


> 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.

got a virus scanner installed, perhaps?

set it to ignore *.MYD and *.MYI files.

-kdf

[snarlydwarf]

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.

Convince your Antivirus software to leave *.MYD/MYI files alone.

Norton especially seems to lock this file, which breaks MySQL.

[Millwood]

Boy do I feel stupid for not reading that error message carefully. I really have no excuse.

The cause was not Norton - which I run but which is configured to do a pop-up whenever it takes an action.

I just added a second drive, mostly for backups and video. So when I formatted it, I (foolishly) choose large allocation units - 65k. I never imagined that NTFS might be so braindead as to prevent some operations when large allocations are used. But I guess it does. I had moved my temp files to the new large disk. Thats why the error. Moving them back to C: fixed it.

It also apparently explains my failed scan, since my music library and playlists are back.

So again, thanks for the help.