Bugzilla – Bug 15092
Foreign key constraint error when rescanning
Last modified: 2011-01-14 00:56:17 UTC
Created attachment 6291 [details] Error log I did a full rescan by running $ squeezeboxserver-scanner --wipe At the end, I got: Cannot add or update a child row: a foreign key constraint fails (`slimserver/contributor_album`, CONSTRAINT `contributor_album_ibfk_1` FOREIGN KEY (`album`) REFERENCES `albums` (`id`) ON DELETE CASCADE) See attached file for a more complete log. I'm running Ubuntu 9.04 (jaunty) with the latest deb from your repository (which is squeezeboxserver 7.4.1).
Created attachment 6292 [details] log I noticed at least one album was still missing, so I tried scanning just for it. The result was another internal error, which is perhaps related. [09-11-11 02:10:41.4455] Slim::Formats::Playlists::parseList (83) Error: While running $playlistClass->read(): [Can't call method "title" on an undefined value at /usr/share/perl5/Slim/Schema.pm line 2337. I'm attaching the full log of running $ squeezeboxserver-scanner /vault/Musik/Library/cue/david/Ray\ Abshire\ --\ Arrête\ pas\ la\ musique But maybe I should have opened a separate bug report for this.
David: thank you for the logs, can you attach a sample track/album (the one that is failing) to the bug so we can reproduce it locally
Created attachment 6294 [details] cue file There are two problems here, and I don't know how they relate. The "can't call method 'title'" is perhaps the old bug of non-ASCII characters in the path. I'm attaching the cue file, but see the log file for the full path to its location. The path to the referenced flac file also has non-ASCII. The foreign key problem is maybe an effect of this, or perhaps completely unrelated.
Moving P3 and lower bugs to next release target
Is this causing an issue other than the scanner error? I.e. is the affected file not getting added correctly to the database?
Move to Sqlite in 7.6 makes this obsolete