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

Unable to start mysql service.

anirudhaanirudha EntrantCurrent User Role Beginner
I have followed all the steps from "https://www.percona.com/doc/percona-xtradb-cluster/5.6/installation.html#installation" to install Percona XtraDB on my CentOS6.5 x64bit host. But when tried to start the mysql service it failed with below error,

====
[[email protected] ~]# service mysql status
Redirecting to /bin/systemctl status mysql.service
mysql.service - Percona XtraDB Cluster
Loaded: loaded (/usr/lib/systemd/system/mysql.service; disabled)
Active: failed (Result: exit-code) since Wed 2015-09-23 22:44:44 EDT; 6min ago
Process: 3379 ExecStopPost=/usr/bin/mysql-systemd stop-post (code=exited, status=0/SUCCESS)
Process: 3352 ExecStop=/usr/bin/mysql-systemd stop (code=exited, status=2)
Process: 2894 ExecStartPost=/usr/bin/mysql-systemd start-post $MAINPID (code=exited, status=1/FAILURE)
Process: 2893 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=0/SUCCESS)
Process: 2849 ExecStartPre=/usr/bin/mysql-systemd start-pre (code=exited, status=0/SUCCESS)
Main PID: 2893 (code=exited, status=0/SUCCESS)
CGroup: /system.slice/mysql.service

Sep 23 22:44:44 localhost.localdomain mysql-systemd[2894]: /usr/bin/mysql-systemd: line 134: kill: (2893) - No such process
Sep 23 22:44:44 localhost.localdomain mysql-systemd[2894]: ERROR! mysqld_safe with PID 2893 has already exited: FAILURE
Sep 23 22:44:44 localhost.localdomain systemd[1]: mysql.service: control process exited, code=exited status=1
Sep 23 22:44:44 localhost.localdomain mysql-systemd[3352]: WARNING: mysql pid file /run/mysqld/mysql.pid empty or not readable
Sep 23 22:44:44 localhost.localdomain mysql-systemd[3352]: ERROR! mysql already dead
Sep 23 22:44:44 localhost.localdomain systemd[1]: mysql.service: control process exited, code=exited status=2
Sep 23 22:44:44 localhost.localdomain mysql-systemd[3379]: WARNING: mysql pid file /run/mysqld/mysql.pid empty or not readable
Sep 23 22:44:44 localhost.localdomain mysql-systemd[3379]: WARNING: mysql may be already dead
Sep 23 22:44:44 localhost.localdomain systemd[1]: Failed to start Percona XtraDB Cluster.
Sep 23 22:44:44 localhost.localdomain systemd[1]: Unit mysql.service entered failed state.
[[email protected] ~]#
====

Here is my my.cnf file,

====
[[email protected] ~]# cat /etc/my.cnf
# Template my.cnf for PXC
# Edit to your requirements.

[mysqld]

log_bin

binlog_format = ROW
innodb_buffer_pool_size = 100M
innodb_flush_log_at_trx_commit = 0
innodb_flush_method = O_DIRECT
innodb_log_files_in_group = 2
innodb_log_file_size = 20M
innodb_file_per_table = 1
default_storage_engine = InnoDB
datadir = /var/lib/mysql

wsrep_cluster_address = gcomm://10.1.135.27
wsrep_provider = /usr/lib64/galera3/libgalera_smm.so

wsrep_slave_threads = 8
wsrep_cluster_name = Cluster
wsrep_node_name = Node1
wsrep_node_address = 10.1.135.27
wsrep_sst_method = rsync
wsrep_sst_auth = "sstuser:s3cret"

innodb_locks_unsafe_for_binlog = 1
innodb_autoinc_lock_mode = 2



[mysqld_safe]
pid-file = /run/mysqld/mysql.pid
syslog


!includedir /etc/my.cnf.d
====

Any idea how can I debug this?

Comments

  • dendressdendress Entrant Current User Role Beginner
    Check the ownership and permissions of the directory the .pid file is being written.

    Also, please sanitize your post. Removing auth info from any posting is a good idea.
  • rollsrolls Contributor Inactive User Role Beginner
    make chonw -R mysql:mysql on your database directory (/var/lib/mysql)

    then start the server with #service mysql bootstrap-pxc
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.