Bug 13137 – Playlist getting stuck randomly, unable to move to next track

Bug 13137 - Playlist getting stuck randomly, unable to move to next track

Summary:

Playlist getting stuck randomly, unable to move to next track

Status:	CLOSED FIXED

Product:	Logitech Media Server
Classification:	Unclassified
Component:	Streaming From SlimServer
Version:	7.3.3
Platform:	PC Windows XP

Importance:	-- normal (vote)
Target Milestone:	7.4.0
Assigned To:	Squeezebox QA Team email alias

URL:
Keywords:

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2009-07-30 09:50 UTC by Mark
Modified:	2009-10-05 14:26 UTC (History)
CC List:	2 users (show)

See Also:
Category:	Bug

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Mark 2009-07-30 09:50:29 UTC

When running a playlist (either a list of tracks I selected or a random list)after some time (could be a couple of tracks, could be a couple of hours) it stops playing. When I look at the duet controller it just shows the last track and says 'stopped' if I hit pause it just starts playing the last track again and will stop again at the end of it, if I try to hit forward to the next track, it just ignores me and won't do it, I usually can't delete the last track from the listing either(but it did let me today with a playlist I selected, not a random playlist) all I can do is keep replaying the last track, so I usually go back to random song mix and start again which is fustrating.
It also won't let me select or skip over this track from the playlist, it just starts playing the last track again.

I'm running versions 7.3.3-27044 and 7.3 r6038, the same problem ocurred with the previous version, I was hoping an upgrade would cure it.
My SB is RJ45 wired to the router using a home plug to get to my PC, the controller is always in very close range to the router and since doing this I vary rarely have network connection issues.
I raised a ticket with the Logitech helpdesk #090730-003990

Here's the last 100 lines from the log, it failed just before 16:00

	file:///C:/Documents%20and%20Settings/Mags/My%20Documents/My%20Music/M.O.S%20Mash%20Up%20Mix%202009/CD%201/[VA]_The_Mash_Up_Mix_2009.m3u doesn't exist on disk - skipping!
[09-07-30 15:53:57.3849] Slim::Schema::Storage::throw_exception (81) Error: Error executing 'INSERT INTO playlist_track (playlist, position, track) VALUES (?, ?, ?)': DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`slimserver/playlist_track`, CONSTRAINT `playlist_track_ibfk_1` FOREIGN KEY (`track`) REFERENCES `tracks` (`id`) ON DELETE CASCADE) at /<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>DBIx/Class/Storage/DBI.pm line 771.
[09-07-30 15:53:57.3858] Slim::Schema::Storage::throw_exception (81) Backtrace:

   frame 0: Slim::Utils::Log::logBacktrace (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>Slim/Schema/Storage.pm line 81)
   frame 1: Slim::Schema::Storage::throw_exception (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>DBIx/Class/Storage/DBI.pm line 773)
   frame 2: DBIx::Class::Storage::DBI::_execute (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>DBIx/Class/Storage/DBI.pm line 788)
   frame 3: DBIx::Class::Storage::DBI::insert (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>DBIx/Class/Row.pm line 75)
   frame 4: DBIx::Class::Row::insert (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>DBIx/Class/PK/Auto.pm line 43)
   frame 5: DBIx::Class::PK::Auto::insert (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>DBIx/Class/ResultSet.pm line 1337)
   frame 6: DBIx::Class::ResultSet::create (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>Slim/Schema/Playlist.pm line 108)
   frame 7: Slim::Schema::Playlist::_addTracksToPlaylist (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>Slim/Schema/Playlist.pm line 45)
   frame 8: Slim::Schema::Playlist::__ANON__ (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>DBIx/Class/Schema.pm line 584)
   frame 9: (eval) (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>DBIx/Class/Schema.pm line 572)
   frame 10: DBIx::Class::Schema::txn_do (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>Slim/Schema/Playlist.pm line 46)
   frame 11: (eval) (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>Slim/Schema/Playlist.pm line 39)
   frame 12: Slim::Schema::Playlist::setTracks (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>Slim/Player/Playlist.pm line 868)
   frame 13: Slim::Player::Playlist::modifyPlaylistCallback (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>Slim/Control/Request.pm line 2072)
   frame 14: (eval) (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>Slim/Control/Request.pm line 2072)
   frame 15: Slim::Control::Request::notify (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>Slim/Control/Request.pm line 846)
   frame 16: Slim::Control::Request::checkNotifications (slimserver.pl line 517)
   frame 17: main::idle (slimserver.pl line 44)
   frame 18: PerlSvc::Startup (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>PerlSvc.pm line 95)
   frame 19: PerlSvc::_startup (slimserver.pl line 0)
   frame 20: (eval) (slimserver.pl line 0)

