Problem when Startting the mysql Service the error i mention below

i am getting this error when starting the service of mysql

my xtradb cluster version is 55-5.5.34-25.9.607

MySQL (Percona XtraDB Cluster) is not running, but lock fil[FAILED]lock/subsys/mysql) exists
Starting MySQL (Percona XtraDB Cluster)…The server quit [FAILED]updating PID file (/var/lib/mysql/
MySQL (Percona XtraDB Cluster) server startup failed! [FAILED]

here it is my.cnf file



Path to Galera library


Cluster connection URL contains the IPs of node#1, node#2 and node#3


In order for Galera to work correctly binlog format should be ROW


MyISAM storage engine has only experimental support


This is a recommended tuning variable for performance


This changes how InnoDB autoincrement locks are managed and is a requirement for Galera


Node #1 address


SST method


Cluster name


Authentication for SST method


watanesachin please send error log

What is your operation system?
It looks like it could be selinux issue
echo 0 > /selinux/enforce

If you’re trying to create a new cluster then please follow this URL and check configuration files:

Check the status of your nodes:
show status like ‘wsrep%’;

And check error logs if any error appeared.


Most probably it’s firewall issue, or you didn’t have privilege user on PXC nodes to connect from

PXC is more similar to normal MySQL then NDB cluster. Not sure what you mean here by a client, but each PXC node is equal and you can connect to any of them using mysql client tool.

try this solution…

140113 16:27:52 [Note] WSREP: gcomm: connecting to group 'my_centos_cluster', peer ',,'
140113 16:27:55 [Warning] WSREP: no nodes coming from prim view, prim not possible
140113 16:28:25 [ERROR] WSREP: failed to open gcomm backend connection: 110: failed to reach primary view: 110 (Connection timed out)
at gcomm/src/pc.cpp:connect():141

Look at the messages above, it seems clear that proper connection between this node ( and the other nodes ( and cannot be established. Check the firewall rules, check if you can connect to required TCP ports manually. For example when I test ports from one node to another:

[root@pxc1 ~]# nmap -sT -p 3306,4567

Starting Nmap 5.51 ( ) at 2014-01-16 13:08 UTC
Nmap scan report for
Host is up (0.00025s latency).
3306/tcp open mysql
4567/tcp open tram

I’m not an expert of this But you read more here about this: I would suggest you to create a separate topic for questions like thi one, just to avoid a mess…