[mythtv-users] mysqlcheck has recently found corrupt database tables

Peter Carlsson peter.jm.carlsson at gmail.com
Mon May 1 20:20:29 UTC 2023


Hello,

I have recently starting to get the following from mysqlcheck.

WARNING: mysqlcheck has found corrupt tables

ERROR 130 (HY000) at line 1: Incorrect file format 'filemarkup'

 Improperly closed tables are also reported if clients are accessing
 the tables *now*. A list of current connections is below.

+-----+------------------+-----------+-------------+---------+------+----------+------------------+----------+
| Id  | User             | Host      | db          | Command | Time | State    | Info             | Progress |
+-----+------------------+-----------+-------------+---------+------+----------+------------------+----------+
| 86  | mythtv           | localhost | mythconverg | Sleep   | 0    |          |                  | 0.000    |
| 165 | debian-sys-maint | localhost |             | Query   | 0    | starting | show processlist | 0.000    |
+-----+------------------+-----------+-------------+---------+------+----------+------------------+----------+
Uptime: 2  Threads: 3  Questions: 339  Slow queries: 0  Opens: 163  Open tables: 156  Queries per second avg: 169.500

It still seems to work without any noticable problems but could anyone
tell me how to fix this problem?

Best regards,
Peter Carlsson


More information about the mythtv-users mailing list