WARNING: mysqlcheck has found corrupt tables

1

Hi. Debian 10.8, Hestia - last… letters come to the post office -

ERROR 130 (HY000) at line 1: Incorrect file format ‘table_stats’
ERROR 130 (HY000) at line 1: Incorrect file format ‘index_stats’
ERROR 130 (HY000) at line 1: Incorrect file format ‘column_stats’
ERROR 130 (HY000) at line 1: Incorrect file format ‘help_topic’

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 |
±—±-----±----------±—±--------±-----±---------±-----------------±---------+
| 38 | root | localhost | | Query | 0 | starting | show processlist | 0.000 |
±—±-----±----------±—±--------±-----±---------±-----------------±---------+
Uptime: 2 Threads: 1 Questions: 452 Slow queries: 0 Opens: 142 Open tables: 25 Queries per second avg: 226.000

bash hst-install.sh --force --nginx yes --phpfpm no --apache yes --multiphp yes --named yes --vsftpd yes --proftpd no --iptables yes --fail2ban yes --quota no --api yes --exim yes --dovecot yes --spamassassin no --clamav no --mysql yes --postgresql no --interactive no --lang en

How to fix?

2

Hard to say without more informations…

From where exactly have you got this? What have you done?

3

Install hestia =) nothing else, clean install. Everything works, this is the only error.

4

Did you have a existing mysql installation on it?

5

Yes, when installing hestia.
There is a suspicion that this happens when installing multiphp and when disabling unnecessary php versions. When reinstalling is the same. I’ll try to reinstall it in the evening again.

6

It just looks like you’ve got an existing mysql server preinstalled on that server. Please reinstall the whole box and try it again :).

7

reinstalled two times from 0. first, debian clean, only ssh. then hestia according to the scenario described above. the same error, table breakage. :thinking:

8
9

I saw these solutions, they do not work … we will leave the old versions, we will not update.