PDA

View Full Version : slimserver 6.5 w/mysql crash advice



bklaas
2006-03-06, 21:11
Anyone ever see Slimserver w/MySQL crash like this when trying to play a track? Extra bonus points for making fun of my music selection!

But seriously, should I wipe the database and rescan? This isn't the first time this has happened...

2006-03-06 17:29:19.2308 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.
2006-03-06 17:29:19.2638 ERROR: execute: Error when trying to run coderef: [Can't delete file:///data/tunevault/new_additions/FisherPrice%20Little%20People%20-Songs%20For%20The%20Road/01%20-%20See%20See%20My%20Playmate.mp3: 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 721
]

2006-03-06 17:29:19.2641 Request: Command [00:04:20:05:81:92->playlist loadtracks] (Dispatchable)
2006-03-06 17:29:19.2642 Param: [_what] = [album=903&artist=954&contributor.role=15]
2006-03-06 17:29:27.5486 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.
2006-03-06 17:29:27.5496 ERROR: execute: Error when trying to run coderef: [Can't delete file:///data/tunevault/new_additions/FisherPrice%20Little%20People%20-Songs%20For%20The%20Road/01%20-%20See%20See%20My%20Playmate.mp3: 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 721
]

2006-03-06 17:29:27.5498 Request: Command [00:04:20:05:81:92->button] (Dispatchable)
2006-03-06 17:29:27.5499 Param: [_buttoncode] = [exit_right]
2006-03-06 17:29:27.5500 Param: [_time] = [1379689.803]
2006-03-06 17:29:27.5501 Param: [_orFunction] = [1]
2006-03-06 17:29:28.3222 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/tunevault/new_additions/FisherPrice%20Little%20People%20-Songs%20For%20The%20Road/01%20-%20See%20See%20My%20Playmate.mp3: 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 721
2006-03-06 17:29:28.3566 ERROR: Slim::Control::Command::clearExecuteCallback() has been deprecated!
2006-03-06 17:29:28.3568 ERROR: Please use Slim::Control::Request::unsubscribe() instead!
2006-03-06 17:29:28.3568 ERROR: Documentation is available in Slim::Control::Request.pm

*slimserver died here*

kdf
2006-03-06, 21:35
foreign key constraint crashes are a reported issue (seach "foreign
key")

as far as official word, mysql has not yet been reported as a
"supported" backend.

granted, it is planned.

-kdf

JJZolx
2006-03-06, 21:43
Anyone ever see Slimserver w/MySQL crash like this when trying to play a track? Extra bonus points for making fun of my music selection!
But seriously, should I wipe the database and rescan? This isn't the first time this has happened...
Yep. You need to wipe and rescan. It's probably bug #2850, generally caused by moving or renaming a folder.

http://bugs.slimdevices.com/show_bug.cgi?id=2850

bklaas
2006-03-06, 21:46
thanks, KDF.

I did some searching, but not the right keywords. I knew MySQL wasn't supported, which is why I came here and not bugs.slimdevices.com...

from reading previous posts, doesn't look like there's any workaround right now. Guess I'll just live with it for now, as I can't imagine going back to SQLLite after migrating to MySQL.

#!/ben