View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 8 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Tue Oct 25, 2016 4:47 pm 
Offline
Joined: Tue Mar 22, 2005 9:18 pm
Posts: 1371
Location: Brisbane, Queensland, Australia
I was having some trouble with my frontends not loading and found that my backend had run out of space. Two of my mounted directories were full including my mysql partition.

My .err file was huge so I cleaned that out and then run optimize_mythtvdb.py to ensure my DB was all good. This has then generated more errors in the file, here is an extract:

Code:
2016-10-26 08:32:48 2070 [Note] Found 10299360 of 0 rows when repairing './mythconverg/recordedseek'
2016-10-26 08:33:11 7f9d1222e700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2016-10-26 08:33:11 7f9d1222e700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."gallerymetadata" but the required system tables mysql.innodb_table_stats and mysql.innodb_in$
2016-10-26 08:33:11 7f9d1222e700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2016-10-26 08:33:11 7f9d1222e700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."gallerymetadata" but the required system tables mysql.innodb_table_stats and mysql.innodb_in$
2016-10-26 08:33:11 7f9d1222e700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2016-10-26 08:33:11 7f9d1222e700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."gallerymetadata" but the required system tables mysql.innodb_table_stats and mysql.innodb_in$
2016-10-26 08:33:12 7f9d1222e700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2016-10-26 08:33:12 7f9d1222e700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2016-10-26 08:33:12 7f9d1222e700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.


I did a search on the general error and found this article that apparently fixes it, but it is beyond my skill level:
http://stackoverflow.com/questions/15767652/mysql-error-table-mysql-innodb-table-stats-not-found

Like most people I would like to remove as many errors as possible thus the reason for my post. I would have created a bug but can't seem to find the right place to do this anymore.

Cheers

_________________
Girkers


Top
 Profile  
 
PostPosted: Fri Oct 28, 2016 8:18 am 
Offline
Joined: Fri Jul 21, 2006 11:12 pm
Posts: 1017
Location: SC
I would not run that file link on Stack Overflow. It appears to create many tables that are not on my machines.

Have you checked the backups to see if maybe you have innodb_table_stats.frm & innodb_table_stats.ibd that you could just restore? Those should be at /data/srv/mysql/mysql/


Top
 Profile  
 
PostPosted: Sun Oct 30, 2016 3:04 pm 
Offline
Joined: Tue Mar 22, 2005 9:18 pm
Posts: 1371
Location: Brisbane, Queensland, Australia
Thanks brfransen,

There is no fear of me running that script, that is the reason I am here, to get the good oil.

I have checked the directory that you listed and the innodb files do not exist.I only have two files that have innodb in their name:
Code:
[root@vmmythtv mysql]# locate innodb
/usr/include/mysql/mysql/innodb_priv.h
/usr/share/mysql/innodb_memcached_config.sql


Checking my error file, the errors continue, the full error is:
Code:
2016-10-31 00:11:16 7fa6865f2700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2016-10-31 00:11:16 7fa6865f2700 InnoDB: Error: Fetch of persistent statistics requested for table "mythconverg"."websites" 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.


I am noticing that in the same directory as my err file, there are three ib files, ibdata1, ib_logfile0 and ib_logfile1, these are 60mb, 50mb and 50mb respectively in size. I appreciate that databases use log files, but they seem a little big, is this related?

_________________
Girkers


Top
 Profile  
 
PostPosted: Sun Oct 30, 2016 4:59 pm 
Offline
Joined: Fri Jul 21, 2006 11:12 pm
Posts: 1017
Location: SC
The error log sizes seem normal to me.

Do you not have a backup that have innodb_table_stats and innodb_index_stats? If not they I am thinking they are going to have to be recreated but I am not sure where they got created in the first place to verify the schema.


Top
 Profile  
 
PostPosted: Sun Oct 30, 2016 5:08 pm 
Offline
Joined: Tue Mar 22, 2005 9:18 pm
Posts: 1371
Location: Brisbane, Queensland, Australia
To give you a bit of history this is a clean 8.4 build on ESXi so I don't know .

I have checked one of my frontends and the two innodb tables are listed in the directly you have listed.

Is is possible to copy them from there?

Cheers

_________________
Girkers


Top
 Profile  
 
PostPosted: Mon Oct 31, 2016 6:59 am 
Offline
Joined: Fri Jul 21, 2006 11:12 pm
Posts: 1017
Location: SC
Very odd. I just did a clean install in a VM and innodb_table_stats.frm, innodb_table_stats.ibd and innodb_index_stats.frm, innodb_index_stats.ibd exist.

I guess you could try copying them but I don't know what data would be in them from the other machine.


Top
 Profile  
 
PostPosted: Thu Nov 03, 2016 4:31 pm 
Offline
Joined: Tue Mar 22, 2005 9:18 pm
Posts: 1371
Location: Brisbane, Queensland, Australia
I just had another look around and found this article:

http://dba.stackexchange.com/questions/54608/innodb-error-table-mysql-innodb-table-stats-not-found-after-upgrade-to-mys

This article shows how to create the tables from scratch and suggests that it was a bug in MySQL 5.5 that is upgraded to 5.6.

The question is, can I safely ran the code in the URL to create the tables?

Cheers

_________________
Girkers


Top
 Profile  
 
PostPosted: Thu Nov 03, 2016 5:41 pm 
Offline
Joined: Fri Jul 21, 2006 11:12 pm
Posts: 1017
Location: SC
Should be able to from mysql. Make a backup first. I would just do the innodb_table_stats and innodb_index_stats.


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 8 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 8 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu