First Last Prev Next    This bug is not in your last search results.
Bug 15253 - Squeezeboxserver continually fails to start
: Squeezeboxserver continually fails to start
Status: RESOLVED WONTFIX
Product: Logitech Media Server
Classification: Unclassified
Component: Database
: 7.4.1
: PC Ubuntu Linux
: P3 normal (vote)
: ---
Assigned To: Squeezebox QA Team email alias
:
Depends on:
Blocks:
  Show dependency tree / graph
 
Reported: 2009-12-04 23:09 UTC by Jon Pawley
Modified: 2011-01-14 00:58 UTC (History)
2 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 Jon Pawley 2009-12-04 23:09:32 UTC 
Squeezeboxserver continaully fails to start, and is stuck in an endless loop of restarts. I cannot figure out how to fix this. Doing a:

$ sudo aptitude purge squeezeboxserver
$ sudo aptitude install squeezeboxserver

fails to fix this. I thought I'd try dropping the SBS database, but couldn't figure out how to get to the "embedded" MySQL database.

The server.log file contains repititions of the following:

[code]
2009-12-04 19:25:06 Squeezebox Server died. Restarting.
[09-12-04 19:25:07.5059] main::init (320) Starting Squeezebox Server (v7.4.1, r28947, Tue Oct 20 07:58:02 PDT 2009) perl 5.010000
[09-12-04 19:25:07.8916] Slim::Schema::Storage::throw_exception (82) Error: DBI Exception: DBD::mysql::st execute failed: Incorrect file format 'me' [for Statement "SELECT COUNT( * ) FROM tracks me WHERE ( me.content_type = ? )"]
[09-12-04 19:25:07.8921] Slim::Schema::Storage::throw_exception (82) Backtrace:

   frame 0: Slim::Utils::Log::logBacktrace (/usr/share/perl5/Slim/Schema/Storage.pm line 82)
   frame 1: Slim::Schema::Storage::throw_exception (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 957)
   frame 2: DBIx::Class::Storage::DBI::__ANON__ (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 1217)
   frame 3: DBIx::Class::Storage::DBI::_dbh_execute (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 532)
   frame 4: DBIx::Class::Storage::DBI::dbh_do (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 1227)
   frame 5: DBIx::Class::Storage::DBI::_execute (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 1451)
   frame 6: DBIx::Class::Storage::DBI::_select (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 82)
   frame 7: DBIx::Class::Storage::DBI::Cursor::_dbh_next (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 547)
   frame 8: (eval) (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 540)
   frame 9: DBIx::Class::Storage::DBI::dbh_do (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 101)
   frame 10: DBIx::Class::Storage::DBI::Cursor::next (/usr/share/squeezeboxserver/CPAN/DBIx/Class/ResultSetColumn.pm line 128)
   frame 11: DBIx::Class::ResultSetColumn::next (/usr/share/squeezeboxserver/CPAN/DBIx/Class/ResultSet.pm line 1181)
   frame 12: DBIx::Class::ResultSet::count (/usr/share/squeezeboxserver/CPAN/DBIx/Class/ResultSet.pm line 1164)
   frame 13: DBIx::Class::ResultSet::count (/usr/share/perl5/Slim/Schema.pm line 600)
   frame 14: Slim::Schema::count (/usr/share/perl5/Slim/Schema.pm line 236)
   frame 15: Slim::Schema::init (/usr/share/perl5/Slim/Music/Import.pm line 745)
   frame 16: Slim::Music::Import::_checkLibraryStatus (/usr/share/perl5/Slim/Music/Import.pm line 678)
   frame 17: Slim::Music::Import::useImporter (/usr/share/perl5/Slim/Music/PlaylistFolderScan.pm line 53)
   frame 18: Slim::Music::PlaylistFolderScan::init (/usr/sbin/squeezeboxserver line 433)
   frame 19: main::init (/usr/sbin/squeezeboxserver line 572)
   frame 20: main::main (/usr/sbin/squeezeboxserver line 1065)

