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

Tue Jan 26 03:36:01 UTC 2016

On Mon, Jan 25, 2016 at 11:07 AM, Michael T. Dean <mtdean at thirdcontact.com>
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
>>
>
> It's also possible your file system is out of inodes.  You can check with
> df -i .
>

That is not the problem:

df -i
Filesystem        Inodes  IUsed     IFree IUse% Mounted on
udev              205701    648    205053    1% /dev
tmpfs             211853    733    211120    1% /run
/dev/sda1        6111232 709377   5401855   12% /
none              211853      2    211851    1% /sys/fs/cgroup
none              211853      5    211848    1% /run/lock
none              211853      5    211848    1% /run/shm
none              211853     19    211834    1% /run/user
/dev/sda6       17645568 495118  17150450    3% /sda6
/dev/sdb1       30531584   8626  30522958    1% /var/lib/mythtv
/dev/sdc1      122101760   9882 122091878    1% /sdc1
/dev/sda5         122160    896    121264    1% /var/log

>
> That said, it looks like your temp file is being stored in the same
> directory as your mythconverg database files.  The specific error:
>
> error    : Can't create new tempfile: './mythconverg/program.TMD'
>>
>
> could also indicate that there's already a program.TMD file in the
> directory owned by someone else (or even that the user running mysqld
> doesn't have permission to create new files in the mythconverg directory).
> If that's there, delete it, then re-run mysqlcheck.

I haven't found any directory named mythconverg in /tmp or elsewhere, so I
don't know where to look for a permission problem.

>
>
> 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).
>
> Oops... my bad.

So now I have changed my.cnf to point to /sdc1/tmp for tmpdir and
rebooted.  But mysqld won't even run:

sudo /usr/sbin/mysqld
160125 19:28:14 [Warning] Using unique option prefix key_buffer instead of
key_buffer_size is deprecated and will be removed in a future release.
Please use the full name instead.
160125 19:28:14 [Note] /usr/sbin/mysqld (mysqld 5.5.46-0ubuntu0.14.04.2)
starting as process 6699 ...
160125 19:28:14 [Warning] Using unique option prefix myisam-recover instead
of myisam-recover-options is deprecated and will be removed in a future
release. Please use the full name instead.
160125 19:28:14 [Note] Plugin 'FEDERATED' is disabled.
160125 19:28:14 InnoDB: The InnoDB memory heap is disabled
160125 19:28:14 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160125 19:28:14 InnoDB: Compressed tables use zlib 1.2.8
160125 19:28:14 InnoDB: Using Linux native AIO
/usr/sbin/mysqld: Can't create/write to file '/sdc1/tmp/ibDadC00' (Errcode:
13)
160125 19:28:14  InnoDB: Error: unable to create temporary file; errno: 13
160125 19:28:14 [ERROR] Plugin 'InnoDB' init function returned error.
160125 19:28:14 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE
failed.
160125 19:28:14 [ERROR] Unknown/unsupported storage engine: InnoDB
160125 19:28:14 [ERROR] Aborting

160125 19:28:14 [Note] /usr/sbin/mysqld: Shutdown complete

I have verified that /sdc1/tmp/ibDadC00 can be written to:
dd if=/dev/zero of=/sdc1/tmp/ibDadC00 bs=8192 count=8192
8192+0 records in
8192+0 records out
67108864 bytes (67 MB) copied, 0.3417 s, 196 MB/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20160125/aa5d7719/attachment.html>