Bugzilla – Bug 14813
Rhapsody Items in Playlists in 7.4 are blank
Last modified: 2009-11-11 10:08:00 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.
QA confirmed this error is in the Web UI only. Player UI is OK
Created attachment 6151 [details] web ui error
Do you get any error message in server.log when this happens? I can't test anymore, as Rhapsody has locked my account :-(
Created attachment 6159 [details] Rhapsody Log I enabled debug, but could not see anything in the log
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 on attachment 6159 [details] Rhapsody Log This log doesn't have errors
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?
> 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.
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
With the Internet Radio Log set enabled, I am seeing no errors in the server.log. What should I try next?
(In reply to comment #10) Please upload the log to this bug
Created attachment 6178 [details] Internet Radio Debug Log
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?
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?
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?
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.
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?
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.
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?