Restarting the mysqld from the GUI does nothing.
Opened an SSH and ran “systemctl start mysqld mariadb” is seems to sayed started for a few minutes, and then stopps.
Everything else seems to work (SOGo, Nextcloud, Zoneminder, Websites…)
I don’t know which logs to look at.
Any help appretiated.
I was able to connect, and the databases are shown.
The mariadb.log show:
190731 19:48:46 mysqld_safe Number of processes running now: 1
190731 19:48:46 mysqld_safe mysqld process hanging, pid 12983 - killed
190731 19:48:46 mysqld_safe mysqld restarted
190731 19:48:46 [Note] /usr/libexec/mysqld (mysqld 5.5.60-MariaDB) starting as process 13373 …
190731 19:48:46 [ERROR] mysqld: Can’t lock aria control file ‘/var/lib/mysql/aria_log_control’ for exclusive use, error: 11. Will retry for 30 seconds
190731 19:48:46 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
190731 19:48:47 InnoDB: The InnoDB memory heap is disabled
190731 19:48:47 InnoDB: Mutexes and rw_locks use GCC atomic builtins
190731 19:48:47 InnoDB: Compressed tables use zlib 1.2.7
190731 19:48:47 InnoDB: Using Linux native AIO
190731 19:48:47 InnoDB: Initializing buffer pool, size = 128.0M
190731 19:48:47 InnoDB: Completed initialization of buffer pool
190731 19:48:47 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
InnoDB: Restoring possible half-written data pages from the doublewrite buffer…
190731 19:48:47 InnoDB: Waiting for the background threads to start
190731 19:48:48 Percona XtraDB (http://www.percona.com) 5.5.59-MariaDB-38.11 started; log sequence number 12097789665
190731 19:48:48 [Note] Plugin ‘FEEDBACK’ is disabled.
190731 19:48:48 [Note] Server socket created on IP: ‘0.0.0.0’.
190731 19:48:48 [ERROR] Cannot open mysql.event
190731 19:48:48 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
190731 19:48:48 [Note] /usr/libexec/mysqld: ready for connections.
Version: ‘5.5.60-MariaDB’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 MariaDB Server