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
