[mythtv-users] MySQL related BE deadlocks - collective wisdom needed

Dan Wilga mythtv-users2 at dwilga-linux1.amherst.edu
Wed Jul 27 12:48:05 UTC 2011


On 7/27/11 5:48 AM, warpme wrote:
> Well,
> Having 30min Yesterday evening I recompile BE with above 2 lines commented in mythdbconn.cpp.
> Unfortunately today I had deadlock again. This time it was in scheduler. Trace is again well known:
>    
Trying another angle on the disconnection idea, could you please post 
the contents of your /etc/my.cnf file? I'm mostly interested in the 
wait_timeout parameter, if there is one, but the whole thing might help.

Also, have you posted the contents of a "SHOW PROCESSLIST;" when the 
database is locked? I don't recall seeing one yet.

-- 
Dan Wilga                                                        "Ook."



More information about the mythtv-users mailing list