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

[Romain Kang]

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 or permissions.
Assuming your MySQL is configured to use /var/lib/mysql/mythconverg,
check there.

Romain