Announcement

Announcement Module
Collapse
No announcement yet.

Problem when Startting the mysql Service the error i mention below

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

  • Problem when Startting the mysql Service the error i mention below

    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"
    ~
    ~
    Last edited by watanesachin; 01-01-2014, 04:55 AM. Reason: 140101 21:38:24 [ERROR] WSREP: gcs/src/gcs_core.c:gcs_core_open():196: Failed to open backend connection: -13 (Permission denied) 140101 21:38:24 [ERROR] WSREP: gcs/src/gcs.c:gcs_open():1292: Failed t

  • #2
    watanesachin please send error log

    Comment


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

      http://www.percona.com/doc/percona-x...does-not-start
      echo 0 > /selinux/enforce

      Comment


      • #4
        If you're trying to create a new cluster then please follow this URL and check configuration files:
        http://www.percona.com/doc/percona-x...ntu_howto.html

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

        And check error logs if any error appeared.

        Comment


        • #5
          Sachin,

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

          Comment


          • #6
            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.

            Comment


            • #7
              try this solution..

              http://stackoverflow.com/questions/1...large-sql-file

              Comment


              • #8
                Code:
                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:
                Code:
                [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

                Comment


                • #9
                  I'm not an expert of this But you read more here about this: http://www.percona.com/forums/questi...=9685#post9685 I would suggest you to create a separate topic for questions like thi one, just to avoid a mess...

                  Comment

                  Working...
                  X