-1

Can some one help me please ?

1) Host of my VPS (Centos) was down (Provider problem)
2) After VPS reboot, the node XtraDB cluster refuse to start
3) Other nodes (2) were note impacted

I read lot of posts and try to by many ways but nothing works.

i tried simple start i tried to remove the /var/lib/mysql/xxxxxx.com.pid and try to start i tied to remove the lock file

always the same result : 

#/etc/init.d/mysql start
Starting MySQL (Percona XtraDB Cluster).. ERROR! The server quit without updating PID file (/var/lib/mysql/xxxxxx.com.pid).
ERROR! MySQL (Percona XtraDB Cluster) server startup failed!

or 

#/etc/init.d/mysql start
 ERROR! MySQL (Percona XtraDB Cluster) is not running, but lock file (/var/lock/subsys/mysql) exists
Starting MySQL (Percona XtraDB Cluster).....State transfer in progress, setting sleep higher
.... ERROR! The server quit without updating PID file (/var/lib/mysql/xxxxxxx.com.pid).
 ERROR! MySQL (Percona XtraDB Cluster) server startup failed!

or

#/etc/init.d/mysql start --wsrep-cluster-address="gcomm://"
 ERROR! MySQL (Percona XtraDB Cluster) is not running, but lock file (/var/lock/subsys/mysql) exists
Starting MySQL (Percona XtraDB Cluster).. ERROR! The server quit without updating PID file (/var/lib/mysql/xxxxx.com.pid).
 ERROR! MySQL (Percona XtraDB Cluster) server startup failed!
Ouimaisnon Toiy
  • 25
  • 1
  • 7

1 Answers1

2

I had the same error and none of the other solutions worked for me. However I had a feeling that it had something to do with running out of disk space.

What worked for me was removing the ibdata1, ib_logfile0, and ib_logfile1 in the /var/lib/mysql directory.

The files were re-created on startup. the two logfiles were exactly the same size as previous for the ibdata1 file was half the size.

Someone may be able to confirm, but I believe the ibdata1 file met/exceeded the configured size (I did not set up this instance).

user3121315
  • 46
  • 2