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

[Hika van den Hoven]

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

Tot mails,
  Hika                            mailto:hikavdh at gmail.com

"Zonder hoop kun je niet leven
Zonder leven is er geen hoop
Het eeuwige dilemma
Zeker als je hoop moet vernietigen om te kunnen overleven!"

De lerende Mens