[09-07-30 15:53:57.4280] Slim::Schema::throw_exception (288) Error: Carp::Clan::__ANON__(): Error executing 'INSERT INTO playlist_track (playlist, position, track) VALUES (?, ?, ?)': DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`slimserver/playlist_track`, CONSTRAINT `playlist_track_ibfk_1` FOREIGN KEY (`track`) REFERENCES `tracks` (`id`) ON DELETE CASCADE) at /<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>DBIx/Class/Storage/DBI.pm line 771.
[09-07-30 15:53:57.4287] Slim::Schema::throw_exception (288) Backtrace:

   frame 0: Slim::Utils::Log::logBacktrace (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>Slim/Schema.pm line 288)
   frame 1: Slim::Schema::throw_exception (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>DBIx/Class/Schema.pm line 606)
   frame 2: DBIx::Class::Schema::txn_do (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>Slim/Schema/Playlist.pm line 46)
   frame 3: (eval) (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>Slim/Schema/Playlist.pm line 39)
   frame 4: Slim::Schema::Playlist::setTracks (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>Slim/Player/Playlist.pm line 868)
   frame 5: Slim::Player::Playlist::modifyPlaylistCallback (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>Slim/Control/Request.pm line 2072)
   frame 6: (eval) (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>Slim/Control/Request.pm line 2072)
   frame 7: Slim::Control::Request::notify (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>Slim/Control/Request.pm line 846)
   frame 8: Slim::Control::Request::checkNotifications (slimserver.pl line 517)
   frame 9: main::idle (slimserver.pl line 44)
   frame 10: PerlSvc::Startup (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>PerlSvc.pm line 95)
   frame 11: PerlSvc::_startup (slimserver.pl line 0)
   frame 12: (eval) (slimserver.pl line 0)

[09-07-30 15:59:14.5443] Slim::Formats::readTags (163) File missing: C:\Documents and Settings\Mags\My Documents\My Music\Downloads Completed\Sound System - Dreamscape.mp3
[09-07-30 15:59:14.5449] Slim::Player::Song::new (57) Error: Could not find an object for [Slim::Schema::Track=HASH(0x66b43d8)]!
[09-07-30 15:59:55.1220] Slim::Formats::readTags (163) File missing: C:\Documents and Settings\Mags\My Documents\My Music\Downloads Completed\Sound System - Dreamscape.mp3
[09-07-30 15:59:55.1226] Slim::Player::Song::new (57) Error: Could not find an object for [Slim::Schema::Track=HASH(0x66b43d8)]!
[09-07-30 15:59:57.6258] Slim::Formats::readTags (163) File missing: C:\Documents and Settings\Mags\My Documents\My Music\Downloads Completed\Sound System - Dreamscape.mp3
[09-07-30 15:59:57.6265] Slim::Player::Song::new (57) Error: Could not find an object for [Slim::Schema::Track=HASH(0x66b43d8)]!
[09-07-30 15:59:58.9998] Slim::Formats::readTags (163) File missing: C:\Documents and Settings\Mags\My Documents\My Music\Downloads Completed\Sound System - Dreamscape.mp3
[09-07-30 15:59:59.0003] Slim::Player::Song::new (57) Error: Could not find an object for [Slim::Schema::Track=HASH(0x66b43d8)]!
[09-07-30 16:00:00.4064] Slim::Formats::readTags (163) File missing: C:\Documents and Settings\Mags\My Documents\My Music\Downloads Completed\Sound System - Dreamscape.mp3
[09-07-30 16:00:00.4070] Slim::Player::Song::new (57) Error: Could not find an object for [Slim::Schema::Track=HASH(0x66b43d8)]!
[09-07-30 16:35:02.7938] Slim::Formats::readTags (163) File missing: C:\Documents and Settings\Mags\My Documents\My Music\Downloads Completed\Sound System - Dreamscape.mp3
[09-07-30 16:35:02.7944] Slim::Player::Song::new (57) Error: Could not find an object for [Slim::Schema::Track=HASH(0x66b43d8)]!
[09-07-30 16:35:08.9380] Slim::Formats::readTags (163) File missing: C:\Documents and Settings\Mags\My Documents\My Music\Downloads Completed\Sound System - Dreamscape.mp3
[09-07-30 16:35:08.9385] Slim::Player::Song::new (57) Error: Could not find an object for [Slim::Schema::Track=HASH(0x66b43d8)]!
[09-07-30 16:35:09.0433] Slim::Schema::Storage::throw_exception (81) Error: Error executing 'INSERT INTO playlist_track (playlist, position, track) VALUES (?, ?, ?)': DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`slimserver/playlist_track`, CONSTRAINT `playlist_track_ibfk_1` FOREIGN KEY (`track`) REFERENCES `tracks` (`id`) ON DELETE CASCADE) at /<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>DBIx/Class/Storage/DBI.pm line 771.
[09-07-30 16:35:09.0441] Slim::Schema::Storage::throw_exception (81) Backtrace:

   frame 0: Slim::Utils::Log::logBacktrace (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>Slim/Schema/Storage.pm line 81)
   frame 1: Slim::Schema::Storage::throw_exception (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>DBIx/Class/Storage/DBI.pm line 773)
   frame 2: DBIx::Class::Storage::DBI::_execute (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>DBIx/Class/Storage/DBI.pm line 788)
   frame 3: DBIx::Class::Storage::DBI::insert (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>DBIx/Class/Row.pm line 75)
   frame 4: DBIx::Class::Row::insert (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>DBIx/Class/PK/Auto.pm line 43)
   frame 5: DBIx::Class::PK::Auto::insert (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>DBIx/Class/ResultSet.pm line 1337)
   frame 6: DBIx::Class::ResultSet::create (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>Slim/Schema/Playlist.pm line 108)
   frame 7: Slim::Schema::Playlist::_addTracksToPlaylist (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>Slim/Schema/Playlist.pm line 45)
   frame 8: Slim::Schema::Playlist::__ANON__ (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>DBIx/Class/Schema.pm line 584)
   frame 9: (eval) (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>DBIx/Class/Schema.pm line 572)
   frame 10: DBIx::Class::Schema::txn_do (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>Slim/Schema/Playlist.pm line 46)
   frame 11: (eval) (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>Slim/Schema/Playlist.pm line 39)
   frame 12: Slim::Schema::Playlist::setTracks (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>Slim/Player/Playlist.pm line 868)
   frame 13: Slim::Player::Playlist::modifyPlaylistCallback (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>Slim/Control/Request.pm line 2072)
   frame 14: (eval) (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>Slim/Control/Request.pm line 2072)
   frame 15: Slim::Control::Request::notify (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>Slim/Control/Request.pm line 846)
   frame 16: Slim::Control::Request::checkNotifications (slimserver.pl line 517)
   frame 17: main::idle (slimserver.pl line 44)
   frame 18: PerlSvc::Startup (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>PerlSvc.pm line 95)
   frame 19: PerlSvc::_startup (slimserver.pl line 0)
   frame 20: (eval) (slimserver.pl line 0)

