Web lists-archives.com

Starting mysql 5.7.7




Hello,

I have reinstalled a test server after a disk crash. I upgraded from an older Fedora Core (don't 
remember the version) to Fedora Core 21.

Then I installed Mysql 5.7.7 from RPM. I'm able to start it but mysql does not use my /etc/my.cnf 
file and I do not find any other on my system.

After doing a 'yum install  ...' I started it without a my.cnf file. It seem to start OK and all the 
database files++ was added to /var/lib/mysql.

Since I got a SSD disk where I want to locate the databases, I stopped mysql and moved the file to 
this disk and added links (just as I did on the old system).
I removed all ib* files and added my myc.fn file (it contain info about ibdata files etc) and then 
tried to start it - no luck.

Base on the entries in /var/log/messages, it does not seem to use the /etc/my.cnf file. There is 
also a few warnings which I'm not sure how to fix.

Any suggestions what's wrong?


My my.cnf file:
# The MySQL server
[mysqld]
port		= 3306
socket		= /tmp/mysql.sock

skip-external-locking
key_buffer_size = 384M
max_allowed_packet = 32M
table_open_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 16
max_connections = 50

log-bin=/var/mysql/mysql-bin

server-id	= 1

binlog_format=mixed

# Innodb settings.

# Open files.
innodb_open_files               = 2048 
open_files_limit                = 8096

innodb_data_home_dir		= /data/mysql/data
innodb_data_file_path		= ibdata1:20G;ibdata2:20G;ibdata3:20G;ibdata4:20G:autoextend
innodb_file_per_table		= 0
innodb_autoextend_increment	= 256

innodb_log_group_home_dir	= /data/mysql/data

# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high.
innodb_buffer_pool_size		= 25G 

# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size		= 300M
innodb_log_files_in_group	= 2
innodb_log_buffer_size		= 128M

innodb_flush_log_at_trx_commit	= 1
innodb_support_xa		= 0
innodb_flush_method		= O_DIRECT
innodb_lock_wait_timeout	= 50
innodb_fast_shutdown		= 0



From /var/log/messages:


