[mythtv-users] mysql filling up hard drive

[Scott Moncrieff]

Whilst the drive is filling up, /tmp has a folder ssh-P5Nw6CXpmdb which
contains a single file - agent.1506

It is this file which has zero bytes and then grows to fill the drive.

On 8 May 2015 at 07:55, Scott Moncrieff <scottcmoncrieff at gmail.com> wrote:

> Thank you, I will explore all of this but unfortunately not until after
> work tonight!
>
> The drive is not partitioned, the system runs on a 128gb SSD,10.2 gb used
> now I have restored an older system backup and I have 4 x 3TB drives, 1 for
> recordings and 1 for Video library and the other 2 are backups updated
> using rsync.
>
> I have optimised the database tables again (did it last night as well)
>
> From the log it looks like it has been doing this for most of the night
> but has been stable for the last 20 minutes at least, drive just starting
> to fill up now. du shows that it is /tmp/ that is filling up but will
> investigate more tonight.
>
> Scott
>
>
> On 8 May 2015 at 00:36, Nick Morrott <knowledgejunkie at gmail.com> wrote:
>
>> On 8 May 2015 at 00:08, Scott Moncrieff <scottcmoncrieff at gmail.com>
>> wrote:
>> > 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
>>
>> Couple of ideas:
>>
>> i) See https://www.mythtv.org/wiki/Mysql for details on fixing crashed
>> tables in the database (once MBE is disabled). You want to start with
>> a healthy database.
>>
>> ii) Check your filesystems to see if any are actually full (esp /var
>> and /tmp). You don't say how your SSD is partitioned, so it's not
>> clear which partition is getting 99% full. It could be that /tmp is
>> filling with temporary tables whilst the scheduler is running and then
>> cleaning up again.
>>
>> You can monitor realtime usage of /tmp (or any other dir) using
>> $ du -hs /tmp/
>>
>> If you run this command in another terminal (alongside Bill's logfile
>> suggestion) whilst mythbackend restarts, you might get to see where
>> the free space is being used.
>>
>> Cheers,
>> Nick
>> _______________________________________________
>> 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/6779017e/attachment.html>