Announcement

Announcement Module
Collapse
No announcement yet.

(Percona XtraDB Cluster) server startup failed!

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • (Percona XtraDB Cluster) server startup failed!

    [root@percona01 ~]# /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).... ERROR! The server quit without updating PID file (/var/lib/mysql/percona01.pid).
    ERROR! MySQL (Percona XtraDB Cluster) server startup failed!

    [root@percona01 ~]# cat /etc/my.cnf
    [mysqld]
    # Path to Galera library
    wsrep_provider=/usr/lib64/libgalera_smm.so
    # Cluster connection URL
    wsrep_cluster_address=192.168.11.60
    # 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 changes how |InnoDB| autoincrement locks are managed and is a requirement for Galera
    innodb_autoinc_lock_mode=2


    [root@percona01 ~]# uname -i
    x86_64
    [root@percona01 ~]# cat /etc/redhat-release
    CentOS release 6.4 (Final)


    [root@percona01 ~]# ifconfig
    eth0 Link encap:Ethernet HWaddr 82:A8:6C:5E:C7:E4
    inet addr:192.168.11.60 Bcast:192.168.11.255 Mask:255.255.254.0
    inet6 addr: fe80::80a8:6cff:fe5e:c7e4/64 Scope:Link
    UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
    RX packets:41623 errors:0 dropped:0 overruns:0 frame:0
    TX packets:301 errors:0 dropped:0 overruns:0 carrier:0
    collisions:0 txqueuelen:1000
    RX bytes:2467282 (2.3 MiB) TX bytes:38171 (37.2 KiB)
    Interrupt:17

    lo Link encap:Local Loopback
    inet addr:127.0.0.1 Mask:255.0.0.0
    inet6 addr: ::1/128 Scope:Host
    UP LOOPBACK RUNNING MTU:16436 Metric:1
    RX packets:0 errors:0 dropped:0 overruns:0 frame:0
    TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
    collisions:0 txqueuelen:0
    RX bytes:0 (0.0 b) TX bytes:0 (0.0 b)

    [root@percona01 ~]# sestatus
    SELinux status: disabled


    Where could be the problem?

    Also tryed with wsrep_cluster_address=gcomm://192.168.11.60 in my.cnf
    Last edited by egor; 03-31-2014, 08:08 AM.

  • #2
    Yes, the wsrep_cluster_address must start with gcomm://.
    What is the 192.168.11.60 here? Is the node you are trying to start a first one?
    Also, always the answer why starting mysqld failed is in the error log

    Comment

    Working...
    X