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

Brian J. Murrell brian at interlinx.bc.ca
Fri Aug 5 21:08:02 UTC 2011


On 11-08-05 12:15 AM, Michael T. Dean wrote:
> 
> I posted a lightly-tested backport on 
> http://code.mythtv.org/trac/ticket/9704 .  You can download it at:
> 
> http://code.mythtv.org/trac/raw-attachment/ticket/9704/mythtv-0.24-backport_reconnect_fixes.patch

So I applied this and just finished with a couple of recordings.  A new
artifact since applying this patch (on top of v0.24.1-61-gcccad82) is
that a recording failed due to running out of disk on the storage directory.

This has _never_ happened before as the free space manager always
maintains enough free space to allow even multiple recordings to a
single storage directory occur.

This happened more than 30 minutes ago leaving only 4KB in the storage
directory:

$ df -k /storage1
Filesystem           1K-blocks      Used Available Use% Mounted on
/dev/sdb             480721640 456302308         4 100% /storage1

and even now, more than 30 minutes later, nothing has been removed to
free up space.

AutoExpire has been running since I applied that patch, but not since
that storage directory filled up at ~16:30:

2011-08-05 11:59:13.835 AutoExpire: CalcParams(): Max required Free
Space: 1.0 GB w/freq: 15 min
2011-08-05 12:14:14.114 AutoExpire: CalcParams(): Max required Free
Space: 1.0 GB w/freq: 15 min
2011-08-05 12:29:14.746 AutoExpire: CalcParams(): Max required Free
Space: 1.0 GB w/freq: 15 min
2011-08-05 12:44:15.204 AutoExpire: CalcParams(): Max required Free
Space: 1.0 GB w/freq: 15 min
2011-08-05 12:59:15.658 AutoExpire: CalcParams(): Max required Free
Space: 1.0 GB w/freq: 15 min
2011-08-05 13:14:16.116 AutoExpire: CalcParams(): Max required Free
Space: 1.0 GB w/freq: 15 min
2011-08-05 13:29:16.575 AutoExpire: CalcParams(): Max required Free
Space: 1.0 GB w/freq: 15 min
2011-08-05 13:44:17.031 AutoExpire: CalcParams(): Max required Free
Space: 1.0 GB w/freq: 15 min
2011-08-05 13:59:17.490 AutoExpire: CalcParams(): Max required Free
Space: 1.0 GB w/freq: 15 min
2011-08-05 14:14:17.952 AutoExpire: CalcParams(): Max required Free
Space: 1.0 GB w/freq: 15 min
2011-08-05 15:27:40.096 AutoExpire: CalcParams(): Max required Free
Space: 1.0 GB w/freq: 15 min
2011-08-05 15:58:13.429 AutoExpire: CalcParams(): Max required Free
Space: 1.0 GB w/freq: 15 min
2011-08-05 16:00:09.970 AutoExpire: CalcParams(): Max required Free
Space: 3.0 GB w/freq: 14 min
2011-08-05 16:00:10.932 AutoExpire: CalcParams(): Max required Free
Space: 3.0 GB w/freq: 9 min
2011-08-05 16:13:14.288 AutoExpire: CalcParams(): Max required Free
Space: 3.0 GB w/freq: 9 min

Thoughts?

b.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 262 bytes
Desc: OpenPGP digital signature
Url : http://www.mythtv.org/pipermail/mythtv-users/attachments/20110805/ef721ea4/attachment.bin 


More information about the mythtv-users mailing list