Uploaded image for project: 'Percona XtraDB Cluster'
  1. Percona XtraDB Cluster
  2. PXC-1979

LP #1691905: XtraDB CLuster can not start after restart server

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Incomplete
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      **Reported in Launchpad by duc last update 29-07-2017 04:17:34

      OS: CentOS 7.x 64 bit, After restart servers I can not start XtraDB Cluster:
      [root@iti-vn-82-vm ~]# sestatus
      SELinux status: disabled
      [root@iti-vn-82-vm ~]# systemctl status firewalld
      firewalld.service - firewalld - dynamic firewall daemon
      Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
      Active: inactive (dead)
      Docs: man:firewalld(1)

      [root@iti ~]# systemctl start mysql@bootstrap
      Job for mysql@bootstrap.service failed because the control process exited with error code. See "systemctl status mysql@bootstrap.service" and "journalctl -xe" for details.
      [root@iti-vn-82-vm ~]# systemctl status mysql@bootstrap -1
      systemctl: invalid option – '1'
      [root@iti ~]# systemctl status mysql@bootstrap -l
      mysql@bootstrap.service - Percona XtraDB Cluster with config /etc/sysconfig/mysql.bootstrap
      Loaded: loaded (/usr/lib/systemd/system/mysql@.service; disabled; vendor preset: disabled)
      Active: failed (Result: exit-code) since Thu 2017-05-18 11:21:10 ICT; 21h ago
      Process: 17111 ExecStopPost=/usr/bin/mysql-systemd stop-post (code=exited, status=0/SUCCESS)
      Process: 17069 ExecStop=/usr/bin/mysql-systemd stop (code=exited, status=2)
      Process: 16913 ExecStartPost=/usr/bin/mysql-systemd start-post $MAINPID (code=exited, status=1/FAILURE)
      Process: 16912 ExecStart=/usr/bin/mysqld_safe --basedir=/usr ${EXTRA_ARGS} (code=exited, status=0/SUCCESS)
      Process: 16852 ExecStartPre=/usr/bin/mysql-systemd start-pre (code=exited, status=0/SUCCESS)
      Main PID: 16912 (code=exited, status=0/SUCCESS)

      May 18 11:21:10 iti-vn-82-vm mysql-systemd[17111]: Fatal error in defaults handling. Program aborted
      May 18 11:21:10 iti-vn-82-vm mysql-systemd[17111]: [93B blob data]
      May 18 11:21:10 iti-vn-82-vm mysql-systemd[17111]: Fatal error in defaults handling. Program aborted
      May 18 11:21:10 iti-vn-82-vm mysql-systemd[17111]: [93B blob data]
      May 18 11:21:10 iti-vn-82-vm mysql-systemd[17111]: Fatal error in defaults handling. Program aborted
      May 18 11:21:10 iti-vn-82-vm mysql-systemd[17111]: WARNING: mysql pid file /var/lib/mysql/iti-vn-82-vm.pid empty or not readable
      May 18 11:21:10 iti-vn-82-vm mysql-systemd[17111]: WARNING: mysql may be already dead
      May 18 11:21:10 iti-vn-82-vm systemd[1]: Failed to start Percona XtraDB Cluster with config /etc/sysconfig/mysql.bootstrap.
      May 18 11:21:10 iti-vn-82-vm systemd[1]: Unit mysql@bootstrap.service entered failed state.
      May 18 11:21:10 iti-vn-82-vm systemd[1]: mysql@bootstrap.service failed.

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              krunal.bauskar Krunal Bauskar (Inactive)
              Reporter:
              lpjirasync lpjirasync (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated: