Problem when Startting the mysql Service the error i mention below

[watanesachin]

Hi,
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/node3.pid).
MySQL (Percona XtraDB Cluster) server startup failed! [FAILED]

here it is my.cnf file

[mysqld]

datadir=/var/lib/mysql
user=mysql

Path to Galera library

wsrep_provider=/usr/lib64/libgalera_smm.so

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

wsrep_cluster_address=gcomm://192.168.8.24,192.168.8.23,192.168.8.22

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

binlog_format=ROW

MyISAM storage engine has only experimental support

default_storage_engine=InnoDB

This is a recommended tuning variable for performance

innodb_locks_unsafe_for_binlog=1

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

innodb_autoinc_lock_mode=2

Node #1 address

wsrep_node_address=192.168.8.24

SST method

wsrep_sst_method=xtrabackup

Cluster name

wsrep_cluster_name=my_centos_cluster

Authentication for SST method

wsrep_sst_auth=“sstuser:s3cret”
~
~

[mixa]

watanesachin please send error log

[mixa]

What is your operation system?
It looks like it could be selinux issue

http://www.percona.com/doc/percona-xtradb-cluster/5.5/faq.html#q-init-script-etc-init-d-mysql-does-not-start
echo 0 > /selinux/enforce

[mixa]

If you’re trying to create a new cluster then please follow this URL and check configuration files:
http://www.percona.com/doc/percona-xtradb-cluster/5.5/howtos/ubuntu_howto.html

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

And check error logs if any error appeared.

[mirfan]

Sachin,

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

[przemek]

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.

[madhusudan]

try this solution…

http://stackoverflow.com/questions/12425287/mysql-server-has-gone-away-when-importing-large-sql-file

[przemek]

140113 16:27:52 [Note] WSREP: gcomm: connecting to group 'my_centos_cluster', peer '192.168.8.24:,192.168.8.23:,192.168.8.22:'
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 (192.168.8.24) and the other nodes (192.168.8.23 and 192.168.8.22) 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 10.0.2.15

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

[mixa]

I’m not an expert of this But you read more here about this: http://www.percona.com/forums/questions-discussions/percona-monitoring-plugins/9684-percona-monitoring-plugin-for-nagios-to-monitor-mysql?p=9685#post9685 I would suggest you to create a separate topic for questions like thi one, just to avoid a mess…