Bugzilla – Bug 3890
mysql related crash using browsedb
Last modified: 2008-09-15 14:39:24 UTC
When using browsedb from web UI, I'm getting crashes every so often, seemingly related to a write permission problem with the database. This occurs sometimes when simply clicking on browse albums, or refreshing a frame for browse albums. I've also see it happen when I click a browse link during a full scan. It is intermittent, in that I can restart and do the exact same thing and it will work just fine. Must be some sort of race condition. Havent' seen this happen running on linux, at least not that I've caught in a log. Win2k, 6.5b1 svn 8858, running in command window under activeState Perl 5.8.7 LOG-------------------- 2006-08-08 12:46:24.9866 DBD::mysql::st execute failed: Can't create/write to file 'C:\DOCUME~1\kdean\LOCALS~1\Temp\#sql_a30_0.MYI' (Errcode: 13) at D:\slim\server\CPAN/DBIx/Class/ Storage/DBI.pm line 743. 2006-08-08 12:46:24.9874 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_album me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( me.a lbum = ? ) GROUP BY contributor.id, contributor.name, contributor.namesort, contributor.moodlogic_id, contributor.moodlogic_mixable, contributor.musicmagic_mixable, contributor.nam esearch, contributor.musicbrainz_id': DBD::mysql::st execute failed: Can't create/write to file 'C:\DOCUME~1\kdean\LOCALS~1\Temp\#sql_a30_0.MYI' (Errcode: 13) at D:\slim\server\CPA N/DBIx/Class/Storage/DBI.pm line 743. 2006-08-08 12:46:24.9875 ERROR: Backtrace follows: 2006-08-08 12:46:24.9878 Backtrace: frame 0: Slim::Schema::Storage::throw_exception (D:\slim\server\CPAN/DBIx/Class/Storage/DBI.pm line 745) frame 1: DBIx::Class::Storage::DBI::_execute (D:\slim\server\CPAN/DBIx/Class/Storage/DBI.pm line 798) frame 2: DBIx::Class::Storage::DBI::_select (D:\slim\server\CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 79) frame 3: DBIx::Class::Storage::DBI::Cursor::next (D:\slim\server\CPAN/DBIx/Class/ResultSet.pm line 677) frame 4: DBIx::Class::ResultSet::next (D:\slim\server\CPAN/DBIx/Class/ResultSet.pm line 966) frame 5: DBIx::Class::ResultSet::first (D:\slim\server/Slim/Schema/Album.pm line 116) frame 6: Slim::Schema::Album::displayAsHTML (D:\slim\server/Slim/Web/Pages/BrowseDB.pm line 420) frame 7: Slim::Web::Pages::BrowseDB::browsedb (D:\slim\server/Slim/Web/HTTP.pm line 793) frame 8: Slim::Web::HTTP::generateHTTPResponse (D:\slim\server/Slim/Web/HTTP.pm line 667) frame 9: Slim::Web::HTTP::processURL (D:\slim\server/Slim/Web/HTTP.pm line 517) frame 10: Slim::Web::HTTP::processHTTP (D:\slim\server/Slim/Networking/Select.pm line 170) frame 11: Slim::Networking::Select::select (D:\slim\server\slimserver.pl line 493) frame 12: main::idle (D:\slim\server\slimserver.pl line 446) frame 13: main::main (D:\slim\server\slimserver.pl line 1043) 2006-08-08 12:46:24.9884 DBD::mysql::st fetchrow_array failed: fetch() without execute() at D:\slim\server\CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 86. DBD::mysql::st fetchrow_array failed: fetch() without execute() at D:\slim\server\CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 86. 2006-08-08 12:46:25.0527 NoSetup: let's free the hijacked pages...
Dan wants to know if you have a virus scanner running, that he's seen that cause some kind of timeout.
yup. Don't ask me to try disabling it, it isn't possible. McAfee Virusscan Enterprise
Ok, well that's the cause.
er...so no slimserver on any computer running antivirus? ouch. is there a mysql setting to extend the timeout?
Not that I'm aware of. If one can mark a directory not to watch, that's a possible work around instead of disabling the virus scanner entirely. Also, not all virus scanners have this issue. See also bug 3777
all set then. thanks.