MySQL Forums
Forum List  »  InnoDB

What is the best way to get rid of these errors? Please see messages below....
Posted by: Ronald Olavidez
Date: January 11, 2018 10:19PM

What is the best way to get rid of these errors? Please see messages below....

I don't want to rebuild, all i want is to get rid of these error messages from the log file. how can i delete those from data dictionary?

InnoDB: http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html
InnoDB: for how to resolve the issue.
2018-01-12 09:35:24 22047 [ERROR] InnoDB: Table myproddb/#sql-ib58939-1998850655 in the InnoDB data dictionary has tablespace id 58930, but tablespace with that id or name does not exist. Have you deleted or moved .ibd files? This may also be a table created with CREATE TEMPORARY TABLE whose .ibd and .frm files MySQL automatically removed, but the table still exists in the InnoDB internal data dictionary.
InnoDB: Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html
InnoDB: for how to resolve the issue.
2018-01-12 09:35:24 22047 [ERROR] InnoDB: Table myproddb/#sql-ib58945-1810817686 in the InnoDB data dictionary has tablespace id 58936, but tablespace with that id or name does not exist. Have you deleted or moved .ibd files? This may also be a table created with CREATE TEMPORARY TABLE whose .ibd and .frm files MySQL automatically removed, but the table still exists in the InnoDB internal data dictionary.
InnoDB: Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html
InnoDB: for how to resolve the issue.
2018-01-12 09:35:24 22047 [ERROR] InnoDB: Table myproddb/#sql-ib58951-3978515975 in the InnoDB data dictionary has tablespace id 58941, but tablespace with that id or name does not exist. Have you deleted or moved .ibd files? This may also be a table created with CREATE TEMPORARY TABLE whose .ibd and .frm files MySQL automatically removed, but the table still exists in the InnoDB internal data dictionary.
InnoDB: Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html
InnoDB: for how to resolve the issue.
2018-01-12 09:35:24 22047 [ERROR] InnoDB: Table myproddb/#sql-ib58956-593550318 in the InnoDB data dictionary has tablespace id 58947, but tablespace with that id or name does not exist. Have you deleted or moved .ibd files? This may also be a table created with CREATE TEMPORARY TABLE whose .ibd and .frm files MySQL automatically removed, but the table still exists in the InnoDB internal data dictionary.
InnoDB: Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html
InnoDB: for how to resolve the issue.
2018-01-12 09:35:24 22047 [ERROR] InnoDB: Table myproddb/#sql-ib58962-4119598904 in the InnoDB data dictionary has tablespace id 58952, but tablespace with that id or name does not exist. Have you deleted or moved .ibd files? This may also be a table created with CREATE TEMPORARY TABLE whose .ibd and .frm files MySQL automatically removed, but the table still exists in the InnoDB internal data dictionary.
InnoDB: Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html
InnoDB: for how to resolve the issue.
2018-01-12 09:35:24 22047 [ERROR] InnoDB: Table myproddb/#sql-ib58967-3842858371 in the InnoDB data dictionary has tablespace id 58957, but tablespace with that id or name does not exist. Have you deleted or moved .ibd files? This may also be a table created with CREATE TEMPORARY TABLE whose .ibd and .frm files MySQL automatically removed, but the table still exists in the InnoDB internal data dictionary.
InnoDB: Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html
InnoDB: for how to resolve the issue.
2018-01-12 09:35:24 22047 [ERROR] InnoDB: Table myproddb/#sql-ib58977-1098667555 in the InnoDB data dictionary has tablespace id 58967, but tablespace with that id or name does not exist. Have you deleted or moved .ibd files? This may also be a table created with CREATE TEMPORARY TABLE whose .ibd and .frm files MySQL automatically removed, but the table still exists in the InnoDB internal data dictionary.
InnoDB: Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html
InnoDB: for how to resolve the issue.
2018-01-12 09:35:24 22047 [ERROR] InnoDB: Table myproddb/#sql-ib58977-3420892313 in the InnoDB data dictionary has tablespace id 58973, but tablespace with that id or name does not exist. Have you deleted or moved .ibd files? This may also be a table created with CREATE TEMPORARY TABLE whose .ibd and .frm files MySQL automatically removed, but the table still exists in the InnoDB internal data dictionary.

Options: ReplyQuote


Subject
Views
Written By
Posted
What is the best way to get rid of these errors? Please see messages below....
529
January 11, 2018 10:19PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.