Galera cluster not starting after shutting down

46 views
Skip to first unread message

Anjum Sayed

unread,
Dec 27, 2022, 3:10:19 AM12/27/22
to codership
When i issue the command 
systemctl status mariadb      I get the following output.
mariadb.service - MariaDB 10.3.37 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: timeout) since Tue 2022-12-27 12:52:08 IST; 31min ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 4580 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
  Process: 4500 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
  Process: 4496 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 4580 (code=exited, status=1/FAILURE)
   Status: "MariaDB server is down"
    Tasks: 7
   CGroup: /system.slice/mariadb.service
           └─1540 /usr/sbin/mysqld --wsrep_start_position=1f7f3dcc-7d29-11ed-af53-420cf858bc48:24

Dec 27 13:22:26 gd0b1 systemd[1]: Got notification message from PID 1540, but reception only permitted for main PID which is currently not known
Dec 27 13:22:33 gd0b1 mysqld[1540]: 2022-12-27 13:22:33 0 [Note] WSREP: (e12af6b3, 'tcp://0.0.0.0:4567') reconnecting to 745bb035 (tcp://192.168.122.2:4567), attempt 4500
Dec 27 13:22:36 gd0b1 systemd[1]: Got notification message from PID 1540, but reception only permitted for main PID which is currently not known
Dec 27 13:22:46 gd0b1 systemd[1]: Got notification message from PID 1540, but reception only permitted for main PID which is currently not known
Dec 27 13:22:56 gd0b1 systemd[1]: Got notification message from PID 1540, but reception only permitted for main PID which is currently not known
Dec 27 13:23:06 gd0b1 systemd[1]: Got notification message from PID 1540, but reception only permitted for main PID which is currently not known
Dec 27 13:23:11 gd0b1 mysqld[1540]: 2022-12-27 13:23:11 0 [Note] WSREP: (e12af6b3, 'tcp://0.0.0.0:4567') reconnecting to 745bb035 (tcp://192.168.122.2:4567), attempt 4530
Dec 27 13:23:16 gd0b1 systemd[1]: Got notification message from PID 1540, but reception only permitted for main PID which is currently not known
Dec 27 13:23:26 gd0b1 systemd[1]: Got notification message from PID 1540, but reception only permitted for main PID which is currently not known
Dec 27 13:23:36 gd0b1 systemd[1]: Got notification message from PID 1540, but reception only permitted for main PID which is currently not known

Regards.
Syed 
Reply all
Reply to author
Forward
0 new messages