PDA

View Full Version : Annoying upgrade problem on 7.1



kolding
2008-07-29, 23:25
Interesting that I haven't seen anybody else reporting this, but I ran into a small problem with upgrading to 7.1 today. I did the upgrade, and nothing seemed to happen. Turned out SqueezeCenter had died silently in the background, with the following message in the log:
Warning: Database error: Can't DROP 'rating'; check that column/key exists at /usr/share/squeezecenter/CPAN/DBIx/Migration.pm line 115.

Fix was relatively easy for me, go into MySQL and drop all the tables, but I have a feeling that would be a bit beyond many people.

My configuration may be a bit odd. Fedora 7 (Fedora Core 7, can't remember when they changed the name), using the MySQL server that's running on the box supporting several databases, rather than the internal one that comes with SqueezeCenter.

Anyone else see such an issue? Hopefully I'm unique on this guy.

Eric

mherger
2008-07-29, 23:50
> Warning: Database error: Can't DROP 'rating'; check that column/key
> exists at /usr/share/squeezecenter/CPAN/DBIx/Migration.pm line 115.

This issue has been reported several times, and we're investigating it.
It's most likely due to a schema change we did in 7.1. No idea why it
would fail on some installations but not others.

> Fix was relatively easy for me, go into MySQL and drop all the tables,
> but I have a feeling that would be a bit beyond many people.

The "fix" for the other users is to just wipe the MySQL cache folder,
which will force SC to rebuild the tables from scratch.

> My configuration may be a bit odd. Fedora 7 (Fedora Core 7, can't

I wonder whether we're only seeing this on Linux systems. Thanks for your
data point!

Michael

Zed Roeder
2008-07-30, 08:57
Michael,

could you please tell me, how to wipe the mysql cache under ubuntu (where can i find this folder)?

Thanks

Zed

exile
2008-07-30, 09:17
I think I have the same problem. After the failure to load 7.1 on my system I immediately went back to 7.0.2.

right now I don't have the time nor the desire to deal with yet another squeezecenter bug.

I do hope though that the problem gets fixed soon so that I can take advantage of the new features in 7.1

btw- i'm on osx 10.5.4 on my system.

kdf
2008-07-30, 09:46
http://forums.slimdevices.com/showthread.php?t=50391

exile
2008-07-30, 09:56
thanks for the link. when I have a moment I will try that solution.

markushk
2008-08-01, 06:21
I had the same issue using SSODS Beta13 on a QNAP TS-201.

I needed to reboot the NAS after trashing:
./share/HDA_DATA/SqueezeCenter/Cache/MySQL/

Its rescanning now... really wishing I had a look at porting those ReadyNAS scanner optimisations as I expect this'll take around 24hrs.

Markus


0004: [08-08-01 20:42:38.0597] DBIx::Migration::migrate (115) Warning: Database error: Can't DROP 'rating'; check that column/key exists at /share/HDA_DATA/SqueezeCenter/CPAN/DBIx/Migration.pm line 115.

0003: [08-08-01 20:42:32 ] ssctrl SqueezeCenter started.

0002: [08-08-01 20:41:59 ] ssctrl Command line = /volume1/SSODS/sbin/start-stop-daemon --start --chuid ssods --nicelevel -5 --exec /volume1/SSODS/bin/perl -- /volume1/SqueezeCenter/slimserver.pl --daemon --pidfile /volume1/SqueezeCenter/Cache/squeezecenter.pid --cachedir /volume1/SqueezeCenter/Cache --logdir /volume1/SqueezeCenter/Logs --prefsdir /volume1/SqueezeCenter/prefs --noupnp --httpport 9001

0001: [08-08-01 20:41:55 ] ssctrl Starting SqueezeCenter 7.1-22170.

pablolie
2008-08-01, 07:55
>

I wonder whether we're only seeing this on Linux systems. Thanks for your
data point!

Michael

Not mine, though. Upgrade worked perfectly on Ubuntu 8.04, external drive, over 2,000 albums in the SC database (well, SQL).

jeff.snodgrass
2008-08-03, 14:02
I'm having what appears to be the same issue upgrading to 7.1 under MacOS 10.5. After upgrade SC fails to start, with no visible error message. Error log matches what is reported in this thread.

However, I can't find the MySQL directory to delete in the Mac OSX directory structure. Any other ideas where it might be located?

Thanks

-Jeff


The startup error log is below:

[08-08-03 13:04:11.3648] DBIx::Migration::migrate (115) Warning: Database error: Can't DROP 'rating'; check that column/key exists at /Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/CPAN/DBIx/Migration.pm line 115.
[08-08-03 13:04:11.3654] Slim::Schema::forceCommit (1483) Warning: Trying to commit transactions before DB is initialized!
[08-08-03 13:04:21.5479] DBIx::Migration::migrate (115) Warning: Database error: Can't DROP 'rating'; check that column/key exists at /Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/CPAN/DBIx/Migration.pm line 115.
[08-08-03 13:04:21.5484] Slim::Schema::forceCommit (1483) Warning: Trying to commit transactions before DB is initialized!
[08-08-03 13:21:03.9423] DBIx::Migration::migrate (115) Warning: Database error: Can't DROP 'rating'; check that column/key exists at /Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/CPAN/DBIx/Migration.pm line 115.
[08-08-03 13:21:04.0340] Slim::Schema::forceCommit (1483) Warning: Trying to commit transactions before DB is initialized!
[08-08-03 13:21:33.3840] DBIx::Migration::migrate (115) Warning: Database error: Can't DROP 'rating'; check that column/key exists at /Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/CPAN/DBIx/Migration.pm line 115.
[08-08-03 13:21:33.3845] Slim::Schema::forceCommit (1483) Warning: Trying to commit transactions before DB is initialized!

jeff.snodgrass
2008-08-03, 20:17
I found the location of the MySQL cache in OSX, and did delete it and still couldn't get SqueezeCenter to start, slightly different error message.

I then went ahead and deleted everything else squeezecenter related and did a clean install and continue to not be able to start the squeezecenter server. Went back to the original "line 115" error message...

Anyone able to sucessfully install under Mac OSX 10.5?

-Jeff


Still getting this error:

[08-08-03 20:03:41.9030] DBIx::Migration::migrate (115) Warning: Database error: Can't DROP 'rating'; check that column/key exists at /Library/PreferencePanes/SqueezeCenter.prefPane/Contents/server/CPAN/DBIx/Migration.pm line 115.
[08-08-03 20:03:41.9035] Slim::Schema::forceCommit (1483) Warning: Trying to commit transactions before DB is initialized!