[mythtv-users] mysql filling up hard drive

[Scott Moncrieff]

I should probably have mentioned from the start -

v0.27.4-53-g7962008

On 9 May 2015 at 00:12, Scott Moncrieff <scottcmoncrieff at gmail.com> wrote:

> This was probably a bit rash but a bottle of wine will do that...before I
> read the 2 previous replies I just went into the  database and deleted
> everything in the 'record' table with the title 'Breakfast'
>
> Not being completely mad, I did switch to my alternate backup system drive
> first. All of the 23486 recording rules for 'Breakfast' were deleted and
> the hard drive has not moved from 11% full for the last 30 minutes.
>
> I just rebooted from the other (bad) drive and ran the curl command which
> produced a seemingly endless output of the description of the offending
> Breakfast show but I could not copy and of the output before the system
> stopped responding. Now back on the other hard drive it all seems stable.
>
> Is there any way I can investigate what actually caused this and how I can
> stop it in the future? Assuming the system is actually stable, probably a
> bit early to be relaxing.
>
> On 8 May 2015 at 23:42, Bill Meek <keemllib at gmail.com> wrote:
>
>> On 05/08/2015 04:45 PM, Scott Moncrieff wrote:
>> ...
>>
>>> I don't think that I have ever added a custom recording rule, other than
>>> changing a couple of old rules to ignore searching previous recordings
>>> and
>>> to record all episodes but only for a couple of shows. ie 'Look for
>>> duplicate in current recordings'
>>>
>>
>> In addition to my last response, I'm still considering that
>> you have a custom rule (I know you said you didn't create
>> one.)
>>
>> Assuming you're running 0.25 or later, this will print all
>> descriptions (which is where custom queries will be stored.)
>>
>>     curl --silent localhost:6544/Dvr/GetRecordScheduleList | sed
>> "s/></>\n</g" | /bin/grep "<Description>" | grep Breakfast
>>
>> The above is also on one line. And run from your backend.
>>
>> If you don't have curl in your host, replace: curl --silent
>> with: wget -O- --quiet
>>
>> You could pastebin the output if you have questions.
>>
>>
>> --
>> Bill
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://lists.mythtv.org/mailman/listinfo/mythtv-users
>> http://wiki.mythtv.org/Mailing_List_etiquette
>> MythTV Forums: https://forum.mythtv.org
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20150509/383e0524/attachment.html>