May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.255284Z 0 [Warning] TIMESTAMP with implicit 
DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see 
documentation for more details).
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.256631Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.7-
rc) starting as process 1528 ...
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.265686Z 0 [Note] InnoDB: Mutexes and rw_locks use 
GCC atomic builtins
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.266263Z 0 [Note] InnoDB: Uses event mutexes
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.266661Z 0 [Note] InnoDB: GCC builtin 
__atomic_thread_fence() is used for memory barrier
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.267045Z 0 [Note] InnoDB: Compressed tables use 
zlib 1.2.3
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.267432Z 0 [Note] InnoDB: Using Linux native AIO
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.268269Z 0 [Note] InnoDB: Number of pools: 1
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.268804Z 0 [Note] InnoDB: Using CPU crc32 
instructions
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.270686Z 0 [Note] InnoDB: Initializing buffer 
pool, total size = 128M, instances = 1, chunk size = 128M
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.298852Z 0 [Note] InnoDB: Completed initialization 
of buffer pool
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.353601Z 0 [Note] InnoDB: If the mysqld execution 
user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.356077Z 0 [Note] InnoDB: Highest supported file 
format is Barracuda.
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.361383Z 0 [Note] InnoDB: Log scan progressed past 
the checkpoint lsn 1210467
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.361927Z 0 [Note] InnoDB: Doing recovery: scanned 
up to log sequence number 1210476
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.362672Z 0 [Note] InnoDB: Doing recovery: scanned 
up to log sequence number 1210476
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.363083Z 0 [Note] InnoDB: Database was not 
shutdown normally!
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.363456Z 0 [Note] InnoDB: Starting crash recovery.
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.484951Z 0 [Note] InnoDB: Removed temporary 
tablespace data file: "ibtmp1"
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.488568Z 0 [Note] InnoDB: Creating shared 
tablespace for temporary tables
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.489014Z 0 [Note] InnoDB: Setting file './ibtmp1' 
size to 12 MB. Physically writing the file full; Please wait ...
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.536654Z 0 [Note] InnoDB: File './ibtmp1' size is 
now 12 MB.
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.538070Z 0 [Note] InnoDB: 96 redo rollback 
segment(s) found. 96 redo rollback segment(s) are active.
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.538087Z 0 [Note] InnoDB: 32 non-redo rollback 
segment(s) are active.
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.538301Z 0 [Note] InnoDB: Waiting for purge to 
start
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.594640Z 0 [Note] InnoDB: 5.7.7 started; log 
sequence number 1210476
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.595238Z 0 [Note] InnoDB: Loading buffer pool(s) 
from .//ib_buffer_pool
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.595286Z 0 [ERROR] InnoDB: Cannot open 
'.//ib_buffer_pool' for reading: No such file or directory
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.595415Z 0 [Note] Plugin 'FEDERATED' is disabled.
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.595846Z 0 [Warning] InnoDB: Cannot open table 
mysql/plugin from the internal data dictionary of InnoDB though the .frm file for the table exists. 
Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how to 
resolve the issue.
May 15 09:41:27 anakin mysqld: mysqld: Table 'mysql.plugin' doesn't exist
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.595877Z 0 [ERROR] Can't open the mysql.plugin 
table. Please run mysql_upgrade to create it.
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.596419Z 0 [Warning] InnoDB: Cannot open table 
mysql/gtid_executed from the internal data dictionary of InnoDB though the .frm file for the table 
exists. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how 
to resolve the issue.
May 15 09:41:27 anakin mysqld: mysqld: Table 'mysql.gtid_executed' doesn't exist
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.596439Z 0 [Warning] Gtid table is not ready to be 
used. Table 'mysql.gtid_executed' cannot be opened.
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.596483Z 0 [Warning] Failed to setup SSL
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.596493Z 0 [Warning] SSL error: SSL context is not 
usable without certificate and private key
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.596915Z 0 [Note] Server hostname (bind-address): 
'*'; port: 3306
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.596952Z 0 [Note] IPv6 is available.
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.596967Z 0 [Note]   - '::' resolves to '::';
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.596976Z 0 [Note] Server socket created on IP: 
'::'.
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.599237Z 0 [Warning] InnoDB: Cannot open table 
mysql/server_cost from the internal data dictionary of InnoDB though the .frm file for the table 
exists. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how 
to resolve the issue.
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.599259Z 0 [Warning] Failed to open optimizer cost 
constant tables
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.600318Z 0 [Warning] InnoDB: Cannot open table 
mysql/time_zone_leap_second from the internal data dictionary of InnoDB though the .frm file for the 
table exists. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for 
how to resolve the issue.
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.600340Z 0 [Warning] Can't open and lock time zone 
table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.604819Z 0 [Warning] InnoDB: Cannot open table 
mysql/servers from the internal data dictionary of InnoDB though the .frm file for the table exists. 
Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how to 
resolve the issue.
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.604842Z 0 [ERROR] Can't open and lock privilege 
tables: Table 'mysql.servers' doesn't exist
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.616215Z 0 [Note] Event Scheduler: Loaded 0 events
May 15 09:41:27 anakin mysqld: 2015-05-15T07:41:27.619566Z 0 [Note] /usr/sbin/mysqld: ready for 
connections.
May 15 09:41:27 anakin mysqld: Version: '5.7.7-rc'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  
MySQL Community Server (GPL)


[Comment: This part seem to repeat itself until I stop the mysql daemon]