[09-12-04 19:25:07.8924] Slim::Schema::Storage::throw_exception (82) Error: Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::st execute failed: Incorrect file format 'me' [for Statement "SELECT COUNT( * ) FROM tracks me WHERE ( me.content_type = ? )"] at /usr/share/perl5/Slim/Schema/Storage.pm line 86
[09-12-04 19:25:07.8927] Slim::Schema::Storage::throw_exception (82) Backtrace:

   frame 0: Slim::Utils::Log::logBacktrace (/usr/share/perl5/Slim/Schema/Storage.pm line 82)
   frame 1: Slim::Schema::Storage::throw_exception (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 562)
   frame 2: DBIx::Class::Storage::DBI::dbh_do (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 101)
   frame 3: DBIx::Class::Storage::DBI::Cursor::next (/usr/share/squeezeboxserver/CPAN/DBIx/Class/ResultSetColumn.pm line 128)
   frame 4: DBIx::Class::ResultSetColumn::next (/usr/share/squeezeboxserver/CPAN/DBIx/Class/ResultSet.pm line 1181)
   frame 5: DBIx::Class::ResultSet::count (/usr/share/squeezeboxserver/CPAN/DBIx/Class/ResultSet.pm line 1164)
   frame 6: DBIx::Class::ResultSet::count (/usr/share/perl5/Slim/Schema.pm line 600)
   frame 7: Slim::Schema::count (/usr/share/perl5/Slim/Schema.pm line 236)
   frame 8: Slim::Schema::init (/usr/share/perl5/Slim/Music/Import.pm line 745)
   frame 9: Slim::Music::Import::_checkLibraryStatus (/usr/share/perl5/Slim/Music/Import.pm line 678)
   frame 10: Slim::Music::Import::useImporter (/usr/share/perl5/Slim/Music/PlaylistFolderScan.pm line 53)
   frame 11: Slim::Music::PlaylistFolderScan::init (/usr/sbin/squeezeboxserver line 433)
   frame 12: main::init (/usr/sbin/squeezeboxserver line 572)
   frame 13: main::main (/usr/sbin/squeezeboxserver line 1065)

[09-12-04 19:25:07.8929] Carp::Clan::__ANON__ (214) Warning: Carp::Clan::__ANON__(): Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::st execute failed: Incorrect file format 'me' [for Statement "SELECT COUNT( * ) FROM tracks me WHERE ( me.content_type = ? )"] at /usr/share/perl5/Slim/Schema/Storage.pm line 86
[09-12-04 19:25:08.1404] Slim::Schema::forceCommit (1600) Warning: Trying to commit transactions before DB is initialized!
2009-12-04 19:25:11 Squeezebox Server died. Restarting.
[/code]
Comment 1 Jon Pawley 2009-12-04 23:57:35 UTC 
Also fails on v7.4.0, r28672 with a similar server.log entry:

[code]
2009-12-05 20:51:46 Squeezebox Server died. Restarting.
[09-12-05 20:51:47.2746] main::init (320) Starting Squeezebox Server (v7.4.0, r28672, Mon Sep 28 17:48:40 PDT 2009) perl 5.010000
[09-12-05 20:51:47.6846] Slim::Schema::Storage::throw_exception (82) Error: DBI Exception: DBD::mysql::st execute failed: Incorrect file format 'me' [for Statement "SELECT COUNT( * ) FROM tracks me WHERE ( me.content_type = ? )"]
[09-12-05 20:51:47.6851] Slim::Schema::Storage::throw_exception (82) Backtrace:

   frame 0: Slim::Utils::Log::logBacktrace (/usr/share/perl5/Slim/Schema/Storage.pm line 82)
   frame 1: Slim::Schema::Storage::throw_exception (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 957)
   frame 2: DBIx::Class::Storage::DBI::__ANON__ (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 1217)
   frame 3: DBIx::Class::Storage::DBI::_dbh_execute (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 532)
   frame 4: DBIx::Class::Storage::DBI::dbh_do (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 1227)
   frame 5: DBIx::Class::Storage::DBI::_execute (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 1451)
   frame 6: DBIx::Class::Storage::DBI::_select (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 82)
   frame 7: DBIx::Class::Storage::DBI::Cursor::_dbh_next (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 547)
   frame 8: (eval) (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 540)
   frame 9: DBIx::Class::Storage::DBI::dbh_do (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 101)
   frame 10: DBIx::Class::Storage::DBI::Cursor::next (/usr/share/squeezeboxserver/CPAN/DBIx/Class/ResultSetColumn.pm line 128)
   frame 11: DBIx::Class::ResultSetColumn::next (/usr/share/squeezeboxserver/CPAN/DBIx/Class/ResultSet.pm line 1181)
   frame 12: DBIx::Class::ResultSet::count (/usr/share/squeezeboxserver/CPAN/DBIx/Class/ResultSet.pm line 1164)
   frame 13: DBIx::Class::ResultSet::count (/usr/share/perl5/Slim/Schema.pm line 600)
   frame 14: Slim::Schema::count (/usr/share/perl5/Slim/Schema.pm line 236)
   frame 15: Slim::Schema::init (/usr/share/perl5/Slim/Music/Import.pm line 740)
   frame 16: Slim::Music::Import::_checkLibraryStatus (/usr/share/perl5/Slim/Music/Import.pm line 673)
   frame 17: Slim::Music::Import::useImporter (/usr/share/perl5/Slim/Music/PlaylistFolderScan.pm line 53)
   frame 18: Slim::Music::PlaylistFolderScan::init (/usr/sbin/squeezeboxserver line 433)
   frame 19: main::init (/usr/sbin/squeezeboxserver line 572)
   frame 20: main::main (/usr/sbin/squeezeboxserver line 1103)

