Bugzilla – Bug 2917
slimserver crashes when scanning itunesplaylist
Last modified: 2006-02-02 09:41:17 UTC
using SlimServer Version: 6.5b1 - 6019 - Linux - EN - utf8 with MySQL 4.1 on FC4 Linux and using itunes on a network share on a windows PC - was working fine with SQLlite 2006-02-02 15:56:03.4534 iTunes: Parsing next bit of XML.. 2006-02-02 15:56:03.4684 iTunes: got a playlist array of 58 items 2006-02-02 15:56:03.4705 iTunes: got a playlist (itunesplaylist:Podcasts) named Podcasts 2006-02-02 15:56:03.4824 New track for itunesplaylist:Podcasts 2006-02-02 15:56:03.4848 readTag was default for itunesplaylist:Podcasts 2006-02-02 15:56:03.4866 reading tags for: itunesplaylist:Podcasts 2006-02-02 15:56:03.4891 itu file type for itunesplaylist:Podcasts 2006-02-02 15:56:03.4913 Info: no title found, calculating title from url for itunesplaylist:Podcasts 2006-02-02 15:56:03.4931 Plain title for: itunesplaylist:Podcasts 2006-02-02 15:56:03.4952 is itunesplaylist:Podcasts 2006-02-02 15:56:03.4992 Adding itunesplaylist:Podcasts : tag to 1 2006-02-02 15:56:03.5014 Adding itunesplaylist:Podcasts : content_type to itu 2006-02-02 15:56:03.5034 Adding itunesplaylist:Podcasts : remote to 0 2006-02-02 15:56:03.5053 Adding itunesplaylist:Podcasts : titlesearch to ITUNES PODCASTS 2006-02-02 15:56:03.5072 Adding itunesplaylist:Podcasts : titlesort to ITUNES PODCASTS 2006-02-02 15:56:03.5092 Adding itunesplaylist:Podcasts : content_type to itu 2006-02-02 15:56:03.5111 Adding itunesplaylist:Podcasts : title to iTunes: Podcasts 2006-02-02 15:56:04.7621 forceCommit: syncing to the database. 2006-02-02 15:56:04.7927 Merging entry for file:///mirrora/tunes/Podcasts/In%20Our%20Time/Seventeenth%20Century%20Print%20Culture.mp3 2006-02-02 15:56:04.7962 Updating file:///mirrora/tunes/Podcasts/In%20Our%20Time/Seventeenth%20Century%20Print%20Culture.mp3 : remote to 0 2006-02-02 15:56:07.3895 DBD::mysql::st execute failed: Cannot delete or update a parent row: a foreign key constraint fails at /usr/local/slimserver/lib/Class/DBI.pm line 835, <ITUNESLIBRARY> chunk 41850. Can't delete Podcast: DBD::mysql::st execute failed: Cannot delete or update a parent row: a foreign key constraint fails at /usr/local/slimserver/lib/Class/DBI.pm line 835, <ITUNESLIBRARY> chunk 41850. at /usr/local/slimserver/Slim/DataStores/DBI/DBIStore.pm line 1692 2006-02-02 15:56:07.4443 Slim::DataStores::DBI::Track Slim::DataStores::DBI::Track=HASH(0xb94528c) destroyed without saving changes to remote at /usr/local/slimserver/Slim/DataStores/DBI/DBIStore.pm line 1064 2006-02-02 15:56:07.4501 forceCommit: syncing to the database. 2
this looks like bug 2850, a mysql issue
*** This bug has been marked as a duplicate of 2850 ***