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

Warpme warpme at o2.pl
Fri Aug 26 21:45:59 UTC 2011


On 8/26/11 4:19 PM, Michael T. Dean wrote:
> On 08/26/2011 07:31 AM, Brian J. Murrell wrote:
>> On 11-08-26 04:39 AM, warpme wrote:
>>> Pls look for "MySQL reconnected successfully" string in be logs.
>>> In last 12 days, 600 rec I had 2 of them. Both exactly at the same:
>>>
>>> 1st:
>>> 2011-08-15 06:00:01.626423 I  Tuning recording: "Jak to jest zrobione?":"Jak to jest zrobione? (How It's Made), odc. 2": channel 15315 on cardid 5, sourceid 8
>>> 2011-08-15 06:00:01.627545 I  MySQL reconnected successfully
>>>
>>> 2nd:
>>> 2011-08-22 06:00:01.561354 I  Tuning recording: "Jak to jest zrobione?: Ołówki/Recykling metalu/Kawa": channel 15315 on cardid 5, sourceid 8
>>> 2011-08-22 06:00:01.562367 I  MySQL reconnected successfully
>> Interesting.  I have no such pattern:
>>
>> 2011-08-09 16:00:06.923299 I [20242/20259] Scheduler mythdbcon.cpp:234
>> (Reconnect) - MySQL reconnected successfully
>> 2011-08-11 08:59:59.367130 I [1559/2010] Scheduler mythdbcon.cpp:234
>> (Reconnect) - MySQL reconnected successfully
>> 2011-08-05 18:08:22.311 MySQL reconnected successfully
>> 2011-08-05 18:08:31.159 MySQL reconnected successfully
>> 2011-08-05 19:59:01.659 MySQL reconnected successfully
>> 2011-08-06 17:43:39.218 MySQL reconnected successfully
>> 2011-08-06 17:43:39.612 MySQL reconnected successfully
>> 2011-08-08 16:29:41.669276 I [1505/2283] Scheduler mythdbcon.cpp:234
>> (Reconnect) - MySQL reconnected successfully
>>
> warpme, maybe you have a database- or I/O-intensive cron job occurring
> once a week at 6:00am on Monday that causes problems?
>
> Mike
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users
>
Mike,

Indeed, at first glance it looks like cron-like behaviour (every 7-days, 
6:00AM)
That was also my suspect so I carefully checked cron configs & logs. 
Nothing relevant & worth to mention.
I can't find any aspect of my server configured to do something at 6:00AM.
I have to look on this in longer test window - maybe this will show 
something meaningful...
-br


-------------- next part --------------
A non-text attachment was scrubbed...
Name: warpme.vcf
Type: text/x-vcard
Size: 83 bytes
Desc: not available
Url : http://www.mythtv.org/pipermail/mythtv-users/attachments/20110826/23d4a6e3/attachment.vcf 


More information about the mythtv-users mailing list