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

[Dick Steffens]

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



-- 
Regards,

Dick Steffens