[mythtv-users] Same 18GB reported used by LiveTV shown on backend for months

[Jim Stichnoth]

On Thu, Aug 26, 2010 at 6:30 PM, Dave Richardson <mythtv at derdev.com> wrote:
> On Thu, 26 Aug 2010 12:10:34 -0400, "Michael T. Dean"
> <mtdean at thirdcontact.com> wrote:
>> On 08/26/2010 07:52 AM, Dave Richardson wrote:
>>> With nothing recording or being watched for whole chunks of days, my
> myth
>>> BE continues to report 18GB being used by LiveTV storage - and has
>>> reported
>>> the same 18GB for months...
>>>
>>> Total Disk Space:
>>>
>>>      * Total Space: 2,861,217 MB
>>>      * Space Used: 494,349 MB
>>>      * Space Free: 2,366,868 MB
>>>      * Space Available After Auto-expire: 2,603,505 MB
>>>            o Space Used by LiveTV: 18,740 MB
>>>            o Space Used by Deleted Recordings: 0 MB
>>>            o Space Used by Auto-expirable Recordings: 217,897 MB
>>>
>>>
>>> I've had a few power outages and at least one hairy upgrade - all which
>>> could have contributed to some unclean shutdowns of LiveTV.
>>>
>>> How do I track this down to clean this up?
>>
>> I would bet that you have one or more log messages in your backend
>> log(s) saying that a file for <whatever> was not found, so the metadata
>> is being left/the show isn't being autoexpired.  Something like:
>>
>> 2010-08-25 18:12:31.418 AutoExpire: CalcParams(): Max required Free
>> Space: 1.0 GB w/freq: 8 min
>> 2010-08-25 18:12:31.426 ProgramInfo, Error: GetPlaybackURL:
>> '1061_20090320200000.mpg' should be local, but it can not be found.
>>
>> Mike
>
> grepping for "should be local, but it can not be found" in BE log yields
> this
>
> <snip>
> 2010-08-11 18:41:39.933 ProgramInfo(109001_20100404183111.mpg), Error:
> GetPlaybackURL: '109001_20100404183111.mpg' should be local, but it can not
> be found.
> 2010-08-11 18:41:39.958 ProgramInfo(109001_20100404183407.mpg), Error:
> GetPlaybackURL: '109001_20100404183407.mpg' should be local, but it can not
> be found.
> 2010-08-11 18:41:39.983 ProgramInfo(109001_20100404185213.mpg), Error:
> GetPlaybackURL: '109001_20100404185213.mpg' should be local, but it can not
> be found.
> 2010-08-11 18:41:40.033 ProgramInfo(107001_20100404185702.mpg), Error:
> GetPlaybackURL: '107001_20100404185702.mpg' should be local, but it can not
> be found.
> 2010-08-11 18:41:40.058 ProgramInfo(109001_20100404200007.mpg), Error:
> GetPlaybackURL: '109001_20100404200007.mpg' should be local, but it can not
> be found.
> 2010-08-11 18:41:40.083 ProgramInfo(102001_20100501080825.mpg), Error:
> GetPlaybackURL: '102001_20100501080825.mpg' should be local, but it can not
> be found.
>
>
> <spotlight on my ignorance> What can I do with this info?  I'm comfortable
> in mysql to prune something out, but I'm clueless on the schema and how to
> go prune this from the metadata.  TIA!!!

Execute this:
  touch /PATH/TO/SOME/STORAGE/GROUP/109001_20100404183111.mpg
Repeat for the other files referenced.  That ought to fix it.

Jim