PDA

View Full Version : Borked after upgrade - help? (6.5b1 / Kubuntu Dapper)



doundounba
2006-08-02, 10:43
Hi all,

Been running 6.5b1 for quite a while without any problems. I hadn't upgraded it in quite a long time because I read here that some people were having problems with newer builds... Something about a Big Merge of some sort a while back.

Anyway, I now figured it was time to upgrade, so I fired off Adept and upgraded my slimserver package. It seemed to go fine, but my server is now borked. It's running, but *always* tells me that "SlimServer is still scanning your music library.", and most of my music collection is absent from the interface. Asking it to rescan my collection (either to look for new music or to clear and rescan everything) does nothing - no CPU or disk activity, no apparent change in anything. De-installing the deb and reinstalling it does nothing either.

Anyone with any suggestions? I am appending the (lengthy!) log output generated when restarting the server. It shows obvious problems, so maybe someone can suggest a possible course of action based on that...?

Any help would be much appreciated!

Thanks!

--
[Note] /usr/sbin/mysqld: Normal shutdown

InnoDB: Starting shutdown...
InnoDB: Shutdown completed; log sequence number 0 1003103
[Note] /usr/sbin/mysqld: Shutdown complete

ERROR: forceCommit: Trying to commit transactions before DB is initialized!

InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Retrying to lock the first data file
InnoDB: Started; log sequence number 0 1003103
/usr/sbin/mysqld: ready for connections.
Version: '4.1.15-Debian_1ubuntu5' socket: '/var/cache/slimserver/slimserver-mysql.sock' port: 9092 Source distribution
[Note] /usr/sbin/mysqld: Normal shutdown

ERROR: DBI Connection failed: DBI connect('hostname=127.0.0.1;port=9092;database=sli mserver:mysql_socket=/var/cache/slimserver/slimserver-mysql.sock','',...) failed: Can't connect to MySQL server on '127.0.0.1' (111) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 624

ERROR: Backtrace follows:

Backtrace:

frame 0: Slim::Schema::Storage::throw_exception (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 630)
frame 1: DBIx::Class::Storage::DBI::_connect (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 588)
frame 2: DBIx::Class::Storage::DBI::_populate_dbh (/usr/share/perl5/Slim/Schema/Storage.pm line 32)
frame 3: Slim::Schema::Storage::_populate_dbh (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 515)
frame 4: DBIx::Class::Storage::DBI::ensure_connected (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 529)
frame 5: DBIx::Class::Storage::DBI::dbh (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 839)
frame 6: DBIx::Class::Storage::DBI::sth (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 732)
frame 7: (eval) (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 732)
frame 8: DBIx::Class::Storage::DBI::_execute (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 798)
frame 9: DBIx::Class::Storage::DBI::_select (/usr/share/perl5/DBIx/Class/Storage/DBI/Cursor.pm line 79)
frame 10: DBIx::Class::Storage::DBI::Cursor::next (/usr/share/perl5/DBIx/Class/ResultSet.pm line 864)
frame 11: DBIx::Class::ResultSet::_count (/usr/share/perl5/DBIx/Class/ResultSet.pm line 825)
frame 12: DBIx::Class::ResultSet::count (/usr/share/perl5/Slim/Schema.pm line 282)
frame 13: Slim::Schema::count (/usr/share/perl5/Slim/Schema.pm line 139)
frame 14: Slim::Schema::init (/usr/share/perl5/Slim/Music/Info.pm line 61)
frame 15: Slim::Music::Info::init (/usr/sbin/slimserver line 370)
frame 16: main::init (/usr/sbin/slimserver line 447)
frame 17: main::main (/usr/sbin/slimserver line 1046)

ERROR: no sth generated via sql (Can't call method "prepare_cached" on an undefined value at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 839.
): SELECT COUNT( * ) FROM years me
ERROR: Backtrace follows:

Backtrace:

frame 0: Slim::Schema::Storage::throw_exception (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 734)
frame 1: DBIx::Class::Storage::DBI::_execute (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 798)
frame 2: DBIx::Class::Storage::DBI::_select (/usr/share/perl5/DBIx/Class/Storage/DBI/Cursor.pm line 79)
frame 3: DBIx::Class::Storage::DBI::Cursor::next (/usr/share/perl5/DBIx/Class/ResultSet.pm line 864)
frame 4: DBIx::Class::ResultSet::_count (/usr/share/perl5/DBIx/Class/ResultSet.pm line 825)
frame 5: DBIx::Class::ResultSet::count (/usr/share/perl5/Slim/Schema.pm line 282)
frame 6: Slim::Schema::count (/usr/share/perl5/Slim/Schema.pm line 139)
frame 7: Slim::Schema::init (/usr/share/perl5/Slim/Music/Info.pm line 61)
frame 8: Slim::Music::Info::init (/usr/sbin/slimserver line 370)
frame 9: main::init (/usr/sbin/slimserver line 447)
frame 10: main::main (/usr/sbin/slimserver line 1046)

ERROR: 'SELECT COUNT( * ) FROM years me' did not generate a statement.
ERROR: Backtrace follows:

Backtrace:

