First I am very sorry for my bad English, I use a translator software.
A curious situation happens to me in a small vps, and that is that I have mounted a monitor for the mysql server ..
and what was my surprise after mounting it, that when I stop the server, the monitor does not detect the change of state
looking more closely I notice that mysqld.pid and mysql.sock, are still active ..., my server is inactive but the processes remain the same as it was working
... something weird that has led me to look at the status of mysql
Viewing the status returns this data
- mysql.service - LSB: Start and stop the mysql database server daemonLoaded: loaded (/etc/init.d/mysql)Active: active (running) since Wed 2017-12-20 18:45:15 CET; 24min agoProcess: 1173 ExecStop = / etc / init.d / mysql stop (code = exited, status = 1 / FAILURE)Process: 1197 ExecStart = / etc / init.d / mysql start (code = exited, status = 0 / SUCCESS)CGroup: /system.slice/mysql.service├─ 860 / bin / sh / usr / bin / mysqld_safe└─1501 / usr / sbin / mysqld --basedir = / usr --datadir = / var / lib / mysql --plugin-dir = / usr / lib / mysql / plugin --user = mysql --log-error = /var/log/mysql/error.log --pid-file = / var / run / mysqld / mysqld ....Dec 20 18:45:15 relay3 systemd : mysql.service: control process exited, code = exited status = 1Dec 20 18:45:15 relay3 systemd : Unit mysql.service entered failed state.Dec 20 18:45:15 relay3 systemd : Starting LSB: Start and stop the mysql database server daemon ...Dec 20 18:45:15 relay3 mysql : Starting MySQL database server: mysqld already running.Dec 20 18:45:15 relay3 systemd : Started LSB: Start and stop the mysql database server daemon.
The server gives an error, in the stopping sequence
It is a process that does not exist,
Some of you have had or know why you can produce this situation, because I have googled a lot and I do not see an error in memory, in the databases and the truth ... I do not know what can be a reason for this
Working with mysql server 5.5
Panel ver. 1.5.1