Web lists-archives.com

Re: Starting mysql 5.7.7




Have u executed mysql_install_db?
On 15-May-2015 1:31 pm, "Jørn Dahl-Stamnes" <sql07@xxxxxxxxxxxxxxxx> wrote:

> 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
>
>