Description:
Multiple tables are missing on a fresh install of mysql in regards to replication
How to repeat:
Fresh install of mysql 5.6.6-m9
Set permissions properly and run
scripts/mysql_install_db --user=myuserid --datadir=/data/nms_db/mysql/
Set permissions properly
startup mysql
Log file shows the following
"[ERROR] Error creating master info: Error while checking replication metadata. This might also happen when doing a live upgrade from a version that did not make use of the replication metadata tables. If that was the case, consider finishig the upgrade before starting replication."
./mysql_upgrade -s -v
Looking for 'mysql' as: ./mysql
The --upgrade-system-tables option was used, databases won't be touched.
Running 'mysql_fix_privilege_tables'...
ERROR 1146 (42S02) at line 37: Table 'mysql.innodb_table_stats' doesn't exist
ERROR 1146 (42S02) at line 46: Table 'mysql.innodb_index_stats' doesn't exist
ERROR 1146 (42S02) at line 74: Table 'mysql.slave_relay_log_info' doesn't exist
ERROR 1243 (HY000) at line 75: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 (HY000) at line 76: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
ERROR 1146 (42S02) at line 104: Table 'mysql.slave_master_info' doesn't exist
ERROR 1243 (HY000) at line 105: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 (HY000) at line 106: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
ERROR 1146 (42S02) at line 123: Table 'mysql.slave_worker_info' doesn't exist
ERROR 1243 (HY000) at line 124: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 (HY000) at line 125: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
ERROR 1146 (42S02) at line 1906: Table 'mysql.slave_master_info' doesn't exist
ERROR 1146 (42S02) at line 1907: Table 'mysql.slave_master_info' doesn't exist
[12 Sep 2012 14:59]
Derek Meyer
Wow.. almost a month into it and nothing
[18 Dec 2012 19:22]
Sveta Smirnova
Thank you for the report.
This is duplicate of already verified bug #67179
Actually bug is partially fixed, so upgrade to 5.6.9 can be helpful.
Page generated in 0.054 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
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.