Not the answer you need?
Register and ask your own question!

Ubuntu 14.04: invoke-rc.d: initscript mysql, action "start" failed

gwijayasgwijayas EntrantCurrent User Role Beginner
When upgrade Percona Server 5.6.25-73.1-1.trusty , I got these error messages on apt process:
* Starting MySQL (Percona Server) database server mysqld                                                                                                                                                    [fail]
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing package percona-server-server-5.6 (--configure):
 subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
 percona-server-server-5.6
E: Sub-process /usr/bin/dpkg returned an error code (1)


on the /var/log/syslog:
Aug  2 19:45:01 bcserver CRON[23017]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
Aug  2 19:46:41 bcserver mysqld_safe[23120]: 2015-08-02 19:46:41 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.
Aug  2 19:46:41 bcserver mysqld_safe[23120]: 2015-08-02 19:46:41 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
Aug  2 19:46:41 bcserver mysqld_safe[23120]: 2015-08-02 19:46:41 0 [Note] /usr/sbin/mysqld (mysqld 5.6.25-73.1) starting as process 23124 ...
Aug  2 19:47:18 bcserver mysqld_safe[23120]:
Aug  2 19:47:18 bcserver mysqld_safe[23120]:
Aug  2 19:47:18 bcserver mysqld_safe[23120]: 2015-08-02 19:47:18 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.
Aug  2 19:47:18 bcserver mysqld_safe[23120]: 2015-08-02 19:47:18 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
Aug  2 19:47:18 bcserver mysqld_safe[23120]: 2015-08-02 19:47:18 0 [Note] /usr/sbin/mysqld (mysqld 5.6.25-73.1) starting as process 23150 ...
Aug  2 19:47:53 bcserver mysqld_safe[23120]: WARNING: Default config file /etc/mysql/my.cnf exists on the system
Aug  2 19:47:53 bcserver mysqld_safe[23120]: This file will be read by default by the MySQL server
Aug  2 19:47:53 bcserver mysqld_safe[23120]: If you do not want to use this, either remove it, or use the
Aug  2 19:47:53 bcserver mysqld_safe[23120]: --defaults-file argument to mysqld_safe when starting the server
Aug  2 19:47:53 bcserver mysqld_safe[23120]:
Aug  2 19:47:53 bcserver mysqld_safe[23191]: 2015-08-02 19:47:53 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.
Aug  2 19:47:53 bcserver mysqld_safe[23191]: 2015-08-02 19:47:53 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
Aug  2 19:47:53 bcserver mysqld_safe[23191]: 2015-08-02 19:47:53 0 [Note] /usr/sbin/mysqld (mysqld 5.6.25-73.1) starting as process 23190 ...
Aug  2 19:48:40 bcserver /etc/init.d/mysql[23783]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Aug  2 19:48:40 bcserver /etc/init.d/mysql[23783]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Aug  2 19:48:40 bcserver /etc/init.d/mysql[23783]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Aug  2 19:48:40 bcserver /etc/init.d/mysql[23783]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Aug  2 19:48:40 bcserver /etc/init.d/mysql[23783]:


Yes, I have add another configuration because I want to put the data on other partition. The additional config on /etc/mysql/conf.d/bc.cnf
[mysqld]
datadir = /data/mysql
max_connections = 4000

key_buffer_size = 200M
low_priority_updates = 1

innodb_buffer_pool_size=300G
skip-name-resolve

Eventhough I could login to new mysql:
~$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.25-73.1 Percona Server (GPL), Release 73.1, Revision 07b797f

Copyright (c) 2009-2015 Percona LLC and/or its affiliates
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

But on dpkg, percona server status is failed
~$ dpkg -l|grep percona
ii  libperconaserverclient18.1           5.6.25-73.1-1.trusty                amd64        Percona Server database client library
ii  percona-server-client-5.6            5.6.25-73.1-1.trusty                amd64        Percona Server database client binaries
ii  percona-server-common-5.6            5.6.25-73.1-1.trusty                amd64        Percona Server database common files (e.g. /etc/mysql/my.cnf)
iF  percona-server-server-5.6            5.6.25-73.1-1.trusty                amd64        Percona Server database server binaries

that make everytime I install/upgrade other package, percona always restart and failed
~$ sudo invoke-rc.d mysql stop
 * Stopping MySQL (Percona Server) mysqld                                                                                                                                                                    [ OK ]
~$ mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

