Bugzilla – Bug 8108
DB errors after upgrade cause SC to not run
Last modified: 2009-07-31 10:21:01 UTC
Squeeze center cant locate my server after upgrading software
Created attachment 3332 [details] sever log
Deleting the Cache folder appeared to fix the issue. Possible problem with the SQL database on an upgrade from 7.0 to 7.0.1 - 19597
[08-05-09 14:53:10.1875] Slim::Networking::Async::DNS::init (102) Warning: No DNS servers responded, falling back to OpenDNS. [08-05-09 14:53:10.2867] Slim::Schema::Storage::throw_exception (70) Error: DBI Connection failed: DBI connect('hostname=127.0.0.1;port=9092;database=slimserver','slimserver',...) failed: Can't connect to MySQL server on '127.0.0.1' (10013) at C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 652 [08-05-09 14:53:10.2871] Slim::Schema::Storage::throw_exception (70) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (C:/PROGRA~1/SQUEEZ~1/server/Slim/Schema/Storage.pm line 70) frame 1: Slim::Schema::Storage::throw_exception (C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 658) frame 2: DBIx::Class::Storage::DBI::_connect (C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 616) frame 3: DBIx::Class::Storage::DBI::_populate_dbh (C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 543) frame 4: DBIx::Class::Storage::DBI::ensure_connected (C:/PROGRA~1/SQUEEZ~1/server/Slim/Schema/Storage.pm line 29) frame 5: (eval) (C:/PROGRA~1/SQUEEZ~1/server/Slim/Schema/Storage.pm line 29) frame 6: Slim::Schema::Storage::dbh (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Schema.pm line 121) frame 7: Slim::Schema::init (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>Slim/Music/Info.pm line 76) frame 8: Slim::Music::Info::init (slimserver.pl line 348) frame 9: main::init (slimserver.pl line 451) frame 10: main::main (slimserver.pl line 88) frame 11: PerlSvc::Interactive (perlsvc line 855) frame 12: PerlSvc::_interactive (slimserver.pl line 0) frame 13: (eval) (slimserver.pl line 0)
Andy: I may need some help understanding the MySQL issues with this one.
*** Bug 8096 has been marked as a duplicate of this bug. ***
*** Bug 8045 has been marked as a duplicate of this bug. ***
While I have been able to replicate the errors in the Log files, I have only been able to get a failure 1 time (Vista x32) Re-testing the same vista system I was unable to get SC to fail. Doing an uninstall & removal of the SC folder from Program Files, then re-installing 7.0.1 fixes the issue. I suggest we leave this bug open, assigned to Tech Support, so they can monitor the issue.
This should not be assigned to me. Reassigning to James.
is this related to bug 9458 in any way?
*** Bug 9458 has been marked as a duplicate of this bug. ***
Moving monitor bugs
This appears to be fixed in SC 7.3.1, please verify with that version if you are still seeing this error. Re Open and update if you still see this issue.
Reduce number of active targets for SC