[mythtv-users] !!NoTrans: SQL Error: Table
Dick Steffens
dick at dicksteffens.com
Mon Dec 12 22:51:10 UTC 2016
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
More information about the mythtv-users
mailing list