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

[Hika van den Hoven]

Hoi Dick,

Tuesday, December 13, 2016, 12:13:40 AM, you wrote:

> On 12/12/2016 03:07 PM, Mike Perkins wrote:
>> 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?
>>

> Good question. I have moved around a couple of times since I ran it, and
> the history in my terminal screen doesn't go back far enough, so I'm not
> sure. Where should I have been? Or how can I show more of the history? I
> still have that terminal open.

Try running it from the home directory and just to make sure create
that mythconverg directory there before you run it. Also check what
temp directory is set in my.conf. It should be set to /tmp or
/var/tmp. The variable is tmpdir so: 
tmpdir = /tmp/

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