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

Dick Steffens dick at dicksteffens.com
Mon Dec 12 23:13:40 UTC 2016


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.

-- 
Regards,

Dick Steffens



More information about the mythtv-users mailing list