SQL Table not present or corrupted on update 30190605_0

Can't get the client or server set up? Ask here!
We're on Discord! https://discord.gg/4dgAzfC
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: 1287
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

Post Reply