mysql.innodb_index_stats are not present

[MarceloKonrath]

Hello

The sites are working and the databases are ok.

Does anyone have a suggestion of how to fix this problem?


I.E.

2017-11-03 13:19:33 7fb4f114c700 InnoDB: Error: Fetch of persistent statistics requested for table "user_25projetos2"."u5xlr_xmap_sitemap" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.

I have found this solution but I do not know if it is applicable to a server with cPanel.


mysql_upgrade failed - innodb tables doesn't exist?

Thank you
Marcelo




Thank you

 

[cPanelMichael]

Hello,

The following thread offers some guidelines if you need to re-create ibdata/ib_log files, as suggested in the external URL you linked:

InnoDB Corruption Repair Guide

Thank you.

 

[MarceloKonrath]

Hello cPanelMichael

I do not see any reason to rebuild idbdata

The problem is apparently only with the tables I indicated.

My question is: is the solution presented applicable to a cPanel server?

Thank you
Marcelo

Hello,

The following thread offers some guidelines if you need to re-create ibdata/ib_log files, as suggested in the external URL you linked:

InnoDB Corruption Repair Guide

Thank you.

 

[cPanelMichael]

Hello,

It's difficult to know for sure if that solution will work. Did this happen after an upgrade to MariaDB? Are you using a custom directory path to the MySQL data directory? The referenced thread is still useful, as it provides instructions on how to backup your data before performing any actions. Feel free to open a support ticket if you'd like us to take a closer look at the error message.

Thank you.