May 15 09:42:57 anakin systemd: mysqld.service start operation timed out. Terminating.
May 15 09:42:57 anakin systemd: Failed to start MySQL Server.
May 15 09:42:57 anakin systemd: Unit mysqld.service entered failed state.
May 15 09:42:57 anakin systemd: mysqld.service failed.
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.651714Z 0 [Warning] TIMESTAMP with implicit 
DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see 
documentation for more details).
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.652654Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.7-
rc) starting as process 1576 ...
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.661812Z 0 [Note] InnoDB: Mutexes and rw_locks use 
GCC atomic builtins
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.661873Z 0 [Note] InnoDB: Uses event mutexes
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.661883Z 0 [Note] InnoDB: GCC builtin 
__atomic_thread_fence() is used for memory barrier
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.661891Z 0 [Note] InnoDB: Compressed tables use 
zlib 1.2.3
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.661898Z 0 [Note] InnoDB: Using Linux native AIO
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.662681Z 0 [Note] InnoDB: Number of pools: 1
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.662944Z 0 [Note] InnoDB: Using CPU crc32 
instructions
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.665426Z 0 [Note] InnoDB: Initializing buffer 
pool, total size = 128M, instances = 1, chunk size = 128M
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.697243Z 0 [Note] InnoDB: Completed initialization 
of buffer pool
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.717179Z 0 [Note] InnoDB: Highest supported file 
format is Barracuda.
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.722580Z 0 [Note] InnoDB: If the mysqld execution 
user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.725961Z 0 [Note] InnoDB: Log scan progressed past 
the checkpoint lsn 1210893
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.728948Z 0 [Note] InnoDB: Doing recovery: scanned 
up to log sequence number 1210902
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.729312Z 0 [Note] InnoDB: Doing recovery: scanned 
up to log sequence number 1210902
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.729323Z 0 [Note] InnoDB: Database was not 
shutdown normally!
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.729330Z 0 [Note] InnoDB: Starting crash recovery.
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.851622Z 0 [Note] InnoDB: Removed temporary 
tablespace data file: "ibtmp1"
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.852038Z 0 [Note] InnoDB: Creating shared 
tablespace for temporary tables
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.852357Z 0 [Note] InnoDB: Setting file './ibtmp1' 
size to 12 MB. Physically writing the file full; Please wait ...
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.906373Z 0 [Note] InnoDB: File './ibtmp1' size is 
now 12 MB.
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.907726Z 0 [Note] InnoDB: 96 redo rollback 
segment(s) found. 96 redo rollback segment(s) are active.
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.907736Z 0 [Note] InnoDB: 32 non-redo rollback 
segment(s) are active.
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.907944Z 0 [Note] InnoDB: Waiting for purge to 
start
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.964668Z 0 [Note] InnoDB: 5.7.7 started; log 
sequence number 1210902
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.968579Z 0 [Note] InnoDB: Loading buffer pool(s) 
from .//ib_buffer_pool
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.968625Z 0 [ERROR] InnoDB: Cannot open 
'.//ib_buffer_pool' for reading: No such file or directory
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.970723Z 0 [Note] Plugin 'FEDERATED' is disabled.
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.971171Z 0 [Warning] InnoDB: Cannot open table 
mysql/plugin from the internal data dictionary of InnoDB though the .frm file for the table exists. 
Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how to 
resolve the issue.
May 15 09:42:57 anakin mysqld: mysqld: Table 'mysql.plugin' doesn't exist
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.971202Z 0 [ERROR] Can't open the mysql.plugin 
table. Please run mysql_upgrade to create it.
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.975105Z 0 [Warning] InnoDB: Cannot open table 
mysql/gtid_executed from the internal data dictionary of InnoDB though the .frm file for the table 
exists. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how 
to resolve the issue.
May 15 09:42:57 anakin mysqld: mysqld: Table 'mysql.gtid_executed' doesn't exist
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.975144Z 0 [Warning] Gtid table is not ready to be 
used. Table 'mysql.gtid_executed' cannot be opened.
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.975196Z 0 [Warning] Failed to setup SSL
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.975206Z 0 [Warning] SSL error: SSL context is not 
usable without certificate and private key
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.975663Z 0 [Note] Server hostname (bind-address): 
'*'; port: 3306
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.975705Z 0 [Note] IPv6 is available.
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.975725Z 0 [Note]   - '::' resolves to '::';
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.975733Z 0 [Note] Server socket created on IP: 
'::'.
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.984931Z 0 [Warning] InnoDB: Cannot open table 
mysql/server_cost from the internal data dictionary of InnoDB though the .frm file for the table 
exists. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how 
to resolve the issue.
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.984972Z 0 [Warning] Failed to open optimizer cost 
constant tables
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.985645Z 0 [Warning] InnoDB: Cannot open table 
mysql/time_zone_leap_second from the internal data dictionary of InnoDB though the .frm file for the 
table exists. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for 
how to resolve the issue.
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.985661Z 0 [Warning] Can't open and lock time zone 
table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.986086Z 0 [Warning] InnoDB: Cannot open table 
mysql/servers from the internal data dictionary of InnoDB though the .frm file for the table exists. 
Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how to 
resolve the issue.
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.986100Z 0 [ERROR] Can't open and lock privilege 
tables: Table 'mysql.servers' doesn't exist
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.997527Z 0 [Note] Event Scheduler: Loaded 0 events
May 15 09:42:57 anakin mysqld: 2015-05-15T07:42:57.997956Z 0 [Note] /usr/sbin/mysqld: ready for 
connections.
May 15 09:42:57 anakin mysqld: Version: '5.7.7-rc'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  
MySQL Community Server (GPL)



-- 
Jørn Dahl-Stamnes
homepage: http://photo.dahl-stamnes.net/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql