Mailing List Archive

mysqlcheck has recently found corrupt database tables
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
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: mysqlcheck has recently found corrupt database tables [ In reply to ]
On Mon, May 01 2023, Peter Carlsson <peter.jm.carlsson@gmail.com> wrote:

> 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?

You are looking for mysql{check,optimize}

https://dev.mysql.com/doc/refman/8.0/en/mysqlcheck.html

Alternatively, there is a perl wrapper in the myth package:

https://www.mythtv.org/wiki/User_Manual:Periodic_Maintenance

(skip to "Optimize the Database").

Leo

>
> Best regards,
> Peter Carlsson
> _______________________________________________
> mythtv-users mailing list
> mythtv-users@mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org