PDA

View Full Version : debian apt install - rebuild/reseed mysql instance



guy_smiley
2007-08-18, 00:38
Been running a slimserver with my old school pre-squeezebox slimp3 since forever and only upgraded to the mysql support package since I found the slimserver in the apt system on this last debian etch install.

Anyway, I'm not real deep with the mysql chops and after I did an upgrade on the apt packages today, my slimserver isn't accepting any connections. Here's what happened in the slimserver log after the upgrade:

070817 21:53:14 [Note] /usr/sbin/mysqld: Normal shutdown

070817 21:53:16 InnoDB: Starting shutdown...
070817 21:53:21 InnoDB: Shutdown completed; log sequence number 0 565494689
070817 21:53:21 [Note] /usr/sbin/mysqld: Shutdown complete

2007-08-17 21:53:21.9843 ERROR: forceCommit: Trying to commit transactions before DB is initialized!

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

2007-08-17 21:53:22.9082 ERROR: Backtrace follows:

2007-08-17 21:53:22.9091 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/DBIx/Class/Storage/DBI.pm line 515)
frame 3: DBIx::Class::Storage::DBI::ensure_connected (/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 529)
frame 4: DBIx::Class::Storage::DBI::dbh (/usr/share/perl5/Slim/Schema.pm line 247)
frame 5: (eval) (/usr/share/perl5/Slim/Schema.pm line 247)
frame 6: Slim::Schema::disconnect (/usr/sbin/slimserver line 1005)
frame 7: main::cleanup (/usr/share/perl5/Slim/bootstrap.pm line 300)
frame 8: Slim::bootstrap::sigint (/usr/share/perl5/Slim/bootstrap.pm line 331)
frame 9: Slim::bootstrap::END (/usr/sbin/slimserver line 0)
frame 10: (eval) (/usr/sbin/slimserver line 0)

2007-08-17 21:54:58 slimserver_safe started.
2007-08-17 21:55:11 Slimserver died. Restarting.
2007-08-17 21:55:19 Slimserver died. Restarting.
2007-08-17 21:55:28 Slimserver died. Restarting.
2007-08-17 21:55:37 Slimserver died. Restarting.
2007-08-17 21:55:44 Slimserver died. Restarting.
2007-08-17 21:55:52 Slimserver died. Restarting.
2007-08-17 21:56:00 Slimserver died. Restarting.

I suspected the mysql upgrade happened out of sequence or something and tried to rename the mysql files to see if a subsequent restart of the slimserver service would create new ones in /var/cache/slimserver/MySQL/

That didn't work. Am I chasing the wrong problem?

Many thanks,
guy

guy_smiley
2007-08-18, 13:16
I managed to remove and deinstall all the mysql and slimserver packages, with apt-get and then did a fresh install of slimserver, with all the mysql dependancies being built with it. The slimserver still isn't listening on port 9000 and the log now includes a bunch of this:

2007-08-18 13:13:23 Slimserver died. Restarting.
2007-08-18 13:13:32.5539 Warning: Migrating from 6.3.x used with MySQL!
Database error: Table 'slimserver.albums' doesn't exist at /usr/share/perl5/DBIx/Migration.pm line 115.
2007-08-18 13:13:32.7445 ERROR: forceCommit: Trying to commit transactions before DB is initialized!

2007-08-18 13:13:35 Slimserver died. Restarting.
2007-08-18 13:13:44.8781 Warning: Migrating from 6.3.x used with MySQL!
Database error: Table 'slimserver.albums' doesn't exist at /usr/share/perl5/DBIx/Migration.pm line 115.
2007-08-18 13:13:44.9055 ERROR: forceCommit: Trying to commit transactions before DB is initialized!

2007-08-18 13:13:47 Slimserver died. Restarting.
2007-08-18 13:13:58.1608 Warning: Migrating from 6.3.x used with MySQL!
Database error: Table 'slimserver.albums' doesn't exist at /usr/share/perl5/DBIx/Migration.pm line 115.
2007-08-18 13:13:58.2737 ERROR: forceCommit: Trying to commit transactions before DB is initialized!

Anybody using the current debian apt release of slimserver with etch? It was fine until yesterday and I think I remember upgrading my packages once before on this etch install.

guy_smiley
2007-08-18, 14:35
deinstalled slimserver and all mysql-common with apt again, removed the /var/cache/slimserver directory entirely, did a full dist-upgrade and then install of slimserver.

Now slimserver is listening again on port 9000 and scanning my music library.

Thanks anyway.