Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

mysql.innodb_index_stats are not present

Discussion in 'Database Discussion' started by MarceloKonrath, Nov 3, 2017.

Tags:
  1. MarceloKonrath

    MarceloKonrath Active Member

    Joined:
    Jun 8, 2013
    Messages:
    31
    Likes Received:
    2
    Trophy Points:
    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
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,672
    Likes Received:
    1,788
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. MarceloKonrath

    MarceloKonrath Active Member

    Joined:
    Jun 8, 2013
    Messages:
    31
    Likes Received:
    2
    Trophy Points:
    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



     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,672
    Likes Received:
    1,788
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice