I user three VMs cluster the mariadb, reboot the VMs the cluster mariadb do not restart.

asked 2017-07-04 12:07:53 -0600

liaodalin19903 gravatar image

updated 2017-07-04 21:36:33 -0600

I user three VMs cluster the mariadb, it works fine.

But I reboot the VMs the cluster mariadb do not restart:

[root@controller1 ~]# systemctl status mariadb.service
● mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf
   Active: failed (Result: exit-code) since Wed 2017-07-05 10:33:46 CST; 1min 16s ago
  Process: 2817 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
  Process: 1099 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
  Process: 1088 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 2817 (code=exited, status=1/FAILURE)
   Status: "MariaDB server is down"

Jul 05 10:33:45 controller1 mysqld[2817]: at gcomm/src/pc.cpp:connect():162
Jul 05 10:33:45 controller1 mysqld[2817]: 2017-07-05 10:33:45 140656207608000 [ERROR] WSREP: gcs/src/gcs_core.cpp:gcs_core_open():208: Failed t...imed out)
Jul 05 10:33:45 controller1 mysqld[2817]: 2017-07-05 10:33:45 140656207608000 [ERROR] WSREP: gcs/src/gcs.cpp:gcs_open():1380: Failed to open ch...imed out)
Jul 05 10:33:45 controller1 mysqld[2817]: 2017-07-05 10:33:45 140656207608000 [ERROR] WSREP: gcs connect failed: Connection timed out
Jul 05 10:33:45 controller1 mysqld[2817]: 2017-07-05 10:33:45 140656207608000 [ERROR] WSREP: wsrep::connect(gcomm://10.1.1.120,10.1.1.121,10.1....failed: 7
Jul 05 10:33:45 controller1 mysqld[2817]: 2017-07-05 10:33:45 140656207608000 [ERROR] Aborting
Jul 05 10:33:46 controller1 systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Jul 05 10:33:46 controller1 systemd[1]: Failed to start MariaDB database server.
Jul 05 10:33:46 controller1 systemd[1]: Unit mariadb.service entered failed state.
Jul 05 10:33:46 controller1 systemd[1]: mariadb.service failed.
Hint: Some lines were ellipsized, use -l to show in full.
edit retag flag offensive close merge delete

Comments

Your error is about RabbitMQ, not MariaDB. Is it running at all? E.g.

systemctl status whatever-the-rabbitmq-unit-is-called-on-your-system

There should also be a rabbitmq log file with more info.

Same suggestion for MariaDB.

Bernd Bausch gravatar imageBernd Bausch ( 2017-07-04 14:58:48 -0600 )edit

@BerndBausch I have edited my post, I do not know where I get wrong.

liaodalin19903 gravatar imageliaodalin19903 ( 2017-07-04 21:37:11 -0600 )edit

Your three database copies are out of sync. Try the instructions to restart a Galera cluster.

Bernd Bausch gravatar imageBernd Bausch ( 2017-07-05 00:46:56 -0600 )edit