Can't Install MariaDB - Dependency Error?

Question

I'm running Ubuntu 14.04 on a Digital Ocean VM. I'm trying to install MariaDB 10.1. When doing so, I get the following error:

Setting up mariadb-server-10.1 (10.1.8+maria-1~trusty) ...
dpkg: error processing package mariadb-server-10.1 (--configure):
 subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mariadb-server:
 mariadb-server depends on mariadb-server-10.1 (= 10.1.8+maria-1~trusty); however:
  Package mariadb-server-10.1 is not configured yet.

dpkg: error processing package mariadb-server (--configure):
 dependency problems - leaving unconfigured
No apport report written because the error message indicates its a followup error from a previous failure.
     Errors were encountered while processing:
 mariadb-server-10.1
 mariadb-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

Here is what I've tried to fix this:

sudo apt-get remove --purge mysql-server mysql-client mysql-common
sudo apt-get autoremove
sudo apt-get autoclean
sudo apt-get install mariadb-server

AND

restarting the machine

I was searching Stack Exchange and other Linux forms for a while and I cannot figure out what is causing this. I appreciate any help that could be offered!

UPDATE: Here is the output of apt-get install -f:

Reading package lists... Done
Building dependency tree
Reading state information... Done
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
2 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Setting up mariadb-server-10.1 (10.1.8+maria-1~trusty) ...
dpkg: error processing package mariadb-server-10.1 (--configure):
 subprocess installed post-installation script returned error exit status 1
No apport report written because the error message indicates its a followup error from a previous failure.
                                                                                                          dpkg: dependency problems prevent configuration of mariadb-server:
 mariadb-server depends on mariadb-server-10.1 (= 10.1.8+maria-1~trusty); however:
  Package mariadb-server-10.1 is not configured yet.

dpkg: error processing package mariadb-server (--configure):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 mariadb-server-10.1
 mariadb-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

@MichaelHampton I pasted the info in the updated question. I looked at the output before, it's not very useful. — Zach Russell, Nov 15 '15 at 15:14
Why is this question still here on serverfault or not closed? — Rob, Sep 17 '17 at 21:10

score 4 · Answer 1 · answered Sep 17 '17 at 20:59

4

Found this in log:

[ERROR] /usr/sbin/mysqld: unknown variable log_slow_queries=/var/log/mysql/mysql-slow.log'

So I commented out conf.d/local.cnf

#log_slow_queries=/var/log/mysql/mysql-slow.log'

And installation finally ends succesfully.

answered Sep 17 '17 at 20:59

SledgehammerPL

711
9
16

Thanks a lot, this was exactly it, preventing me to upgrade from jessie to stretch – xXx Jan 30 '18 at 16:33
also was a reason for me. – Константин Рекунов Feb 22 '18 at 00:27
where is the log file? – Delcasda Dec 08 '20 at 17:52

score 2 · Answer 2 · answered Jan 05 '17 at 19:04

2

Try backing up all files in /var/lib/mysql somewhere. Delete them all and then execute mysql_install_db.

My problem came from removing mysqld and replacing it with mariadb and trying to keep the database files. All other methods failed for me.

answered Jan 05 '17 at 19:04

Stéphan Champagne

171
1
3

score 1 · Answer 3 · answered Nov 15 '15 at 17:50

Your system has problems running the (post)configure script of the mariadb-server-10.1 package.

First, try to clean the apt cache using apt-get clean and to reinstall the package (please note apt-get autoclean only partially clean the cache).

If that fails, you had to use dpkg -i mariadb-server-10.1 and/or dpkg-reconfigure mariadb-server-10.1 to give a more in-depth looking at the specific error.

score 1 · Answer 4 · answered Aug 10 '16 at 12:33

sudo shutdown -r now

I know it sounds crazy that rebooting the machine solved the problem on linux, but I doublechecked. However I'm working in my Vagrant machine, not sure for Digital Ocean.

System:

Debian 7,
mysql installed from dotdeb with a working database,
updated MariaDB apt sources and key added,
install mariadb-server-10.1 which ended with the same error.

After rebooting everything worked, including the DB now served by MariaDB.

score 0 · Answer 5 · edited Jul 29 '20 at 07:18

0

Refer link below: https://unix.stackexchange.com/questions/249530/mariadb-dependency-problems-leaving-unconfigured

Main> Install everything from fresh: Add the following to your /etc/apt/sources.list file:

deb [arch=amd64,i386] http://ftp.utexas.edu/mariadb/repo/10.1/debian jessie main
deb-src http://ftp.utexas.edu/mariadb/repo/10.1/debian jessie main

edited Jul 29 '20 at 07:18

Stuggi

3,366
4
17
34

answered Jul 29 '20 at 01:20

Guy Chic

1

Can't Install MariaDB - Dependency Error?

5 Answers5