Bug 14813 - Rhapsody Items in Playlists in 7.4 are blank
: Rhapsody Items in Playlists in 7.4 are blank
Status: RESOLVED WORKSFORME
Product: Logitech Media Server
Classification: Unclassified
Component: Web Interface
: 7.4.0
: PC Ubuntu Linux
: -- normal (vote)
: Investigating
Assigned To: Squeezebox QA Team email alias
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2009-10-16 15:10 UTC by Ted Cabeen
Modified: 2009-11-11 10:08 UTC (History)
3 users (show)

See Also:
Category: ---


Attachments
web ui error (72.14 KB, image/jpeg)
2009-10-17 12:45 UTC, James Richardson
Details
Rhapsody Log (4.68 KB, text/plain)
2009-10-18 07:51 UTC, James Richardson
Details
Yesterdays Log (27.88 KB, text/plain)
2009-10-18 07:54 UTC, James Richardson
Details
Internet Radio Debug Log (18.75 KB, text/plain)
2009-10-20 11:58 UTC, Ted Cabeen
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Ted Cabeen 2009-10-16 15:10:58 UTC
Since upgrading to 7.4, any items in my playlists that come from Rhapsody are blank in the playlist.  When the song is actually played, the cover, artist and track information show up, but it still shows as blank in the playlist and in the queue.  

I've rescanned the playlists, but to no effect.
Comment 1 James Richardson 2009-10-17 12:44:49 UTC
QA confirmed this error is in the Web UI only.  Player UI is OK
Comment 2 James Richardson 2009-10-17 12:45:18 UTC
Created attachment 6151 [details]
web ui error
Comment 3 Michael Herger 2009-10-18 04:54:06 UTC
Do you get any error message in server.log when this happens? I can't test anymore, as Rhapsody has locked my account :-(
Comment 4 James Richardson 2009-10-18 07:51:17 UTC
Created attachment 6159 [details]
Rhapsody Log

I enabled debug, but could not see anything in the log
Comment 5 James Richardson 2009-10-18 07:54:41 UTC
Created attachment 6160 [details]
Yesterdays Log

well, when I went to test it this morning, it was working fine.  Attached is the log from yesterday, when it was NOT working..> This long has errors in it.  Could this be a rhapsody issue?
Comment 6 James Richardson 2009-10-18 07:55:11 UTC
Comment on attachment 6159 [details]
Rhapsody Log

This log doesn't have errors
Comment 7 Ted Cabeen 2009-10-18 12:33:23 UTC
I'm not seeing an error here that triggers when it happens.  I did get the following error, but I think it's unrelated:

[09-10-18 12:30:15.8580] Slim::Schema::Storage::throw_exception (82) Error: DBI Exception: DBD::mysql::st execute failed: MySQL server has gone away [for Statement "SELECT me.name, me.value FROM metainformation me WHERE ( name = ? )"]
[09-10-18 12:30:15.8587] Slim::Schema::Storage::throw_exception (82) Backtrace:

   frame 0: Slim::Utils::Log::logBacktrace (/usr/share/perl5/Slim/Schema/Storage.pm line 82)
   frame 1: Slim::Schema::Storage::throw_exception (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 957)
   frame 2: DBIx::Class::Storage::DBI::__ANON__ (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 1217)
   frame 3: DBIx::Class::Storage::DBI::_dbh_execute (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 547)
   frame 4: (eval) (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 540)
   frame 5: DBIx::Class::Storage::DBI::dbh_do (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 1227)
   frame 6: DBIx::Class::Storage::DBI::_execute (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 1451)
   frame 7: DBIx::Class::Storage::DBI::_select (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 1905)
   frame 8: DBIx::Class::Storage::DBI::select_single (/usr/share/squeezeboxserver/CPAN/DBIx/Class/ResultSet.pm line 740)
   frame 9: DBIx::Class::ResultSet::single (/usr/share/perl5/Slim/Schema.pm line 585)
   frame 10: Slim::Schema::single (/usr/share/perl5/Slim/Music/Import.pm line 725)
   frame 11: Slim::Music::Import::stillScanning (/usr/share/perl5/Slim/Web/Pages/Common.pm line 60)
   frame 12: Slim::Web::Pages::Common::addLibraryStats (/usr/share/perl5/Slim/Web/Pages/Home.pm line 206)
   frame 13: Slim::Web::Pages::Home::home (/usr/share/perl5/Slim/Web/Pages/Home.pm line 29)
   frame 14: Slim::Web::Pages::Home::__ANON__ (/usr/share/perl5/Slim/Web/HTTP.pm line 1086)
   frame 15: Slim::Web::HTTP::generateHTTPResponse (/usr/share/perl5/Slim/Web/HTTP.pm line 913)
   frame 16: Slim::Web::HTTP::processURL (/usr/share/perl5/Slim/Web/HTTP.pm line 724)
   frame 17: Slim::Web::HTTP::processHTTP (/usr/share/perl5/Slim/Networking/IO/Select.pm line 133)
   frame 18: (eval) (/usr/share/perl5/Slim/Networking/IO/Select.pm line 119)
   frame 19: Slim::Networking::IO::Select::__ANON__ (/usr/share/perl5/Slim/Networking/IO/Select.pm line 177)
   frame 20: (eval) (/usr/share/perl5/Slim/Networking/IO/Select.pm line 177)
   frame 21: Slim::Networking::IO::Select::loop (/usr/sbin/squeezeboxserver line 620)
   frame 22: main::idle (/usr/sbin/squeezeboxserver line 574)
   frame 23: main::main (/usr/sbin/squeezeboxserver line 1103)

