GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Installing 5.6 fails for no obvious reason

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Installing 5.6 fails for no obvious reason

    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:

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

    Code:
     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:
    table_cache - replaced by table_open_cache in Percona 5.6

    log_slow_queries - replaced by slow_query_log in Percona 5.6

    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.

    Comment

    Working...
    X