[mythtv-users] mysql filling up hard drive

[Scott Moncrieff]

I am not sure that lack of space available to mysql is the problem, the
drive has nearly 100gb free on it.


Regarding the ssh port, is it closed by default? I will check later
tonight, and also my router logs but I am fairly sure outside access is
tightly locked down! The reasons that I think it must be related to the
mythtv database are, I restored a 6 month old system backup and it was fine
until I imported the current database and iotop shows mysqld is continually
writing large amounts of data to the drive.


On 8 May 2015 at 09:04, Stephen Worthington <stephen_agent at jsw.gen.nz>
wrote:

> On Fri, 8 May 2015 08:16:16 +0100, you wrote:
>
> >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
>
> >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.
>
> That temp file seems to belong to a process called ssh-agent.  This
> command should show it:
>
>   ps -ef | grep ssh-agent
>
> which gives me this result on Mythbuntu 14.04:
>
> stephen   2688  2644  0 00:17 ?        00:00:00 /usr/bin/ssh-agent
> /usr/bin/dbus-launch --exit-with-session
> /usr/share/mythbuntu/session.sh
> root     31900  5318  0 19:54 pts/9    00:00:00 grep --color=auto
> ssh-agent
>
> (that may wrap on many email clients - it is just two lines starting
> with "stephen" and "root").
>
> My understanding is that ssh-agent is supposed to store private ssh
> keys so they can be re-used without having to log in again for
> anything that needs to use them, such as tasks run from X.  So you
> only have to login once while starting the X session, and then
> anything that is run from the same session (eg a program you start)
> can use the same keys without having to ask for a login again.
>
> Just why it is going rogue, I have no idea.  Do you have the ssh port
> open to the Internet and is it being attacked???
> _______________________________________________
> 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/6c50e868/attachment-0001.html>