MySQL Forums
Forum List  »  Install & Repo

Tables missing (slave_**_info) with own directory
Posted by: Dominik Schmidt
Date: January 29, 2014 03:25AM

Hi !

I have a little problem getting 5.6.15 working on my Windows 7 x64 machine.

I downloaded the mysql ZIP (32 Bit version) und decompressed it. If I run mysqld --console in the \bin folder everthings works fine. mysql_upgrade.exe -v returns no warnings or errors.

Things getting strange if I try to use my own config file:
[mysqld]
port = 2804
skip-external-locking
key_buffer_size = 16K
max_allowed_packet = 2M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 128K
bind-address = 0.0.0.0

innodb_flush_log_at_trx_commit = 2
innodb_thread_concurrency=8
innodb_file_per_table = 1
innodb_file_format = Barracuda

basedir = D:\\data\\MySQL\\mysql-5.6.15-win32
innodb_data_home_dir = D:\\data\\MySQL\\56Test\\
innodb_log_group_home_dir = D:\\data\\MySQL\\56Test\\
pid-file = D:\\data\\MySQL\\56Test\\mysqld.pid
datadir = D:\\data\\MySQL\\56Test\\
tmpdir = D:\\data\\MySQL\\56Test\\tmp\\


The folder D:\\data\\MySQL\\56Test contains the mysql folder (with the frm, MYD, MYI files) and the performance_schema folder (and tmp folder).

If I start the mysqld by this command:
mysqld.exe --defaults-file="D:\Dev Priv\LogView Studio\MySQL\56Test\lv56test.cnf" --console

I got this output:
2014-01-29 10:19:05 5336 [Note] InnoDB: 5.6.15 started; log sequence number 1600667
2014-01-29 10:19:05 5336 [Note] Server hostname (bind-address): '0.0.0.0'; port: 2804
2014-01-29 10:19:05 5336 [Note] - '0.0.0.0' resolves to '0.0.0.0';
2014-01-29 10:19:05 5336 [Note] Server socket created on IP: '0.0.0.0'.
2014-01-29 10:19:06 5336 [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.mys
ql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2014-01-29 10:19:06 5336 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
2014-01-29 10:19:06 5336 [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.mys
ql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2014-01-29 10:19:06 5336 [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.
2014-01-29 10:19:06 5336 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.

And if I run
mysql_upgrade.exe -P 2804 -v
I get Errors:
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

...

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'...
ERROR 1146 (42S02) at line 62: Table 'mysql.innodb_table_stats' doesn't exist
ERROR 1243 (HY000) at line 63: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 (HY000) at line 64: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
ERROR 1146 (42S02) at line 66: Table 'mysql.innodb_index_stats' doesn't exist
ERROR 1243 (HY000) at line 67: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 (HY000) at line 68: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
ERROR 1146 (42S02) at line 81: Table 'mysql.slave_relay_log_info' doesn't exist
ERROR 1243 (HY000) at line 82: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 (HY000) at line 83: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
ERROR 1146 (42S02) at line 110: Table 'mysql.slave_master_info' doesn't exist
ERROR 1243 (HY000) at line 111: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 (HY000) at line 112: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
ERROR 1146 (42S02) at line 128: Table 'mysql.slave_worker_info' doesn't exist
ERROR 1243 (HY000) at line 129: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 (HY000) at line 130: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
ERROR 1146 (42S02) at line 1881: Table 'mysql.slave_master_info' doesn't exist
ERROR 1146 (42S02) at line 1882: Table 'mysql.slave_master_info' doesn't exist
ERROR 1146 (42S02) at line 1883: Table 'mysql.slave_master_info' doesn't exist
ERROR 1146 (42S02) at line 1884: Table 'mysql.slave_worker_info' doesn't exist
ERROR 1146 (42S02) at line 1885: Table 'mysql.slave_relay_log_info' doesn't exist
ERROR 1146 (42S02) at line 1889: Table 'mysql.innodb_table_stats' doesn't exist
ERROR 1146 (42S02) at line 1893: Table 'mysql.innodb_index_stats' doesn't exist
ERROR 1436 (HY000) at line 1920: Thread stack overrun: 7644 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack.
FATAL ERROR: Upgrade failed


Has anyone an idea whats wrong here? Did I miss some files in my own directories? Or did I miss a setting in the config file?

btw ... the *.frm and *.idb files are all present in the mysql folder.

Best regards
Dominik Schmidt

Options: ReplyQuote


Subject
Written By
Posted
Tables missing (slave_**_info) with own directory
January 29, 2014 03:25AM


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.