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