GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Cluster failed to start on RHEL 6.2

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

  • Cluster failed to start on RHEL 6.2

    Hi! So i was trying to set up a little XtraDB cluster on RHEL 6.2 but can't even start mysql daemon with pretty default settings
    Error log shows me the following:
    Code:
    130711 13:43:16 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    130711 13:43:16 mysqld_safe Skipping wsrep-recover for empty datadir: /var/lib/mysql
    130711 13:43:16 mysqld_safe Assigning 00000000-0000-0000-0000-000000000000:-1 to wsrep_start_position
    130711 13:43:16 [Note] WSREP: wsrep_start_position var submitted: '00000000-0000-0000-0000-000000000000:-1'
    130711 13:43:16 [Note] WSREP: Read nil XID from storage engines, skipping position init
    130711 13:43:16 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/libgalera_smm.so'
    130711 13:43:16 [Note] WSREP: wsrep_load(): Galera 2.6(r152) by Codership Oy <info@codership.com> loaded succesfully.
    sh: ip: command not found
    130711 13:43:16 [ERROR] WSREP: Failed to read output of: 'ip addr show | grep -E '^\s*inet' | grep -m1 global | awk '{ print $2 }' | sed 's/\/.*//''
    130711 13:43:16 [Warning] WSREP: Failed to guess base node address. Set it explicitly via wsrep_node_address.
    130711 13:43:16 [Warning] WSREP: Guessing address for incoming client connections failed. Try setting wsrep_node_incoming_address explicitly.
    130711 13:43:16 [Warning] WSREP: Could not open saved state file for reading: /var/lib/mysql//grastate.dat
    130711 13:43:16 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1
    130711 13:43:16 [Note] WSREP: Preallocating 134219048/134219048 bytes in '/var/lib/mysql//galera.cache'...
    130711 13:43:16 [Note] WSREP: Passing config to GCS: base_port = 4567; cert.log_conflicts = no; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 16; gcs.fc_master_slave = NO; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = NO; replicator.causal_read_timeout = PT30S; replicator.commit_order = 3
    130711 13:43:16 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
    130711 13:43:16 [Note] WSREP: wsrep_sst_grab()
    130711 13:43:16 [Note] WSREP: Start replication
    130711 13:43:16 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1
    130711 13:43:16 [Note] WSREP: protonet asio version 0
    130711 13:43:16 [Note] WSREP: backend: asio
    130711 13:43:16 [Note] WSREP: GMCast version 0
    130711 13:43:16 [Note] WSREP: (133a5a59-ea1f-11e2-9843-36ec04bfc440, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
    130711 13:43:16 [Note] WSREP: (133a5a59-ea1f-11e2-9843-36ec04bfc440, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
    130711 13:43:16 [Note] WSREP: EVS version 0
    130711 13:43:16 [Note] WSREP: PC version 0
    130711 13:43:16 [Note] WSREP: gcomm: connecting to group 'xtradb_cluster', peer ''
    130711 13:43:16 [ERROR] WSREP: Permission denied
    130711 13:43:16 [ERROR] WSREP: failed to open gcomm backend connection: 13: error while trying to listen 'tcp://0.0.0.0:4567?socket.non_blocking=1', asio error 'Permission denied': 13 (Permission denied)
         at gcomm/src/asio_tcp.cpp:listen():813
    130711 13:43:16 [ERROR] WSREP: gcs/src/gcs_core.c:gcs_core_open():195: Failed to open backend connection: -13 (Permission denied)
    130711 13:43:16 [ERROR] WSREP: gcs/src/gcs.c:gcs_open():1289: Failed to open channel 'xtradb_cluster' at 'gcomm://': -13 (Permission denied)
    130711 13:43:16 [ERROR] WSREP: gcs connect failed: Permission denied
    130711 13:43:16 [ERROR] WSREP: wsrep::connect() failed: 6
    130711 13:43:16 [ERROR] Aborting
    
    130711 13:43:16 [Note] WSREP: Service disconnected.
    130711 13:43:17 [Note] WSREP: Some threads may fail to exit.
    130711 13:43:17 [Note] /usr/sbin/mysqld: Shutdown complete
    
    130711 13:43:17 mysqld_safe mysqld from pid file /var/lib/mysql/HATSYSAID6.pid ended
    and my.cnf is:
    Code:
    [mysqld]
    wsrep_provider=/usr/lib64/libgalera_smm.so
    wsrep_cluster_address=gcomm://
    wsrep_slave_threads=4
    wsrep_sst_method=xtrabackup
    wsrep_cluster_name=xtradb_cluster
    wsrep_node_name=node1
    binlog_format=ROW
    default_storage_engine=InnoDB
    innodb_autoinc_lock_mode=2
    innodb_locks_unsafe_for_binlog=1
    Installed from percona yum repo. There was known problems with mysql-libs so I had just erased it first with rpm -e --nodeps first
    I really got no idea what's wrong here. Everything was working great with Debian, so any kind of hint is greatly appreciated
    Last edited by Northfear; 07-11-2013, 08:27 AM.

  • #2
    Looks to me like it can't find the node address for replication. Give specifying the address with the 'wsrep_node_address' parameter in the [mysqld] section a try:

    wsrep_node_address = ip.address.of.node

    Cheers!

    Dirk

    Comment


    • #3
      Originally posted by dirkbonenkamp View Post
      Looks to me like it can't find the node address for replication. Give specifying the address with the 'wsrep_node_address' parameter in the [mysqld] section a try:

      wsrep_node_address = ip.address.of.node

      Cheers!

      Dirk
      Hi! I had already tried that. It fixes the
      Code:
      [ERROR] WSREP: Failed to read output of: 'ip addr show
      But unfortuantly doesn't fix that Permission denied error

      Comment


      • #4
        Hmm, strange.. I'm not using RH myself, but did you have a look at the SElinux / apparmor thingies? First thing that comes to mind...

        Comment


        • #5
          Originally posted by dirkbonenkamp View Post
          Hmm, strange.. I'm not using RH myself, but did you have a look at the SElinux / apparmor thingies? First thing that comes to mind...
          Ha..indeed! SElinux was installed and enabled there! RH still feels so different
          Thanks alot for the help

          Comment

          Working...
          X