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

[Dick Steffens]

On 12/12/2016 03:06 PM, Hika van den Hoven wrote:
> Hoi Dick,
>
> Monday, December 12, 2016, 11:51:10 PM, you 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
> And df -i
>
>

root at ThinkCentre-M58p:/var/lib/mysql/mythconverg# df -i
Filesystem       Inodes  IUsed    IFree IUse% Mounted on
/dev/sda1      19406848 234862 19171986    2% /
udev             741494    501   740993    1% /dev
tmpfs            743821    429   743392    1% /run
none             743821      4   743817    1% /run/lock
none             743821      1   743820    1% /run/shm

-- 
Regards,

Dick Steffens