[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