[mythtv-users] mysql filling up hard drive

[Scott Moncrieff]

I managed to get some of the log files off but I am not sure where to
start. The backend is just showing a large number of autoexipre messages
followed by file missing errors.

mysql error log
http://pastebin.com/QYBVSQgS

backend
http://pastebin.com/9ncw4MHL


On 7 May 2015 at 23:47, Bill Meek <keemllib at gmail.com> wrote:

> On 05/07/2015 05:14 PM, Scott Moncrieff wrote:
>
>> Something disastrous seems to have happened to my Mythtv backend.
>>
>> I got a low disk space warning pop up and the computer became
>> unresponsive.
>> I powered off and rebooted and it happened again so next time I opened the
>> system monitor and watched the hard drive fill up from 23% full up to 99%
>> in the space of 5 minutes then jump back down to 23% and start again and
>> it
>> keeps cycling round like this.
>>
>> The process writing to the disk is mysqld - usr/sbin/mysqld
>>
>> I managed to use backup and restore in the Mythbuntu Control centre to
>> backup to a flash drive. I then restored a clonzilla backup of the system
>> from 6 months ago and it runs ok until I restore the database backup and
>> then the hard drive starts filling up again.
>>
>> Any idea what may be happening or how to trouble shoot it? The drive is
>> filling up very quickly (128gb SSD) and the system becomes unresponsive so
>> it I only have a minute or so to do anything after re booting.
>>
>>
> Hi,
>
> After rebooting, stop the backend and then stop mysql. If mysql is the
> culprit, that will give you time to investigate.
>
> Maybe just stopping the BE would be enough. You get to try that.
>
> I'd start in /var/log/mysql/error.log. You could also look in
> /var/lib/mysql/mythconverg. The biggest file in mine is:
>
>     recordedseek.MYI @ 100M
>
> Your DB could be stored elsewhere, and the problem could be in non-
> mythconverg files under .../mysql too, but that's a start.
>
> You could restart mysql and the BE and tail mythbackend.log. Then,
> in another window type: mythbackend --setverbose database and watch
> the fun in the 1st window for a possible reason to what is being
> written to the DB. I'd do this as a last resort.
>
> --
> 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/20150508/7696aa16/attachment.html>