[mythtv-users] !!NoTrans: SQL Error: Table
Romain Kang
romain at kzsu.stanford.edu
Mon Dec 12 21:41:38 UTC 2016
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
More information about the mythtv-users
mailing list