Installing 5.6 fails for no obvious reason

MySQL & MariaDB Percona Server for MySQL 5.6
1

i’m trying to install 5.6 on a VM on a dev machine but it fails with no obvious error in the logs. I’m running the same version on a production server without issue with same OS and mostly the same packages (they’re both provisioned using Puppet).

The install process just drops me back to the shell without showing that the server start completed:

Setting up percona-server-server-5.6 (5.6.16-64.1-563.precise) ...
* Stopping MySQL (Percona Server) mysqld [ OK ]
2014-03-22 13:59:06 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2014-03-22 13:59:06 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).


* Percona Server is distributed with several useful UDF (User Defined Function) from Percona Toolkit.
* Run the following commands to create these functions:

mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"

* See http://www.percona.com/doc/percona-server/5.6/management/udf_percona_toolkit.html for more details


* Starting MySQL (Percona Server) database server mysqld

In the log it shows “Killed” but no obvious error:

2014-03-22 13:59:02 12980 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-03-22 13:59:02 12980 [Note] InnoDB: The InnoDB memory heap is disabled
2014-03-22 13:59:02 12980 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-03-22 13:59:02 12980 [Note] InnoDB: Compressed tables use zlib 1.2.3.4
2014-03-22 13:59:02 12980 [Note] InnoDB: Using Linux native AIO
2014-03-22 13:59:02 12980 [Note] InnoDB: Using CPU crc32 instructions
2014-03-22 13:59:02 12980 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-03-22 13:59:02 12980 [Note] InnoDB: Completed initialization of buffer pool
2014-03-22 13:59:02 12980 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2014-03-22 13:59:02 12980 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2014-03-22 13:59:02 12980 [Note] InnoDB: Database physically writes the file full: wait...
2014-03-22 13:59:02 12980 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2014-03-22 13:59:02 12980 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2014-03-22 13:59:02 12980 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2014-03-22 13:59:02 12980 [Warning] InnoDB: New log files created, LSN=45781
2014-03-22 13:59:02 12980 [Note] InnoDB: Doublewrite buffer not found: creating new
2014-03-22 13:59:02 12980 [Note] InnoDB: Doublewrite buffer created
2014-03-22 13:59:02 12980 [Note] InnoDB: 128 rollback segment(s) are active.
2014-03-22 13:59:02 12980 [Warning] InnoDB: Creating foreign key constraint system tables.
2014-03-22 13:59:02 12980 [Note] InnoDB: Foreign key constraint system tables created
2014-03-22 13:59:02 12980 [Note] InnoDB: Creating tablespace and datafile system tables.
2014-03-22 13:59:02 12980 [Note] InnoDB: Tablespace and datafile system tables created.
2014-03-22 13:59:02 12980 [Note] InnoDB: Waiting for purge to start
2014-03-22 13:59:02 12980 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.16-64.1 started; log sequence number 0
2014-03-22 13:59:02 12980 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
2014-03-22 13:59:02 12980 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
2014-03-22 13:59:02 12980 [Note] Binlog end
2014-03-22 13:59:02 12980 [Note] InnoDB: FTS optimize thread exiting.
2014-03-22 13:59:02 12980 [Note] InnoDB: Starting shutdown...
2014-03-22 13:59:04 12980 [Note] InnoDB: Shutdown completed; log sequence number 1625977
2014-03-22 13:59:04 13006 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-03-22 13:59:04 13006 [Note] InnoDB: The InnoDB memory heap is disabled
2014-03-22 13:59:04 13006 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-03-22 13:59:04 13006 [Note] InnoDB: Compressed tables use zlib 1.2.3.4
2014-03-22 13:59:04 13006 [Note] InnoDB: Using Linux native AIO
2014-03-22 13:59:04 13006 [Note] InnoDB: Using CPU crc32 instructions
2014-03-22 13:59:04 13006 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-03-22 13:59:04 13006 [Note] InnoDB: Completed initialization of buffer pool
2014-03-22 13:59:04 13006 [Note] InnoDB: Highest supported file format is Barracuda.
2014-03-22 13:59:04 13006 [Note] InnoDB: 128 rollback segment(s) are active.
2014-03-22 13:59:04 13006 [Note] InnoDB: Waiting for purge to start
2014-03-22 13:59:04 13006 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.16-64.1 started; log sequence number 1625977
2014-03-22 13:59:04 13006 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
2014-03-22 13:59:04 13006 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
2014-03-22 13:59:04 13006 [Note] Binlog end
2014-03-22 13:59:04 13006 [Note] InnoDB: FTS optimize thread exiting.
2014-03-22 13:59:04 13006 [Note] InnoDB: Starting shutdown...
2014-03-22 13:59:06 13006 [Note] InnoDB: Shutdown completed; log sequence number 1625987
2014-03-22 13:59:06 13044 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
2014-03-22 13:59:06 13044 [Note] Plugin 'FEDERATED' is disabled.
2014-03-22 13:59:06 13044 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-03-22 13:59:06 13044 [Note] InnoDB: The InnoDB memory heap is disabled
2014-03-22 13:59:06 13044 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-03-22 13:59:06 13044 [Note] InnoDB: Compressed tables use zlib 1.2.3.4
2014-03-22 13:59:06 13044 [Note] InnoDB: Using Linux native AIO
2014-03-22 13:59:06 13044 [Note] InnoDB: Using CPU crc32 instructions
2014-03-22 13:59:06 13044 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-03-22 13:59:06 13044 [Note] InnoDB: Completed initialization of buffer pool
2014-03-22 13:59:06 13044 [Note] InnoDB: Highest supported file format is Barracuda.
2014-03-22 13:59:06 13044 [Note] InnoDB: 128 rollback segment(s) are active.
2014-03-22 13:59:06 13044 [Note] InnoDB: Waiting for purge to start
2014-03-22 13:59:06 13044 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.16-64.1 started; log sequence number 1625987
2014-03-22 13:59:06 13044 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
2014-03-22 13:59:06 13044 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
2014-03-22 13:59:06 13044 [Note] Binlog end
2014-03-22 13:59:06 13044 [Note] InnoDB: FTS optimize thread exiting.
2014-03-22 13:59:06 13044 [Note] InnoDB: Starting shutdown...
2014-03-22 13:59:08 13044 [Note] InnoDB: Shutdown completed; log sequence number 1625997
2014-03-22 13:59:08 13072 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
2014-03-22 13:59:08 13072 [Note] Plugin 'FEDERATED' is disabled.
2014-03-22 13:59:08 13072 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-03-22 13:59:08 13072 [Note] InnoDB: The InnoDB memory heap is disabled
2014-03-22 13:59:08 13072 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-03-22 13:59:08 13072 [Note] InnoDB: Compressed tables use zlib 1.2.3.4
2014-03-22 13:59:08 13072 [Note] InnoDB: Using Linux native AIO
2014-03-22 13:59:08 13072 [Note] InnoDB: Using CPU crc32 instructions
2014-03-22 13:59:08 13072 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-03-22 13:59:09 13072 [Note] InnoDB: Completed initialization of buffer pool
2014-03-22 13:59:09 13072 [Note] InnoDB: Highest supported file format is Barracuda.
2014-03-22 13:59:09 13072 [Note] InnoDB: 128 rollback segment(s) are active.
2014-03-22 13:59:09 13072 [Note] InnoDB: Waiting for purge to start
2014-03-22 13:59:09 13072 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.16-64.1 started; log sequence number 1625997
2014-03-22 13:59:09 13072 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
2014-03-22 13:59:09 13072 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
2014-03-22 13:59:09 13072 [Note] Binlog end
2014-03-22 13:59:09 13072 [Note] InnoDB: FTS optimize thread exiting.
2014-03-22 13:59:09 13072 [Note] InnoDB: Starting shutdown...
2014-03-22 13:59:11 13072 [Note] InnoDB: Shutdown completed; log sequence number 1626007
140322 13:59:11 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Killed
140322 13:59:12 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

I tried 5.5 and that installs fine, I also tried upgrading from 5.5 to 5.6 and had the same issue as a clean install.

2

Hi Philio,

As you are facing the same issue while upgrading, please make sure that you have removed any default installation of MySQL and it’s ‘my.cnf’ file from the server before trying a fresh install. This is because some of the parameter names have changed in the 5.6 build.

For example:

The same applies if you are trying to upgrade your Percona 5.5 installation to 5.6. You will need to update the parameters in the ‘my.cnf’ to make sure that mysql service starts all okay.