Welcome Guest. Please Login or Register  


You are here: Index > AMPPS > Bugs > Topic : Innodb problem



Threaded Mode | Print  

 Innodb problem (3 Replies, Read 31551 times)
lopinsjk
Group: Member
Post Group: Newbie
Posts: 1
Status:
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.
IP: --   

Innodb problem
tidus
Group: Member
Post Group: Super Member
Posts: 1121
Status:
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
IP: --   

Innodb problem
sg4dsiao
Group: Member
Post Group: Newbie
Posts: 7
Status:
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.
IP: --   

Innodb problem
princeofnaxos
Group: Member
Post Group: Newbie
Posts: 8
Status:
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.
IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is March 19, 2024, 6:09 am.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.024