Recently upgraded from 2.x to 4.x (fresh install).
Installed the all the various plugins including mysql.
recreated my databases.
All working great.
When the server is powered and restarted the following day, the Dashboard shows the mysql service is NOT running (see attached) :
It is enabled as shown on the mysql page :
If I run "systemctl status mysql" it shows a problem:
Code
root@OMV:~# systemctl status mysql
● mysql.service - LSB: Start and stop the mysql database server daemon
Loaded: loaded (/etc/init.d/mysql; generated; vendor preset: enabled)
Active: failed (Result: exit-code) since Wed 2019-02-06 11:45:44 GMT; 1h 57min ago
Docs: man:systemd-sysv-generator(8)
CGroup: /system.slice/mysql.service
├─1111 /bin/bash /usr/bin/mysqld_safe
├─1315 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/x86_64-linux-gnu/mariadb18/plugin --user=mysql
--skip-log-error --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
└─1316 logger -t mysqld -p daemon error
Feb 06 11:45:44 OMV systemd[1]: mysql.service: Unit entered failed state.
Feb 06 11:45:44 OMV systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 06 11:46:05 OMV mysqld[1316]: 2019-02-06 11:46:05 139648118698432 [Note] InnoDB: 128 rollback segment(s) are active.
Feb 06 11:46:05 OMV mysqld[1316]: 2019-02-06 11:46:05 139648118698432 [Note] InnoDB: Waiting for purge to start
Feb 06 11:46:05 OMV mysqld[1316]: 2019-02-06 11:46:05 139648118698432 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.41-84
.1 started; log sequence number 9730359
Feb 06 11:46:07 OMV mysqld[1316]: 2019-02-06 11:46:07 139647556511488 [Note] InnoDB: Dumping buffer pool(s) not yet started
Feb 06 11:46:07 OMV mysqld[1316]: 2019-02-06 11:46:07 139648118698432 [Note] Plugin 'FEEDBACK' is disabled.
Feb 06 11:46:08 OMV mysqld[1316]: 2019-02-06 11:46:08 139648118698432 [Note] Server socket created on IP: '192.168.15.200'.
Feb 06 11:46:12 OMV mysqld[1316]: 2019-02-06 11:46:12 139648118698432 [Note] /usr/sbin/mysqld: ready for connections.
Feb 06 11:46:12 OMV mysqld[1316]: Version: '10.1.37-MariaDB-0+deb9u1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Debian 9.6
root@OMV:~#
Alles anzeigen
When I disable the service (and apply changes), I get:
Then, I re-enable the service (again I get the same "An error occured" popup) and run the status command:
Code
root@OMV:~# systemctl status mysql
● mysql.service - LSB: Start and stop the mysql database server daemon
Loaded: loaded (/etc/init.d/mysql; generated; vendor preset: enabled)
Active: active (running) since Wed 2019-02-06 14:09:38 GMT; 14s ago
Docs: man:systemd-sysv-generator(8)
Process: 13933 ExecStart=/etc/init.d/mysql start (code=exited, status=0/SUCCESS)
Tasks: 29 (limit: 4915)
CGroup: /system.slice/mysql.service
├─1111 /bin/bash /usr/bin/mysqld_safe
├─1315 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/x86_64-linux-gnu/mariadb18/plugin --user=mysql
--skip-log-error --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
└─1316 logger -t mysqld -p daemon error
Feb 06 14:09:37 OMV systemd[1]: Starting LSB: Start and stop the mysql database server daemon...
Feb 06 14:09:38 OMV mysql[13933]: Starting MariaDB database server: mysqld already running.
Feb 06 14:09:38 OMV systemd[1]: Started LSB: Start and stop the mysql database server daemon.
root@OMV:~#
Alles anzeigen
And everything seems to work.
It seems the mysql server was already running but the OMV dashboard GUI was mis-reporting as not-running.
Any idea what's wrong and how to solve it ?