My Oracle Support Banner

MySQL Server 5.6: "InnoDB: Cannot Open Table mysql/slave_master_info From the Internal Data Dictionary of InnoDB Though the .frm File For the Table Exists"; slave_master_info; slave_worker_info; slave_relay_log_info (Doc ID 1534359.1)

Last updated on AUGUST 09, 2018

Applies to:

MySQL Server - Version 5.6 and later
Information in this document applies to any platform.

Symptoms

When installing MySQL 5.6, the following errors occur in the error log when MySQL is started:

2013-03-05 16:24:30 22284 [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.
2013-03-05 16:24:30 22284 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
2013-03-05 16:24:30 22284 [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.
2013-03-05 16:24:30 22284 [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.
2013-03-05 16:24:30 22284 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.

Additionally if it is attempted to run the mysql_upgrade script, the script fails with the errors:

shell$ ./mysql/bin/mysql_upgrade --defaults-file=etc/my.cnf -p
Enter password:                                                         
Looking for 'mysql' as: ./mysql/bin/mysql                               
Looking for 'mysqlcheck' as: ./mysql/bin/mysqlcheck                     
...
mysql.innodb_index_stats                                                                                         
Error    : Table 'mysql.innodb_index_stats' doesn't exist                                                        
status   : Operation failed                                                                                      
mysql.innodb_table_stats                                                                                         
Error    : Table 'mysql.innodb_table_stats' doesn't exist                                                        
status   : Operation failed                                                                                      
mysql.ndb_binlog_index                             OK                                                            
...
mysql.slave_master_info                                                                                          
Error    : Table 'mysql.slave_master_info' doesn't exist                                                         
status   : Operation failed                                                                                      
mysql.slave_relay_log_info                                                                                       
Error    : Table 'mysql.slave_relay_log_info' doesn't exist                                                      
status   : Operation failed                                                                                      
mysql.slave_worker_info                                                                                          
Error    : Table 'mysql.slave_worker_info' doesn't exist                                                         
status   : Operation failed                                                                                      
...

Repairing tables
mysql.innodb_index_stats
Error    : Table 'mysql.innodb_index_stats' doesn't exist
status   : Operation failed
mysql.innodb_table_stats
Error    : Table 'mysql.innodb_table_stats' doesn't exist
status   : Operation failed
mysql.slave_master_info
Error    : Table 'mysql.slave_master_info' doesn't exist
status   : Operation failed
mysql.slave_relay_log_info
Error    : Table 'mysql.slave_relay_log_info' doesn't exist
status   : Operation failed
mysql.slave_worker_info
Error    : Table 'mysql.slave_worker_info' doesn't exist
status   : Operation failed
Running 'mysql_fix_privilege_tables'...
Warning: Using a password on the command line interface can be insecure.
ERROR 1146 (42S02) at line 36: Table 'mysql.innodb_table_stats' doesn't exist
ERROR 1146 (42S02) at line 45: Table 'mysql.innodb_index_stats' doesn't exist
ERROR 1146 (42S02) at line 73: Table 'mysql.slave_relay_log_info' doesn't exist
ERROR 1243 (HY000) at line 74: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 (HY000) at line 75: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
ERROR 1146 (42S02) at line 102: Table 'mysql.slave_master_info' doesn't exist
ERROR 1243 (HY000) at line 103: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 (HY000) at line 104: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
ERROR 1146 (42S02) at line 120: Table 'mysql.slave_worker_info' doesn't exist
ERROR 1243 (HY000) at line 121: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 (HY000) at line 122: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
ERROR 1146 (42S02) at line 1872: Table 'mysql.slave_master_info' doesn't exist
ERROR 1146 (42S02) at line 1873: Table 'mysql.slave_master_info' doesn't exist
ERROR 1146 (42S02) at line 1874: Table 'mysql.slave_master_info' doesn't exist
ERROR 1146 (42S02) at line 1875: Table 'mysql.slave_worker_info' doesn't exist
ERROR 1146 (42S02) at line 1876: Table 'mysql.slave_relay_log_info' doesn't exist
ERROR 1146 (42S02) at line 1877: Table 'mysql.innodb_table_stats' doesn't exist
ERROR 1146 (42S02) at line 1878: Table 'mysql.innodb_index_stats' doesn't exist
FATAL ERROR: Upgrade failed

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.