~$ sudo invoke-rc.d mysql start
 * Starting MySQL (Percona Server) database server mysqld                                                                                                                                                    [fail]
invoke-rc.d: initscript mysql, action "start" failed.
~$ mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
~$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.25-73.1 Percona Server (GPL), Release 73.1, Revision 07b797f

Copyright (c) 2009-2015 Percona LLC and/or its affiliates
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

And /var/log/mysql/error.log:
2015-08-02 20:13:50 23666 [Note] Shutting down plugin 'MRG_MYISAM'
2015-08-02 20:13:50 23666 [Note] Shutting down plugin 'CSV'
2015-08-02 20:13:50 23666 [Note] Shutting down plugin 'MEMORY'
2015-08-02 20:13:50 23666 [Note] Shutting down plugin 'sha256_password'
2015-08-02 20:13:50 23666 [Note] Shutting down plugin 'mysql_old_password'
2015-08-02 20:13:50 23666 [Note] Shutting down plugin 'mysql_native_password'
2015-08-02 20:13:50 23666 [Note] Shutting down plugin 'binlog'
2015-08-02 20:13:50 23666 [Note] /usr/sbin/mysqld: Shutdown complete

150802 20:13:50 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
150802 20:14:15 mysqld_safe Starting mysqld daemon with databases from /data/mysql
2015-08-02 20:14:16 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.
2015-08-02 20:14:16 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-08-02 20:14:16 0 [Note] /usr/sbin/mysqld (mysqld 5.6.25-73.1) starting as process 24389 ...
2015-08-02 20:14:16 24389 [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.
2015-08-02 20:14:16 24389 [Note] Plugin 'FEDERATED' is disabled.
2015-08-02 20:14:16 24389 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-08-02 20:14:16 24389 [Note] InnoDB: The InnoDB memory heap is disabled
2015-08-02 20:14:16 24389 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-08-02 20:14:16 24389 [Note] InnoDB: Memory barrier is not used
2015-08-02 20:14:16 24389 [Note] InnoDB: Compressed tables use zlib 1.2.8
2015-08-02 20:14:16 24389 [Note] InnoDB: Using Linux native AIO
2015-08-02 20:14:16 24389 [Note] InnoDB: Using CPU crc32 instructions
2015-08-02 20:14:16 24389 [Note] InnoDB: Initializing buffer pool, size = 300.0G
2015-08-02 20:14:29 24389 [Note] InnoDB: Completed initialization of buffer pool
2015-08-02 20:14:31 24389 [Note] InnoDB: Highest supported file format is Barracuda.
2015-08-02 20:14:34 24389 [Note] InnoDB: 128 rollback segment(s) are active.
2015-08-02 20:14:34 24389 [Note] InnoDB: Waiting for purge to start
2015-08-02 20:14:35 24389 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.25-73.1 started; log sequence number 4535928816
2015-08-02 20:14:35 24389 [Note] RSA private key file not found: /data/mysql//private_key.pem. Some authentication plugins will not work.
2015-08-02 20:14:35 24389 [Note] RSA public key file not found: /data/mysql//public_key.pem. Some authentication plugins will not work.
2015-08-02 20:14:35 24389 [Note] Server hostname (bind-address): '*'; port: 3306
2015-08-02 20:14:35 24389 [Note] IPv6 is available.
2015-08-02 20:14:35 24389 [Note]   - '::' resolves to '::';
2015-08-02 20:14:35 24389 [Note] Server socket created on IP: '::'.
2015-08-02 20:14:35 24389 [Warning] 'user' entry 'root@bcserver' ignored in --skip-name-resolve mode.
2015-08-02 20:14:35 24389 [Warning] 'proxies_priv' entry '@ root@bcserver' ignored in --skip-name-resolve mode.
2015-08-02 20:14:35 24389 [Note] Event Scheduler: Loaded 0 events
2015-08-02 20:14:35 24389 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.25-73.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Percona Server (GPL), Release 73.1, Revision 07b797f
Thanks in advanced

Comments

  • jriverajrivera Percona Support Engineer Percona Staff Role
    I wonder why you have to start/stop mysql with invoke-rc.d, can't you try with:

    shell> sudo /etc/init.d/mysql stop

    or

    shell> sudo /etc/init.d/mysql start
  • mrattilakovacsmrattilakovacs Entrant Inactive User Role Beginner
    You would never think of that flaw :)

    chmod 777 /tmp

    and start over uninstall reinstall
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.