# Problem when Startting the mysql Service the error i mention below **URL:** \ **Category:** Percona XtraDB Cluster 5.x\ **Created:** [January 1, 2014, 5:11am UTC](https://forums.percona.com/t/problem-when-startting-the-mysql-service-the-error-i-mention-below/3171 "2014-01-01T05:11:09Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![watanesachin](https://avatars.discourse-cdn.com/v4/letter/w/ecd19e/32.png) [@watanesachin](https://forums.percona.com/u/watanesachin)\ **Post date:** [January 1, 2014, 5:11am UTC](https://forums.percona.com/t/problem-when-startting-the-mysql-service-the-error-i-mention-below/3171/1 "2014-01-01T05:11:09Z")
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” ~ ~ ---
**Author:** ![mixa](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mixa/32/16881_2.png) [@mixa](https://forums.percona.com/u/mixa)\ **Post date:** [January 1, 2014, 5:23am UTC](https://forums.percona.com/t/problem-when-startting-the-mysql-service-the-error-i-mention-below/3171/2 "2014-01-01T05:23:12Z")
watanesachin please send error log ---
**Author:** ![mixa](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mixa/32/16881_2.png) [@mixa](https://forums.percona.com/u/mixa)\ **Post date:** [January 1, 2014, 5:43am UTC](https://forums.percona.com/t/problem-when-startting-the-mysql-service-the-error-i-mention-below/3171/3 "2014-01-01T05:43:38Z")
What is your operation system? It looks like it could be selinux issue [url][Frequently Asked Questions](http://www.percona.com/doc/percona-xtradb-cluster/5.5/faq.html#q-init-script-etc-init-d-mysql-does-not-start%5B/url%5D) echo 0 \> /selinux/enforce ---
**Author:** ![mixa](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mixa/32/16881_2.png) [@mixa](https://forums.percona.com/u/mixa)\ **Post date:** [January 1, 2014, 7:03am UTC](https://forums.percona.com/t/problem-when-startting-the-mysql-service-the-error-i-mention-below/3171/4 "2014-01-01T07:03:02Z")
If you’re trying to create a new cluster then please follow this URL and check configuration files: [url][Percona XtraDB Cluster](http://www.percona.com/doc/percona-xtradb-cluster/5.5/howtos/ubuntu_howto.html%5B/url%5D) Check the status of your nodes: show status like ‘wsrep%’; And check error logs if any error appeared. ---
**Author:** ![mirfan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mirfan/32/16890_2.png) [@mirfan](https://forums.percona.com/u/mirfan)\ **Post date:** [January 2, 2014, 1:53am UTC](https://forums.percona.com/t/problem-when-startting-the-mysql-service-the-error-i-mention-below/3171/5 "2014-01-02T01:53:53Z")
Sachin, Most probably it’s firewall issue, or you didn’t have privilege user on PXC nodes to connect from 192.168.8.25 ---
**Author:** ![przemek](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/przemek/32/3_2.png) [@przemek](https://forums.percona.com/u/przemek)\ **Post date:** [January 3, 2014, 9:31am UTC](https://forums.percona.com/t/problem-when-startting-the-mysql-service-the-error-i-mention-below/3171/6 "2014-01-03T09:31:55Z")
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. ---
**Author:** ![madhusudan](https://avatars.discourse-cdn.com/v4/letter/m/76d3ee/32.png) [@madhusudan](https://forums.percona.com/u/madhusudan)\ **Post date:** [January 16, 2014, 2:13am UTC](https://forums.percona.com/t/problem-when-startting-the-mysql-service-the-error-i-mention-below/3171/7 "2014-01-16T02:13:30Z")
try this solution… [URL][phpmyadmin - MySQL Server has gone away when importing large sql file - Stack Overflow](http://stackoverflow.com/questions/12425287/mysql-server-has-gone-away-when-importing-large-sql-file%5B/URL%5D) ---
**Author:** ![przemek](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/przemek/32/3_2.png) [@przemek](https://forums.percona.com/u/przemek)\ **Post date:** [January 16, 2014, 7:39am UTC](https://forums.percona.com/t/problem-when-startting-the-mysql-service-the-error-i-mention-below/3171/8 "2014-01-16T07:39:33Z")
```auto 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: ```auto [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 ``` ---
**Author:** ![mixa](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mixa/32/16881_2.png) [@mixa](https://forums.percona.com/u/mixa)\ **Post date:** [January 27, 2014, 2:12pm UTC](https://forums.percona.com/t/problem-when-startting-the-mysql-service-the-error-i-mention-below/3171/9 "2014-01-27T14:12:49Z")
I’m not an expert of this But you read more here about this: [url][http://www.percona.com/forums/questions-discussions/percona-monitoring-plugins/9684-percona-monitoring-plugin-for-nagios-to-monitor-mysql?p=9685#post9685[/url]](http://www.percona.com/forums/questions-discussions/percona-monitoring-plugins/9684-percona-monitoring-plugin-for-nagios-to-monitor-mysql?p=9685#post9685%5B/url%5D) I would suggest you to create a separate topic for questions like thi one, just to avoid a mess…