SQL Table not present or corrupted on update 30190605_0
Posted: 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...
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...