[09-07-30 16:35:09.0892] Slim::Schema::throw_exception (288) Error: Carp::Clan::__ANON__(): Error executing 'INSERT INTO playlist_track (playlist, position, track) VALUES (?, ?, ?)': DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`slimserver/playlist_track`, CONSTRAINT `playlist_track_ibfk_1` FOREIGN KEY (`track`) REFERENCES `tracks` (`id`) ON DELETE CASCADE) at /<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>DBIx/Class/Storage/DBI.pm line 771.
[09-07-30 16:35:09.0899] Slim::Schema::throw_exception (288) Backtrace:

   frame 0: Slim::Utils::Log::logBacktrace (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>Slim/Schema.pm line 288)
   frame 1: Slim::Schema::throw_exception (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>DBIx/Class/Schema.pm line 606)
   frame 2: DBIx::Class::Schema::txn_do (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>Slim/Schema/Playlist.pm line 46)
   frame 3: (eval) (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>Slim/Schema/Playlist.pm line 39)
   frame 4: Slim::Schema::Playlist::setTracks (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>Slim/Player/Playlist.pm line 868)
   frame 5: Slim::Player::Playlist::modifyPlaylistCallback (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>Slim/Control/Request.pm line 2072)
   frame 6: (eval) (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>Slim/Control/Request.pm line 2072)
   frame 7: Slim::Control::Request::notify (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>Slim/Control/Request.pm line 846)
   frame 8: Slim::Control::Request::checkNotifications (slimserver.pl line 517)
   frame 9: main::idle (slimserver.pl line 44)
   frame 10: PerlSvc::Startup (/<C:\Program Files\SqueezeCenter\server\squeezecenter.exe>PerlSvc.pm line 95)
   frame 11: PerlSvc::_startup (slimserver.pl line 0)
   frame 12: (eval) (slimserver.pl line 0)

Comment 1 James Richardson 2009-07-30 10:37:29 UTC

Mark: Can you try SC 7.4, this sounds like a problem with SC which may have been address in the latest beta version.

Comment 2 Mark 2009-07-30 10:59:03 UTC

No problem, where do I get this, I looked here: http://downloads.slimdevices.com/nightly/index.php?ver=7.4 but don't see Squeeze Centre for Windows, only Squeeze Server, is that the right file?

Comment 3 James Richardson 2009-07-30 11:00:24 UTC

Yep, that's the correct URL.

The names are changing :)

Comment 4 Mark 2009-07-30 11:11:44 UTC

Thx, OK, upgraded to 7.4, UI looks totally different!
Lets see how things go over the next few days...

Comment 5 Mark 2009-08-04 05:27:09 UTC

Hi, This appears to be solved now, I've not had this problem since running 7.4.

Thanks

Mark

Comment 6 James Richardson 2009-10-05 14:26:49 UTC

This bug has been marked as fixed in the 7.4.0 release version of SqueezeBox Server!
    * SqueezeCenter: 28672
    * Squeezebox 2 and 3: 130
    * Transporter: 80
    * Receiver: 65
    * Boom: 50
    * Controller: 7790
    * Radio: 7790  

Please see the Release Notes for all the details: http://wiki.slimdevices.com/index.php/Release_Notes

If you haven't already, please download and install the new version from http://www.logitechsqueezebox.com/support/download-squeezebox-server.html

If you are still experiencing this problem, feel free to reopen the bug with your new comments and we'll have another look.