[mythtv-users] mythconverg/program is marked as crashed

[Mike Perkins]

On 25/01/16 19:07, Michael T. Dean wrote:
> On 01/25/2016 01:07 PM, David L wrote:
>>
>> I have had mythtv installed on that backend for ~6 years and don't recall ever specifying a temp
>> directory for MySQL.  I assume it's using whatever the default directory was configured when I
>> originally installed it.  In any case, it doesn't look like any of my partitions are full.
>>
>> udev            2.0G  4.0K  2.0G   1% /dev
>> tmpfs           404M  1.3M  402M   1% /run
>> /dev/sda1        92G   80G  7.7G  92% /
>> none            4.0K     0  4.0K   0% /sys/fs/cgroup
>> none            5.0M     0  5.0M   0% /run/lock
>> none            2.0G  246M  1.8G  13% /run/shm
>> none            100M   24K  100M   1% /run/user
>> /dev/sdb1       459G  413G   23G  95% /var/lib/mythtv
>> /dev/sdc1       1.8T  1.6T  163G  91% /sdc1
>> /dev/sda6       265G  229G   23G  91% /sda6
>> /dev/sda5       1.9G  518M  1.2G  30% /var/log
>
Since you haven't specified /tmp as being on a separate partition, it would be on /dev/sda1. 
Although that has 7.7G free when you checked, it is possible that temp files could use all that up 
during a run.
>
(deletia)
>> The repair program runs without any obvious errors:
>>
>> Repaired/Optimized: `mythconverg`.`archiveitems`
>> Analyzed: `mythconverg`.`archiveitems`
>> <snip>
>> Repaired/Optimized: `mythconverg`.`program`
>> Analyzed: `mythconverg`.`program`
>> <snip>
>> Repaired/Optimized: `mythconverg`.`websites`
>> Analyzed: `mythconverg`.`websites`
>>
>> But it doesn't seem to fix anything.  Per your link to the temp dir configuration, I tried setting
>> the TMPDIR environment variable to a partition with lots of free space:
>> sudo mkdir /sdc1/tmp
>> sudo chmod a+rwX /sdc1/tmp/
>> export TMPDIR=/sdc1/tmp/
>> df -h $TMPDIR
>> Filesystem      Size  Used Avail Use% Mounted on
>> /dev/sdc1       1.8T  1.6T  163G  91% /sdc1
>
> and you restarted mysqld from an environment that contained said TMPDIR?  Otherwise, it wouldn't
> affect anything (it's the MySQL server's temp, not the mysqlcheck script's temp that's the problem).
>
You specify the directory for mysql to use as temp space in the /etc/mysql/my.cnf file, in the 
[mysqld] section:

[mysqld]
#
# * Basic Settings
#
user		= mysql
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
port		= 3306
basedir		= /usr
datadir		= /var/lib/mysql
tmpdir		= /tmp
lc-messages-dir	= /usr/share/mysql
skip-external-locking

or, in your case, tmp = /sdc1/tmp

-- 

Mike Perkins