First Last Prev Next    This bug is not in your last search results.
Bug 4614 - SlimServer 6.5 12/20 nightly crashes when alarm goes off
: SlimServer 6.5 12/20 nightly crashes when alarm goes off
Status: RESOLVED FIXED
Product: Logitech Media Server
Classification: Unclassified
Component: Database
: unspecified
: PC Debian Linux
: P2 normal (vote)
: ---
Assigned To: Chris Owens
:
Depends on:
Blocks:
  Show dependency tree / graph
 
Reported: 2006-12-23 09:52 UTC by Stewart Loving-Gibbard
Modified: 2007-04-13 20:18 UTC (History)
0 users

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 Stewart Loving-Gibbard 2006-12-23 09:52:55 UTC 
I have an alarm set for 7:30 AM, which has been crashing my SlimServer every morning for the past few mornings.

Here's what the log shows:

2006-12-23 07:30:15.9980 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.thumb, 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.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( audio = ? ) ORDER BY RAND() LIMIT 10': DBD::mysql::st execute failed: Incorrect key file for table '/tmp/#sql_91f_0.MYI'; try to repair it at /usr/local/slimserver/SlimServer_6.5_v2006-12-20/CPAN/DBIx/Class/Storage/DBI.pm line 771.

2006-12-23 07:30:16.0087 ERROR: Backtrace follows:

2006-12-23 07:30:16.0090 Backtrace:

   frame 0: Slim::Schema::Storage::throw_exception (/usr/local/slimserver/SlimServer_6.5_v2006-12-20/CPAN/DBIx/Class/Storage/DBI.pm line 773)
   frame 1: DBIx::Class::Storage::DBI::_execute (/usr/local/slimserver/SlimServer_6.5_v2006-12-20/CPAN/DBIx/Class/Storage/DBI.pm line 826)
   frame 2: DBIx::Class::Storage::DBI::_select (/usr/local/slimserver/SlimServer_6.5_v2006-12-20/CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 79)
   frame 3: DBIx::Class::Storage::DBI::Cursor::next (/usr/local/slimserver/SlimServer_6.5_v2006-12-20/CPAN/DBIx/Class/Cursor.pm line 69)
   frame 4: DBIx::Class::Cursor::all (/usr/local/slimserver/SlimServer_6.5_v2006-12-20/CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 115)
   frame 5: DBIx::Class::Storage::DBI::Cursor::all (/usr/local/slimserver/SlimServer_6.5_v2006-12-20/CPAN/DBIx/Class/ResultSet.pm line 945)
   frame 6: DBIx::Class::ResultSet::all (/usr/local/slimserver/SlimServer_6.5_v2006-12-20/CPAN/DBIx/Class/ResultSet.pm line 143)
   frame 7: DBIx::Class::ResultSet::search (/usr/local/slimserver/SlimServer_6.5_v2006-12-20/CPAN/DBIx/Class/ResultSet.pm line 659)
   frame 8: DBIx::Class::ResultSet::slice (/usr/local/slimserver/SlimServer_6.5_v2006-12-20/Plugins/RandomPlay/Plugin.pm line 89)
   frame 9: Plugins::RandomPlay::Plugin::findAndAdd (/usr/local/slimserver/SlimServer_6.5_v2006-12-20/Plugins/RandomPlay/Plugin.pm line 347)
   frame 10: Plugins::RandomPlay::Plugin::playRandom (/usr/local/slimserver/SlimServer_6.5_v2006-12-20/Slim/Buttons/AlarmClock.pm line 462)
   frame 11: Slim::Buttons::AlarmClock::checkAlarms (/usr/local/slimserver/SlimServer_6.5_v2006-12-20/Slim/Utils/Timers.pm line 181)
   frame 12: Slim::Utils::Timers::checkTimers (/usr/local/slimserver/slimserver/slimserver.pl line 495)
   frame 13: main::idle (/usr/local/slimserver/slimserver/slimserver.pl line 445)
   frame 14: main::main (/usr/local/slimserver/slimserver/slimserver.pl line 1071)

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.thumb, 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.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( audio = ? ) ORDER BY RAND() LIMIT 10': DBD::mysql::st execute failed: Incorrect key file for table '/tmp/#sql_91f_0.MYI'; try to repair it at /usr/local/slimserver/SlimServer_6.5_v2006-12-20/CPAN/DBIx/Class/Storage/DBI.pm line 771.
Comment 1 KDF 2006-12-31 11:50:31 UTC 
works for me.  Since the error is specifying a corrupt key problem, perhaps you should try rebuilding your database. Also disable any plugins that might be messing with the db. livesearch, custombrowse (although I think that might be using its own db) maybe?
Comment 2 Stewart Loving-Gibbard 2007-01-11 08:08:53 UTC 
I tried rebuilding the database as suggested, still crashes.