[09-12-05 20:51:47.6854] Slim::Schema::Storage::throw_exception (82) Error: Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::st execute failed: Incorrect file format 'me' [for Statement "SELECT COUNT( * ) FROM tracks me WHERE ( me.content_type = ? )"] at /usr/share/perl5/Slim/Schema/Storage.pm line 86
[09-12-05 20:51:47.6857] Slim::Schema::Storage::throw_exception (82) Backtrace:

   frame 0: Slim::Utils::Log::logBacktrace (/usr/share/perl5/Slim/Schema/Storage.pm line 82)
   frame 1: Slim::Schema::Storage::throw_exception (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 562)
   frame 2: DBIx::Class::Storage::DBI::dbh_do (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 101)
   frame 3: DBIx::Class::Storage::DBI::Cursor::next (/usr/share/squeezeboxserver/CPAN/DBIx/Class/ResultSetColumn.pm line 128)
   frame 4: DBIx::Class::ResultSetColumn::next (/usr/share/squeezeboxserver/CPAN/DBIx/Class/ResultSet.pm line 1181)
   frame 5: DBIx::Class::ResultSet::count (/usr/share/squeezeboxserver/CPAN/DBIx/Class/ResultSet.pm line 1164)
   frame 6: DBIx::Class::ResultSet::count (/usr/share/perl5/Slim/Schema.pm line 600)
   frame 7: Slim::Schema::count (/usr/share/perl5/Slim/Schema.pm line 236)
   frame 8: Slim::Schema::init (/usr/share/perl5/Slim/Music/Import.pm line 740)
   frame 9: Slim::Music::Import::_checkLibraryStatus (/usr/share/perl5/Slim/Music/Import.pm line 673)
   frame 10: Slim::Music::Import::useImporter (/usr/share/perl5/Slim/Music/PlaylistFolderScan.pm line 53)
   frame 11: Slim::Music::PlaylistFolderScan::init (/usr/sbin/squeezeboxserver line 433)
   frame 12: main::init (/usr/sbin/squeezeboxserver line 572)
   frame 13: main::main (/usr/sbin/squeezeboxserver line 1103)

[09-12-05 20:51:47.6860] Carp::Clan::__ANON__ (214) Warning: Carp::Clan::__ANON__(): Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::st execute failed: Incorrect file format 'me' [for Statement "SELECT COUNT( * ) FROM tracks me WHERE ( me.content_type = ? )"] at /usr/share/perl5/Slim/Schema/Storage.pm line 86
[09-12-05 20:51:47.9343] Slim::Schema::forceCommit (1600) Warning: Trying to commit transactions before DB is initialized!
2009-12-05 20:51:51 Squeezebox Server died. Restarting.

[/code]
Comment 2 James Richardson 2009-12-07 08:33:11 UTC 
Please try 7.4.2 (beta)
Comment 3 Chris Owens 2010-02-01 08:32:55 UTC 
QA to reproduce
Comment 4 Chris Owens 2010-02-18 10:29:06 UTC 
Are you running with your own mysql instance?  Andy suggests that it may be too old a version.
Comment 5 Chris Owens 2010-03-08 11:17:09 UTC 
Moving P3 and lower bugs to next release target
Comment 6 Alan Young 2011-01-14 00:58:53 UTC 
The move to Sqlite in 7.6 makes this obsolete.
First Last Prev Next    This bug is not in your last search results.