Buy Percona ServicesBuy Now!

Unable to start mysql service.

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Unable to start mysql service.

    I have followed all the steps from "https://www.percona.com/doc/percona-xtradb-cluster/5.6/installation.html#installation" to install Percona XtraDB on my CentOS6.5 x64bit host. But when tried to start the mysql service it failed with below error,

    ====
    [root@localhost ~]# service mysql status
    Redirecting to /bin/systemctl status mysql.service
    mysql.service - Percona XtraDB Cluster
    Loaded: loaded (/usr/lib/systemd/system/mysql.service; disabled)
    Active: failed (Result: exit-code) since Wed 2015-09-23 22:44:44 EDT; 6min ago
    Process: 3379 ExecStopPost=/usr/bin/mysql-systemd stop-post (code=exited, status=0/SUCCESS)
    Process: 3352 ExecStop=/usr/bin/mysql-systemd stop (code=exited, status=2)
    Process: 2894 ExecStartPost=/usr/bin/mysql-systemd start-post $MAINPID (code=exited, status=1/FAILURE)
    Process: 2893 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=0/SUCCESS)
    Process: 2849 ExecStartPre=/usr/bin/mysql-systemd start-pre (code=exited, status=0/SUCCESS)
    Main PID: 2893 (code=exited, status=0/SUCCESS)
    CGroup: /system.slice/mysql.service

    Sep 23 22:44:44 localhost.localdomain mysql-systemd[2894]: /usr/bin/mysql-systemd: line 134: kill: (2893) - No such process
    Sep 23 22:44:44 localhost.localdomain mysql-systemd[2894]: ERROR! mysqld_safe with PID 2893 has already exited: FAILURE
    Sep 23 22:44:44 localhost.localdomain systemd[1]: mysql.service: control process exited, code=exited status=1
    Sep 23 22:44:44 localhost.localdomain mysql-systemd[3352]: WARNING: mysql pid file /run/mysqld/mysql.pid empty or not readable
    Sep 23 22:44:44 localhost.localdomain mysql-systemd[3352]: ERROR! mysql already dead
    Sep 23 22:44:44 localhost.localdomain systemd[1]: mysql.service: control process exited, code=exited status=2
    Sep 23 22:44:44 localhost.localdomain mysql-systemd[3379]: WARNING: mysql pid file /run/mysqld/mysql.pid empty or not readable
    Sep 23 22:44:44 localhost.localdomain mysql-systemd[3379]: WARNING: mysql may be already dead
    Sep 23 22:44:44 localhost.localdomain systemd[1]: Failed to start Percona XtraDB Cluster.
    Sep 23 22:44:44 localhost.localdomain systemd[1]: Unit mysql.service entered failed state.
    [root@localhost ~]#
    ====

    Here is my my.cnf file,

    ====
    [root@localhost ~]# cat /etc/my.cnf
    # Template my.cnf for PXC
    # Edit to your requirements.

    [mysqld]

    log_bin

    binlog_format = ROW
    innodb_buffer_pool_size = 100M
    innodb_flush_log_at_trx_commit = 0
    innodb_flush_method = O_DIRECT
    innodb_log_files_in_group = 2
    innodb_log_file_size = 20M
    innodb_file_per_table = 1
    default_storage_engine = InnoDB
    datadir = /var/lib/mysql

    wsrep_cluster_address = gcomm://10.1.135.27
    wsrep_provider = /usr/lib64/galera3/libgalera_smm.so

    wsrep_slave_threads = 8
    wsrep_cluster_name = Cluster
    wsrep_node_name = Node1
    wsrep_node_address = 10.1.135.27
    wsrep_sst_method = rsync
    wsrep_sst_auth = "sstuser:s3cret"

    innodb_locks_unsafe_for_binlog = 1
    innodb_autoinc_lock_mode = 2



    [mysqld_safe]
    pid-file = /run/mysqld/mysql.pid
    syslog


    !includedir /etc/my.cnf.d
    ====

    Any idea how can I debug this?

  • #2
    Check the ownership and permissions of the directory the .pid file is being written.

    Also, please sanitize your post. Removing auth info from any posting is a good idea.

    Comment


    • #3
      make chonw -R mysql:mysql on your database directory (/var/lib/mysql)

      then start the server with #service mysql bootstrap-pxc

      Comment

      Working...
      X