Suggestions?

-----------------------

2007-01-11 08:00:04.5862 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.thumb, 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.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( audio = ? ) ORDER BY RAND() LIMIT 10': DBD::mysql::st execute failed: Incorrect key file for table '/tmp/#sql_922_0.MYI'; try to repair it at /usr/local/slimserver/SlimServer_6.5_v2006-12-25/CPAN/DBIx/Class/Storage/DBI.pm line 771.

2007-01-11 08:00:04.5863 ERROR: Backtrace follows:

2007-01-11 08:00:04.5866 Backtrace:

   frame 0: Slim::Schema::Storage::throw_exception (/usr/local/slimserver/SlimServer_6.5_v2006-12-25/CPAN/DBIx/Class/Storage/DBI.pm line 773)
   frame 1: DBIx::Class::Storage::DBI::_execute (/usr/local/slimserver/SlimServer_6.5_v2006-12-25/CPAN/DBIx/Class/Storage/DBI.pm line 826)
   frame 2: DBIx::Class::Storage::DBI::_select (/usr/local/slimserver/SlimServer_6.5_v2006-12-25/CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 79)
   frame 3: DBIx::Class::Storage::DBI::Cursor::next (/usr/local/slimserver/SlimServer_6.5_v2006-12-25/CPAN/DBIx/Class/Cursor.pm line 69)
   frame 4: DBIx::Class::Cursor::all (/usr/local/slimserver/SlimServer_6.5_v2006-12-25/CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 115)
   frame 5: DBIx::Class::Storage::DBI::Cursor::all (/usr/local/slimserver/SlimServer_6.5_v2006-12-25/CPAN/DBIx/Class/ResultSet.pm line 945)
   frame 6: DBIx::Class::ResultSet::all (/usr/local/slimserver/SlimServer_6.5_v2006-12-25/CPAN/DBIx/Class/ResultSet.pm line 143)
   frame 7: DBIx::Class::ResultSet::search (/usr/local/slimserver/SlimServer_6.5_v2006-12-25/CPAN/DBIx/Class/ResultSet.pm line 659)
   frame 8: DBIx::Class::ResultSet::slice (/usr/local/slimserver/SlimServer_6.5_v2006-12-25/Plugins/RandomPlay/Plugin.pm line 89)
   frame 9: Plugins::RandomPlay::Plugin::findAndAdd (/usr/local/slimserver/SlimServer_6.5_v2006-12-25/Plugins/RandomPlay/Plugin.pm line 347)
   frame 10: Plugins::RandomPlay::Plugin::playRandom (/usr/local/slimserver/SlimServer_6.5_v2006-12-25/Slim/Buttons/AlarmClock.pm line 462)
   frame 11: Slim::Buttons::AlarmClock::checkAlarms (/usr/local/slimserver/SlimServer_6.5_v2006-12-25/Slim/Utils/Timers.pm line 181)
   frame 12: Slim::Utils::Timers::checkTimers (/usr/local/slimserver/slimserver/slimserver.pl line 495)
   frame 13: main::idle (/usr/local/slimserver/slimserver/slimserver.pl line 445)
   frame 14: main::main (/usr/local/slimserver/slimserver/slimserver.pl line 1071)

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.thumb, 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.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( audio = ? ) ORDER BY RAND() LIMIT 10': DBD::mysql::st execute failed: Incorrect key file for table '/tmp/#sql_922_0.MYI'; try to repair it at /usr/local/slimserver/SlimServer_6.5_v2006-12-25/CPAN/DBIx/Class/Storage/DBI.pm line 771.
Comment 3 Stewart Loving-Gibbard 2007-01-11 08:09:36 UTC 
Also, I'm not running any plugins (even my own).
Comment 4 KDF 2007-01-11 12:29:32 UTC 
did you simply rescan or did you erase and rebuild the db?  Are you using the internal db, or your own instance of mysql?
Comment 5 Chris Owens 2007-02-12 15:23:46 UTC 
I also can't reproduce this.  Stewart, are you still having this issue with more recent nightlies?
Comment 6 KDF 2007-04-13 19:11:42 UTC 
stewart?
Comment 7 Stewart Loving-Gibbard 2007-04-13 20:18:53 UTC 
Resolved with newer version, or it was a phantom to begin with. Thanks to all who followed up about it, even so!
First Last Prev Next    This bug is not in your last search results.