mysql.innodb_index_stats are not present

MarceloKonrath

Active Member
Jun 8, 2013
44
9
8
cPanel Access Level
Root Administrator
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

Administrator
Staff member
Apr 11, 2011
47,911
2,234
363
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

Active Member
Jun 8, 2013
44
9
8
cPanel Access Level
Root Administrator
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

Administrator
Staff member
Apr 11, 2011
47,911
2,234
363
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.