Bug 3262 - Crash on rescan when album moved/deleted
: Crash on rescan when album moved/deleted
Status: RESOLVED FIXED
Product: Logitech Media Server
Classification: Unclassified
Component: Database
: 6.5b1
: PC Debian Linux
: P2 major (vote)
: ---
Assigned To: Dan Sully
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2006-04-12 09:46 UTC by Max Spicer
Modified: 2006-04-12 09:48 UTC (History)
0 users

See Also:
Category: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Max Spicer 2006-04-12 09:46:34 UTC
I've just moved one of my albums to a different location in the folder that slimserver scans.  I then did a rescan for new and changed music and the server crashed with the following message:

2006-04-12 15:14:45.4696 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.
Can't delete file:///data/music/Borrowed/Air/Moon%20Safari/01-La%20Femme%20D%27Argent.flac: 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.
 at /usr/local/slimserver/Slim/DataStores/DBI/DBIStore.pm line 728
2006-04-12 15:14:45.6924 Shutting down plugins...
2006-04-12 15:14:45.7108 Grab Playlist Shutting Down -- 0.5

I doubt it's relevant, but I have two directories  at the top level of the scanned folder, one called Borrowed and one called CDs.  I moved a folder called Air, containing another folder called Moon Safari with flacs in it, from Borrowed to CDs (after a successful morning's shopping).

I'm running R6908 with my database held in MySQL.
Comment 1 Dan Sully 2006-04-12 09:48:26 UTC
Max - this should be fixed already. However, you'll need to drop and recreate your schema.

Please see change 6815