Softaculous


Topic : Innodb problem


Posted By: lopinsjk on April 23, 2014, 10:19 am
Hi guys,

you have a problem with innodb tables on win 7. The database files are corrupted in your distribution. To fix the problem I have deleted some table and replace them with others.

This is the mysql log:

2013-12-06 21:08:00 7f87b1d26700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2013-12-06 21:08:00 7f87b1d26700 InnoDB: Recalculation of persistent statistics requested for table "drupal"."sessions" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2013-12-06 21:08:07 7f903c09c700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.

Please fix this.

Posted By: tidus on April 26, 2014, 6:04 am | Post: 1
Hi,

Okay. Thanks for reporting.

We will look into this and fix it if the issue is in Ampps.


-----------------------
Follow AMPPS on,
Twitter : https://twitter.com/AMPPS_Stack
Facebook :  http://www.facebook.com/softaculousampps
Google+ : https://plus.google.com/+AmppsStack

Posted By: sg4dsiao on September 1, 2017, 7:03 am | Post: 2
Have the issue be fixed in Version Ampps 3.7 as I am still receiving alerts on this


2017-08-31 19:52:28 c88 InnoDB: Error: Fetch of persistent statistics requested for table "sglottery"."jos_bfstop_unblock" 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.
2017-08-31 19:52:28 c88 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2017-08-31 19:52:28 c88 InnoDB: Error: Fetch of persistent statistics requested for table "sglottery"."jos_rsmembership_configuration" 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.
2017-08-31 19:52:28 c88 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2017-08-31 19:52:28 c88 InnoDB: Error: Fetch of persistent statistics requested for table "sglottery"."jos_rsticketspro_configuration" 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.
2017-08-31 19:52:28 c88 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2017-08-31 19:52:28 c88 InnoDB: Error: Fetch of persistent statistics requested for table "sglottery"."jos_rsfirewall_snapshots" 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.
2017-08-31 19:52:28 c88 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2017-08-31 19:52:28 c88 InnoDB: Error: Fetch of persistent statistics requested for table "sglottery"."jos_rsfirewall_lists" 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.
2017-08-31 19:52:28 c88 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2017-08-31 19:52:28 c88 InnoDB: Error: Fetch of persistent statistics requested for table "sglottery"."jos_rsmembership_extra_values" 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.
2017-08-31 19:52:28 c88 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2017-08-31 19:52:28 c88 InnoDB: Error: Fetch of persistent statistics requested for table "sglottery"."jos_content" 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.
2017-08-31 19:52:28 c88 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2017-08-31 19:52:28 c88 InnoDB: Error: Fetch of persistent statistics requested for table "sglottery"."jos_content_frontpage" 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.
2017-08-31 19:52:28 c88 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2017-08-31 19:52:28 c88 InnoDB: Error: Fetch of persistent statistics requested for table "sglottery"."jos_content_rating" 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.
2017-08-31 19:52:29 f18 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2017-08-31 19:52:29 f18 InnoDB: Error: Fetch of persistent statistics requested for table "sglottery"."jos_rsmembership_membership_subscribers" 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.
2017-08-31 19:52:31 22b8 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2017-08-31 19:52:31 22b8 InnoDB: Error: Fetch of persistent statistics requested for table "sglottery"."jos_fields" 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.
2017-08-31 19:52:31 22b8 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2017-08-31 19:52:31 22b8 InnoDB: Error: Fetch of persistent statistics requested for table "sglottery"."jos_fields_groups" 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.
2017-08-31 19:52:31 22b8 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2017-08-31 19:52:31 22b8 InnoDB: Error: Fetch of persistent statistics requested for table "sglottery"."jos_messages" 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.
2017-08-31 19:52:31 22b8 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2017-08-31 19:52:31 22b8 InnoDB: Error: Fetch of persistent statistics requested for table "sglottery"."jos_menu_types" 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.
2017-08-31 19:52:32 2320 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2017-08-31 19:52:32 2320 InnoDB: Error: Fetch of persistent statistics requested for table "sglottery"."jos_rsfirewall_exceptions" 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.
2017-08-31 19:52:39 2f8 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2017-08-31 19:52:39 2f8 InnoDB: Recalculation of persistent statistics requested for table "sglottery"."jos_session" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead.
2017-08-31 19:52:54 2318 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2017-08-31 19:52:54 2318 InnoDB: Error: Fetch of persistent statistics requested for table "sglottery"."jos_rsfirewall_ignored" 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.
2017-08-31 19:52:54 2318 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.

Posted By: princeofnaxos on October 18, 2018, 1:00 pm | Post: 3
So this problem already existed back in 2014??????

Now, in 2018, on a clean install, I get:

2018-10-18 14:38:02 76729 [Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2018-10-18 14:38:02 76729 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
2018-10-18 14:38:02 76729 [Warning] InnoDB: Cannot open table mysql/slave_worker_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2018-10-18 14:38:02 76729 [Warning] InnoDB: Cannot open table mysql/slave_relay_log_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2018-10-18 14:38:02 76729 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.

Powered By AEF 1.0.8 © 2007-2008 Electron Inc.