Hi,
OMV4 on Odriod xu4, MySQL installed one year ago, without any issues until today.
Today after reboot MySQL can't be acessed by the clients and also can't be enabled in the Web Gui.
'Apply' leads to the error:
Failed to execute command 'export PATH=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin; export LANG=C.UTF-8; systemctl start 'mysql.service' 2>&1' with exit code '1': Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
On the command line:
output of systemctl start mysql.service
Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.
Output of systemctl status mysql.service
● 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 Fri 2020-01-17 01:00:57 CET; 1min 20s ago
Docs: man:systemd-sysv-generator(8)
Process: 6073 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)
Jan 17 01:00:27 xu4 mysqld[6501]: 2020-01-17 1:00:27 3064195888 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGI
Jan 17 01:00:27 xu4 mysqld[6501]: 2020-01-17 1:00:27 3064195888 [Note] Plugin 'FEEDBACK' is disabled.
Jan 17 01:00:27 xu4 mysqld[6501]: 2020-01-17 1:00:27 3064195888 [ERROR] Unknown/unsupported storage engine: InnoDB
Jan 17 01:00:27 xu4 mysqld[6501]: 2020-01-17 1:00:27 3064195888 [ERROR] Aborting
Jan 17 01:00:27 xu4 mysqld[6501]:
Jan 17 01:00:57 xu4 mysql[6073]: Starting MariaDB database server: mysqld . . . . . . . . . . . . . . . . . . . . . . .
Jan 17 01:00:57 xu4 systemd[1]: mysql.service: Control process exited, code=exited status=1
Jan 17 01:00:57 xu4 systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon.
Jan 17 01:00:57 xu4 systemd[1]: mysql.service: Unit entered failed state.
Jan 17 01:00:57 xu4 systemd[1]: mysql.service: Failed with result 'exit-code'.
Output of journalctl -xe
--
-- Unit mysql.service has begun starting up.
Jan 17 01:03:14 xu4 mysqld_safe[12699]: Starting mysqld daemon with databases from /sharedfolders/xchange/mysql
Jan 17 01:03:14 xu4 mysqld[12713]: 2020-01-17 1:03:14 3063782192 [Note] /usr/sbin/mysqld (mysqld 10.1.41-MariaDB-0+deb9u1) starting as process 12712 ...
Jan 17 01:03:14 xu4 mysqld[12713]: 2020-01-17 1:03:14 3063782192 [ERROR] mysqld: File '/sharedfolders/xchange/mysql/aria_log_control' not found (Errcode: 13 "Permission den
Jan 17 01:03:14 xu4 mysqld[12713]: 2020-01-17 1:03:14 3063782192 [ERROR] mysqld: Got error 'Can't open file' when trying to use aria control file '/sharedfolders/xchange/my
Jan 17 01:03:14 xu4 mysqld[12713]: 2020-01-17 1:03:14 3063782192 [ERROR] Plugin 'Aria' init function returned error.
Jan 17 01:03:14 xu4 mysqld[12713]: 2020-01-17 1:03:14 3063782192 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
Jan 17 01:03:14 xu4 mysqld[12713]: 2020-01-17 1:03:14 3063782192 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool siz
Jan 17 01:03:14 xu4 mysqld[12713]:
Jan 17 01:03:14 xu4 mysqld[12713]: 2020-01-17 1:03:14 3063782192 [Note] InnoDB: Using mutexes to ref count buffer pool pages
Jan 17 01:03:14 xu4 mysqld[12713]: 2020-01-17 1:03:14 3063782192 [Note] InnoDB: The InnoDB memory heap is disabled
Jan 17 01:03:14 xu4 mysqld[12713]: 2020-01-17 1:03:14 3063782192 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Jan 17 01:03:14 xu4 mysqld[12713]: 2020-01-17 1:03:14 3063782192 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
Jan 17 01:03:14 xu4 mysqld[12713]: 2020-01-17 1:03:14 3063782192 [Note] InnoDB: Compressed tables use zlib 1.2.8
Jan 17 01:03:14 xu4 mysqld[12713]: 2020-01-17 1:03:14 3063782192 [Note] InnoDB: Using Linux native AIO
Jan 17 01:03:14 xu4 mysqld[12713]: 2020-01-17 1:03:14 3063782192 [Note] InnoDB: Using generic crc32 instructions
Jan 17 01:03:14 xu4 mysqld[12713]: 2020-01-17 1:03:14 3063782192 [Note] InnoDB: Initializing buffer pool, size = 128.0M
Jan 17 01:03:14 xu4 mysqld[12713]: 2020-01-17 1:03:14 3063782192 [Note] InnoDB: Completed initialization of buffer pool
Jan 17 01:03:14 xu4 mysqld[12713]: 2020-01-17 1:03:14 3063782192 [ERROR] InnoDB: ./ibdata1 can't be opened in read-write mode
Jan 17 01:03:14 xu4 mysqld[12713]: 2020-01-17 1:03:14 3063782192 [ERROR] InnoDB: The system tablespace must be writable!
Jan 17 01:03:14 xu4 mysqld[12713]: 2020-01-17 1:03:14 3063782192 [ERROR] Plugin 'InnoDB' init function returned error.
Jan 17 01:03:14 xu4 mysqld[12713]: 2020-01-17 1:03:14 3063782192 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Jan 17 01:03:14 xu4 mysqld[12713]: 2020-01-17 1:03:14 3063782192 [Note] Plugin 'FEEDBACK' is disabled.
Jan 17 01:03:14 xu4 mysqld[12713]: 2020-01-17 1:03:14 3063782192 [ERROR] Unknown/unsupported storage engine: InnoDB
Jan 17 01:03:14 xu4 mysqld[12713]: 2020-01-17 1:03:14 3063782192 [ERROR] Aborting
Jan 17 01:03:14 xu4 mysqld[12713]:
Jan 17 01:03:14 xu4 mysqld_safe[12819]: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Jan 17 01:03:45 xu4 /etc/init.d/mysql[14102]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jan 17 01:03:45 xu4 /etc/init.d/mysql[14102]: [61B blob data]
Jan 17 01:03:45 xu4 /etc/init.d/mysql[14102]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")'
Jan 17 01:03:45 xu4 /etc/init.d/mysql[14102]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jan 17 01:03:45 xu4 /etc/init.d/mysql[14102]:
Jan 17 01:03:45 xu4 mysql[12502]: Starting MariaDB database server: mysqld . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . failed!
Jan 17 01:03:45 xu4 systemd[1]: mysql.service: Control process exited, code=exited status=1
Jan 17 01:03:45 xu4 systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon.
-- Subject: Unit mysql.service has failed
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- Unit mysql.service has failed.
--
-- The result is failed.
Jan 17 01:03:45 xu4 systemd[1]: mysql.service: Unit entered failed state.
Jan 17 01:03:45 xu4 systemd[1]: mysql.service: Failed with result 'exit-code'.
Jan 17 01:04:01 xu4 CRON[14661]: pam_unix(cron:session): session opened for user root by (uid=0)
Jan 17 01:04:01 xu4 CRON[14662]: (root) CMD (for i in `pgrep "ftpd|nfsiod|smbd|afpd|cnid"` ; do ionice -c1 -p $i ; taskset -c -p 4-7 $i ; done >/dev/null 2>&1)
Jan 17 01:04:01 xu4 CRON[14661]: pam_unix(cron:session): session closed for user root
Folder /var/run/mysqld/ is empty.
What can I do to fix the error.
Thanks