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