Fetch of persistent statistics

Discussion in 'Installation/Configuration' started by pecka33, Apr 5, 2020.

  1. pecka33

    pecka33 Member

    Hello,

    I am using Debian 9 with 10.1.44-MariaDB, and latest version of ISP config. When i check my error log for mysql, i can see there errors like

    InnoDB: Error: Fetch of persistent statistics requested for table "dbispconfig"."client_template" 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.
    Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).

    I tried to looking for solution here, but I didnt found similar error. Not sure, but i hope that this is just warning about my problem with database/table coding and not fatal security problem. Maybe i should change something for tables, but everything working fine and not sure if thats good idea.
     
  2. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Have you tried repair tables? With PHPMyadmin that is reletive easy to do.
     
  3. pecka33

    pecka33 Member

    Hello, yes, i tried. Does not help, but yesterday I did upgrade my Debian from 9 and 10, now looks fine and mysql log is clear until now.
     

Share This Page