Bugzilla – Bug 3528
Crash when trying to play an album from New Music
Last modified: 2008-09-15 14:39:24 UTC
2006-06-12 08:57:39.4843 ERROR: Request: Error when trying to run function coderef: [DBIx::Class::InflateColumn::update(): Not in database at P:\Music\SlimServer\trunk\server/Slim/Schema/DBI.pm line 33 ] 2006-06-12 08:57:39.4845 Request: Command [5e:31:13:06:25:02->playlist loadtracks] (Bad dispatch!) 2006-06-12 08:57:39.4846 Param: [_what] = [age=1301] 2006-06-12 08:57:39.5286 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 P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 525. DBIx::Class::ResultSet::create(): Error executing 'INSERT INTO playlist_track (playlist, position, track) VALUES (?, ?, ?)' (`16971', `0', `16663'): 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 P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 525.
What steps did you take to cause this? I'm unable to reproduce it.. Thanks.
I wasn't doing anything special. I was using softsqueeze (although I have seen the crash on SB2/3). I navigated to Browse -> New Music. I clicked down-arrow to select an album I recently ripped. I pressed play. This caused the crash. I tried a couple of New Music albums - each crashed the server. However, I just tried again this morning after an SVN update and it isn't crashing now. Perhaps some other change has fixed it? I'll try to recreate it for a while longer.
It's very possible another change fixed it.. Going to close the bug - please reopen if you can reproduce. Thanks.