frame 0: Slim::Schema::Storage::throw_exception (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 749)
frame 1: DBIx::Class::Storage::DBI::_execute (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 798)
frame 2: DBIx::Class::Storage::DBI::_select (/usr/share/perl5/DBIx/Class/Storage/DBI/Cursor.pm line 79)
frame 3: DBIx::Class::Storage::DBI::Cursor::next (/usr/share/perl5/DBIx/Class/ResultSet.pm line 864)
frame 4: DBIx::Class::ResultSet::_count (/usr/share/perl5/DBIx/Class/ResultSet.pm line 825)
frame 5: DBIx::Class::ResultSet::count (/usr/share/perl5/Slim/Schema.pm line 282)
frame 6: Slim::Schema::count (/usr/share/perl5/Slim/Schema.pm line 139)
frame 7: Slim::Schema::init (/usr/share/perl5/Slim/Music/Info.pm line 61)
frame 8: Slim::Music::Info::init (/usr/sbin/slimserver line 370)
frame 9: main::init (/usr/sbin/slimserver line 447)
frame 10: main::main (/usr/sbin/slimserver line 1046)

Can't call method "fetchrow_array" on an undefined value at /usr/share/perl5/DBIx/Class/Storage/DBI/Cursor.pm line 86.
ERROR: forceCommit: Trying to commit transactions before DB is initialized!

ERROR: DBI Connection failed: DBI connect('hostname=127.0.0.1;port=9092;database=sli mserver:mysql_socket=/var/cache/slimserver/slimserver-mysql.sock','',...) failed: Can't connect to MySQL server on '127.0.0.1' (111) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 624

ERROR: Backtrace follows:

Backtrace:

frame 0: Slim::Schema::Storage::throw_exception (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 630)
frame 1: DBIx::Class::Storage::DBI::_connect (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 588)
frame 2: DBIx::Class::Storage::DBI::_populate_dbh (/usr/share/perl5/Slim/Schema/Storage.pm line 32)
frame 3: Slim::Schema::Storage::_populate_dbh (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 515)
frame 4: DBIx::Class::Storage::DBI::ensure_connected (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 529)
frame 5: DBIx::Class::Storage::DBI::dbh (/usr/share/perl5/Slim/Schema.pm line 191)
frame 6: (eval) (/usr/share/perl5/Slim/Schema.pm line 191)
frame 7: Slim::Schema::disconnect (/usr/sbin/slimserver line 1012)
frame 8: main::cleanup (/usr/share/perl5/Slim/bootstrap.pm line 255)
frame 9: Slim::bootstrap::sigint (/usr/share/perl5/Slim/bootstrap.pm line 286)
frame 10: Slim::bootstrap::END (/usr/sbin/slimserver line 0)
frame 11: (eval) (/usr/sbin/slimserver line 0)

InnoDB: Starting shutdown...
InnoDB: Shutdown completed; log sequence number 0 1003113
[Note] /usr/sbin/mysqld: Shutdown complete

InnoDB: Started; log sequence number 0 1003113
/usr/sbin/mysqld: ready for connections.
Version: '4.1.15-Debian_1ubuntu5' socket: '/var/cache/slimserver/slimserver-mysql.sock' port: 9092 Source distribution
Warning! - Slim::Formats::Parse::registerParser is deprecated!
Please update your code to use: Slim::Formats::Playlists->registerParser($type, $playlistClass)
Make sure your $playlistClass has a ->read() method, and an optional ->write() method
Backtrace:

frame 0: Slim::Formats::Parse::registerParser (/usr/share/slimserver/Plugins/Alien/RTSP.pm line 32)
frame 1: (eval) (/usr/share/slimserver/Plugins/Alien/Plugin.pm line 168)
frame 2: Plugins::Alien::Plugin::BEGIN (/usr/share/slimserver/Plugins/Alien/RTSP.pm line 0)
frame 3: (eval) (/usr/share/slimserver/Plugins/Alien/RTSP.pm line 0)
frame 4: (eval) ((eval 264) line 2)
frame 5: Slim::Utils::PluginManager::BEGIN (/usr/share/slimserver/Plugins/Alien/RTSP.pm line 0)
frame 6: (eval) (/usr/share/slimserver/Plugins/Alien/RTSP.pm line 0)
frame 7: (eval) (/usr/share/perl5/Slim/Utils/PluginManager.pm line 183)
frame 8: Slim::Utils::PluginManager::canPlugin (/usr/share/perl5/Slim/Web/Setup.pm line 3330)
frame 9: Slim::Web::Setup::getCategoryPlugins (/usr/share/perl5/Slim/Web/Setup.pm line 3222)
frame 10: Slim::Web::Setup::addGroup (/usr/share/slimserver/Plugins/MusicMagic/Plugin.pm line 140)
frame 11: Plugins::MusicMagic::Plugin::initPlugin (/usr/share/slimserver/Plugins/MusicMagic/Plugin.pm line 82)
frame 12: Plugins::MusicMagic::Plugin::enabled (/usr/share/perl5/Slim/Utils/PluginManager.pm line 191)
frame 13: Slim::Utils::PluginManager::canPlugin (/usr/share/perl5/Slim/Utils/PluginManager.pm line 245)
frame 14: Slim::Utils::PluginManager::addPlugin (/usr/share/perl5/Slim/Utils/PluginManager.pm line 148)
frame 15: Slim::Utils::PluginManager::initPlugins (/usr/share/perl5/Slim/Utils/PluginManager.pm line 55)
frame 16: Slim::Utils::PluginManager::init (/usr/sbin/slimserver line 419)
frame 17: main::init (/usr/sbin/slimserver line 447)
frame 18: main::main (/usr/sbin/slimserver line 1046)

doundounba
2006-08-03, 20:23
Had a friend over tonight and together we managed to figure it out:

1. Shut down mysql server.
2. Uninstall slimserver.
3. sudo rm -r /var/cache/slimserver
4. Restart mysql server.
5. Re-install slimserver.

And things are back to normal!