Hello @all,
I'm new to Zabbix. Actually we are faced with an Alert tthat reports "mysqld instance down" on the Zabbix DB Server.
We are using "zabbix_server (Zabbix) 3.4.14".
I've although checked the status of the mysql service. It reports that the service is active:
Does anyone have an Idea, why we are getting the alert E-Mail?
Kind Regards,
Dennis
I'm new to Zabbix. Actually we are faced with an Alert tthat reports "mysqld instance down" on the Zabbix DB Server.
We are using "zabbix_server (Zabbix) 3.4.14".
I've although checked the status of the mysql service. It reports that the service is active:
● mariadb.service - MariaDB 10.1.34 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Active: active (running) since Fri 2018-09-14 11:35:47 CEST; 3h 37min ago
Docs: man:mysqld(8)
Process: 1872 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 1867 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
Process: 1418 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$V
Process: 1284 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 970 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Main PID: 1648 (mysqld)
Status: "Taking your SQL requests now..."
Tasks: 172 (limit: 9830)
CGroup: /system.slice/mariadb.service
└─1648 /usr/sbin/mysqld
Sep 14 11:35:39 icwtlapp005 systemd[1]: Starting MariaDB 10.1.34 database server...
Sep 14 11:35:41 icwtlapp005 mysqld[1648]: 2018-09-14 11:35:41 140675260787840 [Note] /usr/sbin/mysqld (mysqld 10.1.34-MariaDB-0ubuntu0.18.04.1) starting as process 1648 ...
Sep 14 11:35:47 icwtlapp005 /etc/mysql/debian-start[1875]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
Sep 14 11:35:47 icwtlapp005 /etc/mysql/debian-start[1875]: Looking for 'mysql' as: /usr/bin/mysql
Sep 14 11:35:47 icwtlapp005 /etc/mysql/debian-start[1875]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Sep 14 11:35:47 icwtlapp005 /etc/mysql/debian-start[1875]: This installation of MySQL is already upgraded to 10.1.34-MariaDB, use --force if you still need to run mysql_upgrade
Sep 14 11:35:47 icwtlapp005 systemd[1]: Started MariaDB 10.1.34 database server.
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Active: active (running) since Fri 2018-09-14 11:35:47 CEST; 3h 37min ago
Docs: man:mysqld(8)
Process: 1872 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 1867 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
Process: 1418 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$V
Process: 1284 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 970 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Main PID: 1648 (mysqld)
Status: "Taking your SQL requests now..."
Tasks: 172 (limit: 9830)
CGroup: /system.slice/mariadb.service
└─1648 /usr/sbin/mysqld
Sep 14 11:35:39 icwtlapp005 systemd[1]: Starting MariaDB 10.1.34 database server...
Sep 14 11:35:41 icwtlapp005 mysqld[1648]: 2018-09-14 11:35:41 140675260787840 [Note] /usr/sbin/mysqld (mysqld 10.1.34-MariaDB-0ubuntu0.18.04.1) starting as process 1648 ...
Sep 14 11:35:47 icwtlapp005 /etc/mysql/debian-start[1875]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
Sep 14 11:35:47 icwtlapp005 /etc/mysql/debian-start[1875]: Looking for 'mysql' as: /usr/bin/mysql
Sep 14 11:35:47 icwtlapp005 /etc/mysql/debian-start[1875]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Sep 14 11:35:47 icwtlapp005 /etc/mysql/debian-start[1875]: This installation of MySQL is already upgraded to 10.1.34-MariaDB, use --force if you still need to run mysql_upgrade
Sep 14 11:35:47 icwtlapp005 systemd[1]: Started MariaDB 10.1.34 database server.
Does anyone have an Idea, why we are getting the alert E-Mail?
Kind Regards,
Dennis
Comment