Bug 4529 - Slimserver crash... DBD::mysql::st execute failed
: Slimserver crash... DBD::mysql::st execute failed
Status: RESOLVED WORKSFORME
Product: Logitech Media Server
Classification: Unclassified
Component: Misc
: 6.5.1
: PC Windows XP
: P2 normal (vote)
: ---
Assigned To: Chris Owens
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2006-11-21 11:30 UTC by Yann Oehl
Modified: 2007-02-05 08:47 UTC (History)
1 user (show)

See Also:
Category: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Yann Oehl 2006-11-21 11:30:53 UTC
Here;s the message from my Event Viewer log:
The Crash occured near the end of a track (-10 sec)... about where the next track would begin to crossfade in.
I'm using the dynamic transition plugin, as well as Erlands suite of goodies.

Event Type:	Error
Event Source:	Application
Event Category:	None
Event ID:	0
Date:		11/21/2006
Time:		11:18:55 AM
User:		N/A
Computer:	MEDIACENTER
Description:
The description for Event ID ( 0 ) in Source ( Application ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Carp::Clan::__ANON__(): Error executing 'UPDATE tracks SET lastplayed = ?, playcount = ? WHERE ( id = ? )': DBD::mysql::st execute failed: Lock wait timeout exceeded; try restarting transaction at C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.
.

This occured a few minutes after this:

Event Type:	Information
Event Source:	Media Center Scheduler
Event Category:	None
Event ID:	4
Date:		11/21/2006
Time:		11:16:41 AM
User:		N/A
Computer:	MEDIACENTER
Description:
The next scheduled download of the latest television listings guide (EPG) is 11/22/2006 11:13:56.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Comment 1 Chris Owens 2007-02-01 19:45:45 UTC
Hi Yann

Were you actively playing content when the crash occurred?  Doing something in the UI?  I'm trying to figure out what I could do to try to reproduce the bug here.
Comment 2 Yann Oehl 2007-02-01 19:51:51 UTC
(In reply to comment #1)
> Hi Yann
> 
> Were you actively playing content when the crash occurred?  Doing something in
> the UI?  I'm trying to figure out what I could do to try to reproduce the bug
> here.
> 

Hmmm.... can't remember, it was a long time ago... and honestly it hasn't reoccured lately. Feel free to kill this bug for now. I appreciate you looking into it.
Comment 3 Chris Owens 2007-02-05 08:47:53 UTC
I put a bit more information in the summary to make it easier to search for.  If anyone else runs across this, please feel free to re-open it!