mysql.innodb_index_stats are not present

MarceloKonrath

• November 03, 2017 10:24

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

  • November 03, 2017 16:57

  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.

  0
• 

  MarceloKonrath

  • November 03, 2017 22:07

  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.

  
  

  0
• 

  cPanelMichael

  • November 07, 2017 15:00

  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.

  0

Please sign in to leave a comment.