I have a big problem. Mariadb crashed last night and won't start. I tried removing the database packages through apt-get but now I can't install them again. I get the following error: Code: Preparing to unpack .../mariadb-server-core-10.1_10.1.22+maria-1~jessie_amd64.deb ... Unpacking mariadb-server-core-10.1 (10.1.22+maria-1~jessie) ... Preparing to unpack .../mariadb-server-10.1_10.1.22+maria-1~jessie_amd64.deb ... Failed to stop mysql.service: Unit mysql.service not loaded. invoke-rc.d: initscript mysql, action "stop" failed. invoke-rc.d returned 5 There is a MySQL server running, but we failed in our attempts to stop it. Stop it yourself and try again! dpkg: error processing archive /var/cache/apt/archives/mariadb-server-10.1_10.1.22+maria-1~jessie_amd64.deb (--unpack): subprocess new pre-installation script returned error exit status 1 Selecting previously unselected package mariadb-server. Preparing to unpack .../mariadb-server_10.1.22+maria-1~jessie_all.deb ... Unpacking mariadb-server (10.1.22+maria-1~jessie) ... Processing triggers for man-db (2.7.0.2-5) ... Errors were encountered while processing: /var/cache/apt/archives/mariadb-server-10.1_10.1.22+maria-1~jessie_amd64.deb E: Sub-process /usr/bin/dpkg returned an error code (1)
Check with 'ps aux | grep mysql' if there is still a mysql/mariadb process running and if yes, then stop it.
Maybe this helps: http://askubuntu.com/questions/2864...-or-10-in-ubuntu-12-04-mysqld-failed-to-start But ensure to make a backup of /var/lib/mysql and /etc/mysql before you try that.
Which messages do you get in the syslog or mysql logs? When the innodb files crahsed, then you can set a recovery level in the mysql config file to start it anyay (don't remember the exact name of the settings at the moment).
Till, I can't get hold of Florian right now, but do you know anyone who can take a job to dump all databases, clean everything up and set mysql back to run normally then import everything again?
