Bugzilla – Bug 3608
Crash when random mix alarm fired
Last modified: 2008-09-15 14:39:24 UTC
Slimserver is set to play a random song mix each morning at 7:30am. This has been working fine with split-scanner all week, but this morning I had a crash at 7:30:05: 2006-06-19 07:30:04.4756 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 35 ] 2006-06-19 07:30:04.4767 Request: Command [00:04:20:06:38:3c->playlist loadtracks] (Bad dispatch!) 2006-06-19 07:30:04.4771 Param: [_what] = [track.id=6279] 2006-06-19 07:30:04.5644 Argument "level" isn't numeric in addition (+) at P:\Music\SlimServer\trunk\server/Slim/Web/Pages/Status.pm line 137. 2006-06-19 07:30:04.5650 Argument "level" isn't numeric in addition (+) at P:\Music\SlimServer\trunk\server/Slim/Web/Pages/Status.pm line 138. 2006-06-19 07:30:04.7550 Argument "level" isn't numeric in addition (+) at P:\Music\SlimServer\trunk\server/Slim/Web/Pages/Status.pm line 137. 2006-06-19 07:30:04.7557 Argument "level" isn't numeric in addition (+) at P:\Music\SlimServer\trunk\server/Slim/Web/Pages/Status.pm line 138. 2006-06-19 07:30:04.9639 Argument "level" isn't numeric in addition (+) at P:\Music\SlimServer\trunk\server/Slim/Web/Pages/Status.pm line 137. 2006-06-19 07:30:04.9645 Argument "level" isn't numeric in addition (+) at P:\Music\SlimServer\trunk\server/Slim/Web/Pages/Status.pm line 138. 2006-06-19 07:30:05.3593 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 (?, ?, ?)' (`7725', `0', `6279'): 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.
Phil - has this happened again? I just put in some extra debugging that will be in the June 27th nightly. Thanks
I haven't seen it crash since.
Ok - I'll have our QA hit the Alarm & Random mix functions as part of his testing. Closing this for now - please reopen if you see it again. Thanks