SQL Table not present or corrupted on update 30190605_0

Post Reply
fnx
Posts: 51
Joined: Tue Feb 10, 2015 11:26 pm

SQL Table not present or corrupted on update 30190605_0

Post by fnx » Mon Jul 08, 2019 1:27 pm

Ran into this mess of errors today (08Jul19) for just about every table...

2019-07-08T18:13:03.045950Z 27 [ERROR] InnoDB: Fetch of persistent statistics requested for table `ffxi`.`despoil_effects` 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.

Usually I expect it's something I am overlooking, but if I do a complete rollback of the server and SQL folders it runs fine until I update again.

Any push in the right direction is greatly appreciated...

User avatar
whasf
Site Admin
Posts: 1312
Joined: Thu Jul 19, 2012 9:11 pm

Re: SQL Table not present or corrupted on update 30190605_0

Post by whasf » Mon Jul 08, 2019 6:47 pm

Looks like something is wrong with your MySQL.innodb_table_stats and MySQL.innodb_index_stats tables. That has to do with MySQL itself, not dsp.
-- Whasf

Delaide
Posts: 478
Joined: Sat Jun 14, 2014 8:58 am

Re: SQL Table not present or corrupted on update 30190605_0

Post by Delaide » Tue Nov 05, 2019 10:12 pm

Just a random question. What version of MySQL did you use?

Post Reply