Paul, Viktor, thank you very much for reminding me that I obviously missed the most important part, sorry.
Here’s the log: [CET Mar 20 22:14:27] info : ’server' Monit 5.25.3 started [CET Mar 20 22:14:27] error : 'mysqld' process is not running [CET Mar 20 22:14:27] info : 'mysqld' trying to restart [CET Mar 20 22:15:28] error : 'mysqld' process is not running [CET Mar 20 22:15:28] info : 'mysqld' trying to restart [CET Mar 20 22:16:28] error : 'mysqld' process is not running [CET Mar 20 22:16:28] info : 'mysqld' trying to restart [CET Mar 20 22:17:28] error : 'mysqld' process is not running [CET Mar 20 22:17:28] info : 'mysqld' trying to restart [CET Mar 20 22:18:16] info : 'mysqld' unmonitor on user request And pid-file exists with the same permissions as on the other, still mysql servers: ~ # ls -l /run/mysqld/mysqld.pid -rw-rw---- 1 mysql mysql 6 20. Mär 12:53 /run/mysqld/mysqld.pid httpd listing (monitoring temporarily disabled): Parameter Value Name mysqld Pid file /run/mysqld/mysql.pid Status Not monitored Group database Monitoring status Not monitored Monitoring mode active On reboot start Data collected Thu, 21 Mar 2019 08:41:18 Existence If doesn't exist then restart Port If failed [127.0.0.1]:3306 type TCP/IP protocol MYSQL with timeout 5 s for 3 times within 5 cycles then alert CPU usage limit If greater than 7.0% for 2 cycles then alert Thanks again for thinking about it! Tino > Am 20.03.2019 um 22:43 schrieb Paul Theodoropoulos <[email protected]>: > > Hi Tino, > > You didn't provide any details on how specifically it is failing. Does monit > say it's not running, or does monit ignore the status and always thinks it's > running whether it is or not? Is the PID saved in the same subdirectory of > /run/? > > On 3/20/19 14:39, Tino Hendricks wrote: >> Dear list, >> >> I upgraded one (gentoo) server from mysql-5.7.24 to mariadb-10.1.37 and >> since then I’m not able to check it's running. >> >> monit 5.25.3 Config is unchanged: >> check process mysqld with pidfile /run/mysqld/mysql.pid >> group database >> start program = "/etc/init.d/mysql restart" with timeout 30 seconds >> stop program = "/etc/init.d/mysql stop" >> if failed host localhost port 3306 protocol mysql for 3 times within >> 5 cycles then alert >> if cpu > 7% for 2 cycles then alert >> >> >> Port is open: >> ~ # netstat -ln | grep 3306 >> tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN >> >> Process is running: >> ~ # ps aux | grep mysql >> mysql 11281 1.6 0.1 2610924 456172 ? Ssl 12:53 9:25 >> /usr/sbin/mysqld --defaults-file=/etc/mysql/my.cnf >> root 14224 0.0 0.0 11192 968 pts/3 S+ 22:37 0:00 grep >> --colour=auto mysql >> >> I am out of ideas and grateful for a little hint. >> >> Thanks >> >> Tino >> > > -- > Paul Theodoropoulos > > www.anastrophe.com > -- > To unsubscribe: > https://lists.nongnu.org/mailman/listinfo/monit-general -- To unsubscribe: https://lists.nongnu.org/mailman/listinfo/monit-general
