Bug 8108 - DB errors after upgrade cause SC to not run
: DB errors after upgrade cause SC to not run
Status: CLOSED FIXED
Product: Logitech Media Server
Classification: Unclassified
Component: Scanner
: 7.0.1
: PC Windows XP
: -- normal (vote)
: 7.x
Assigned To: Unassigned bug - please assign me!
:
Depends on: 9377
Blocks: 8096 9458
  Show dependency treegraph
 
Reported: 2008-05-09 15:45 UTC by Michael McPartland
Modified: 2009-07-31 10:21 UTC (History)
6 users (show)

See Also:
Category: ---


Attachments
sever log (15.75 KB, application/octet-stream)
2008-05-09 15:46 UTC, Michael McPartland
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Michael McPartland 2008-05-09 15:45:25 UTC
Squeeze center cant locate my server after upgrading software
Comment 1 Michael McPartland 2008-05-09 15:46:25 UTC
Created attachment 3332 [details]
sever log
Comment 2 James Richardson 2008-05-09 16:18:13 UTC
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
Comment 3 James Richardson 2008-05-09 16:19:30 UTC
[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)
Comment 4 James Richardson 2008-05-12 09:36:04 UTC
Andy:

I may need some help understanding the MySQL issues with this one.
Comment 5 James Richardson 2008-05-12 12:05:18 UTC
*** Bug 8096 has been marked as a duplicate of this bug. ***
Comment 6 James Richardson 2008-05-12 12:05:41 UTC
*** Bug 8045 has been marked as a duplicate of this bug. ***
Comment 7 James Richardson 2008-05-12 13:58:06 UTC
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.
Comment 8 Dan Evans 2008-07-30 09:09:38 UTC
This should not be assigned to me.  Reassigning to James.
Comment 9 James Richardson 2008-07-31 10:16:22 UTC
*** Bug 8096 has been marked as a duplicate of this bug. ***
Comment 10 Dan Evans 2008-09-18 08:51:27 UTC
is this related to bug 9458 in any way?
Comment 11 James Richardson 2008-09-20 15:36:26 UTC
*** Bug 9458 has been marked as a duplicate of this bug. ***
Comment 12 James Richardson 2008-10-02 07:37:58 UTC
Moving monitor bugs
Comment 13 James Richardson 2009-01-07 11:09:50 UTC
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.
Comment 14 Chris Owens 2009-07-31 10:21:01 UTC
Reduce number of active targets for SC