Should I test with debug on?
Comment 8 Michael Herger 2009-10-19 01:57:23 UTC
> I'm not seeing an error here that triggers when it happens.  I did get the
> following error, but I think it's unrelated:
> 
> [09-10-18 12:30:15.8580] Slim::Schema::Storage::throw_exception (82) Error: DBI
> Exception: DBD::mysql::st execute failed: MySQL server has gone away [for

If your database goes away, then you'd see any kind of weirdness. This could very well be the reason for the failure you've been seeing.
Comment 9 Michael Herger 2009-10-19 01:59:08 UTC
QA - lack of access to rhapsody I can't do anything here. As you're able to reproduce this, please enable logging for the "internetradio" log group, then upload the resulting server.log
Comment 10 Ted Cabeen 2009-10-20 11:49:07 UTC
With the Internet Radio Log set enabled, I am seeing no errors in the server.log.  What should I try next?
Comment 11 James Richardson 2009-10-20 11:54:55 UTC
(In reply to comment #10)
Please upload the log to this bug
Comment 12 Ted Cabeen 2009-10-20 11:58:15 UTC
Created attachment 6178 [details]
Internet Radio Debug Log
Comment 13 James Richardson 2009-10-30 12:11:11 UTC
Ted: Have you upgraded to 7.4.1 yet?  I have not been able to replicate this issue and feel 7.4.1 may have resolved the issue.  There was another playlist bug that was addressed, which may have resolved this issue.

Can you please test with 7.4.1 then let me know if the issue is resolved for you?
Comment 14 Ted Cabeen 2009-10-30 12:38:34 UTC
I upgraded to 7.4.1 and rescanned the playlists, but I'm still seeing the blank items.  Is there any debugging information I can send you that would help?
Comment 15 James Richardson 2009-10-30 13:51:47 UTC
Are you using Rhapsody's pre-built play-lists? or making your own play-lists with Rhapsody Tracks in them?

If you create a NEW playlist does the same thing happen?

Is this happening for any other service or just Rhapsody?

Please try clearing your Internet Cache as well as the SBS cache.  Does that resolve the issue?
Comment 16 James Richardson 2009-11-05 09:48:13 UTC
Please re-test this issue.  There was an issue with Rhapsody, that they have fixed, that should resolve this issue.

If not, please contact rhapsody support.
Comment 17 Ted Cabeen 2009-11-10 16:48:49 UTC
I'm making my own playlists in squeezeboxserver that contain both rhapsody and non-rhapsody song.

It's fixed now for new playlists.

However, the old playlists are still broken, even after a Clear Database and Rebuild.  Is there a way to get the old tracks fixed?
Comment 18 James Richardson 2009-11-11 06:45:33 UTC
Ted: I don't think there will be, as Rhapsody changed it's paths.  you will have to rebuild the play lists, until the next time Rhapsody changes track paths when this problem will happen again.
Comment 19 Ted Cabeen 2009-11-11 10:08:00 UTC
Interesting.  Will the old track paths always work, or should I spend the time to backup the playlists now in case the old tracks stop working entirely some time in the future?