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

[David Edwards]

On 28 July 2011 09:23, warpme <warpme at o2.pl> wrote:

> Have You any hint about extended logging in MySQL/Qt for looking closely on
> problem ?
>

If you remove the patch, you might be able to replicate the problem by
manually killing the open connections on MySQL; using the mysql command line
client, do a SHOW PROCESSLIST to see the open connections, and use "KILL
<connection id>" to make the server drop the connection. This might confirm
that a stale connection can cause the stack traces you are seeing.

If the problem is reconnections, then as you say, identifying the root cause
could be worthwhile - especially if you think the connections are being
dropped prematurely (ie, before MySQL hits its timeout for inactivity). You
could try turning on the MySQL General Query Log - if I remember correctly,
that logs connections and disconnections.

David
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.mythtv.org/pipermail/mythtv-users/attachments/20110728/e0657574/attachment.html