[mythtv-users] !!NoTrans: SQL Error: Table

[Mike Perkins]

On 12/12/16 22:51, Dick Steffens wrote:
> On 12/12/2016 01:41 PM, Romain Kang wrote:
>> On Mon, Dec 12, 2016 at 11:27:42AM -0800, Dick Steffens wrote:
>>
>>> mysql> repair table program;
>>> +---------------------+--------+----------+--------------------------------------------------------+
>>> | Table               | Op     | Msg_type | Msg_text                                               |
>>> +---------------------+--------+----------+--------------------------------------------------------+
>>> | mythconverg.program | repair | error    | Can't create new tempfile: './mythconverg/program.TMD' |
>>> | mythconverg.program | repair | status   | Operation failed                                       |
>>> +---------------------+--------+----------+--------------------------------------------------------+
>>> 2 rows in set (0.00 sec)
>> The two most likely issues are filesystem space
>
> rsteff at ThinkCentre-M58p:/etc/mythtv$ df -h
> Filesystem      Size  Used Avail Use% Mounted on
> /dev/sda1       292G  140G  138G  51% /
> udev            2.9G  4.0K  2.9G   1% /dev
> tmpfs           582M  1.1M  581M   1% /run
> none            5.0M     0  5.0M   0% /run/lock
> none            2.9G     0  2.9G   0% /run/shm
>
>
>> or permissions.
>> Assuming your MySQL is configured to use /var/lib/mysql/mythconverg,
>> check there.
>
> All the file permissions in /var/lib/mysql/mythconverg are the same as the following:
>
> -rw-rw---- 1 mysql mysql     9255 Dec  8 07:41 archiveitems.frm
>
>
>
Looking at that error message, it is trying to create the temp file relative to the /current/ 
directory, that is, relative to the place you ran it from.

That is not necessarily the same as /var/lib/mysql/mythconverg.

What directory were you in when you ran the repair table command?

-- 

Mike Perkins