Bug 3583 – database crash

Bug 3583 - database crash

Summary:

database crash

Status:	RESOLVED WORKSFORME

Product:	SB Transporter
Classification:	Unclassified
Component:	SB Server
Version:	unspecified
Platform:	PC Other

Importance:	P2 normal (vote)
Target Milestone:	---
Assigned To:	Dan Sully

URL:
Keywords:

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2006-06-16 12:35 UTC by Richard Titmuss
Modified:	2009-09-08 09:14 UTC (History)
CC List:	0 users

See Also:
Category:	---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Richard Titmuss 2006-06-16 12:35:26 UTC

this was the backtrace:

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
/home/richard/slimserver-svn/shocker/server/CPAN/DBIx/Class/Storage/DBI.pm
line 525.
DBIx::Class::ResultSet::create(): Error executing 'INSERT INTO playlist_track
(playlist, position, track) VALUES (?, ?, ?)' (`2469', `0', `1368'):
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
/home/richard/slimserver-svn/shocker/server/CPAN/DBIx/Class/Storage/DBI.pm
line 525.
060616 20:36:02 [Note]
/home/richard/slimserver-svn/shocker/server/Bin/i386-linux/mysqld: Normal
shutdown

Comment 1 Blackketter Dean 2006-06-16 12:49:43 UTC

dan: does this look familiar to you?

Comment 2 Dan Sully 2006-06-16 12:53:03 UTC

No.. not seen it before. What caused it?

Comment 3 Richard Titmuss 2006-06-16 13:02:39 UTC

I was in the browse menu (probably by artist) and selected a track. I'm afraid I was not actually paying that much attention to what I was doing.

Comment 4 Dan Sully 2006-08-11 14:22:28 UTC

I've not seen this anywhere but here.. if you can reproduce, please reopen.

Thanks