Need help reinstallimg mariaB on Debian

Forum for questions and support relating to the 1.32.x releases only.
Post Reply
SkippyDo
Posts: 219
Joined: Mon Nov 20, 2017 6:49 pm

Need help reinstallimg mariaB on Debian

Post by SkippyDo »

Recently encountered a corrupted database (thread is here:viewtopic.php?f=38&t=27934). I reflexively sought to install any updates in case I might have run across a bug. That now appears to have been a huge mistake as I now have a messed up/incomplete install of mariaDB and am unable to get it to install.

I had used the installation instructions appended to the 1.30.4 installation wiki. Everything had been working very well for some time and I had not made any changes prior to the DB corruption.

Output from 'lsb release -a':
No LSB modules are available.
Distributor ID: Debian
Description: Debian GNU/Linux buster/sid
Release: stable-updates
Codename: sid
'apt-get install mariadb-server' (after doing an update) produced/produces:
Setting up mariadb-server-10.3 (1:10.3.12-1) ...
/var/lib/dpkg/info/mariadb-server-10.3.postinst: line 24: 4669 Done echo "$password_column_fix_query"
4670 Aborted | $MYSQL_BOOTSTRAP 2>&1
4671 | $ERR_LOGGER
dpkg: error processing package mariadb-server-10.3 (--configure):
installed mariadb-server-10.3 package post-installation script subprocess returned error exit status 134
Errors were encountered while processing:
mariadb-server-10.3
E: Sub-process /usr/bin/dpkg returned an error code (1)
I purged all mysql packages that I can tell and was still unable to get mariadb-server to reinstall.

Output from 'sudo dpkg -s mariadb-server-10.3' produced what looks like clues, but I am unable to figure out how I should proceed:
Package: mariadb-server-10.3
Status: install ok half-configured
Priority: optional
Section: database
Installed-Size: 67212
Maintainer: Debian MySQL Maintainers <pkg-mysql-maint@lists.alioth.debian.org>
Architecture: amd64
Source: mariadb-10.3
Version: 1:10.3.12-1
Replaces: mariadb-galera-server, mariadb-galera-server-10.0, mariadb-galera-server-5.5, mariadb-server-10.0, mariadb-server-10.1, mariadb-server-10.2, mariadb-server-5.5, mariadb-tokudb-engine-10.0, mariadb-tokudb-engine-10.1, mariadb-tokudb-engine-5.5, mysql-client-5.5, mysql-server-5.5, mysql-server-5.6, mysql-server-5.7, virtual-mysql-server
Provides: virtual-mysql-server
Depends: galera-3 (>= 25.3), gawk, iproute2, libdbi-perl, lsb-base (>= 3.0-10), lsof, mariadb-client-10.3 (>= 1:10.3.12-1), mariadb-server-core-10.3 (>= 1:10.3.12-1), passwd, perl (>= 5.6), psmisc, rsync, socat, debconf (>= 0.5) | debconf-2.0, libc6 (>= 2.28), libpam0g (>= 0.99.7.1), libssl1.1 (>= 1.1.0), libstdc++6 (>= 5.2), zlib1g (>= 1:1.2.0)
Pre-Depends: adduser (>= 3.40), debconf, mariadb-common (>= 1:10.3.12-1)
Recommends: libhtml-template-perl
Suggests: mailx, mariadb-test, netcat-openbsd, tinyca
Breaks: cqrlog (<< 1.9.0-5~), mariadb-galera-server, mariadb-galera-server-10.0, mariadb-galera-server-5.5, mariadb-server-10.0, mariadb-server-10.1, mariadb-server-10.2, mariadb-server-5.5, mariadb-tokudb-engine-10.0, mariadb-tokudb-engine-10.1, mariadb-tokudb-engine-5.5, mysql-client-5.5, mysql-server-5.5, mysql-server-5.6, mysql-server-5.7
Conflicts: mariadb-tokudb-engine-10.0, mariadb-tokudb-engine-10.1, mariadb-tokudb-engine-5.5, mysql-server-core-5.5, mysql-server-core-5.6, mysql-server-core-5.7, virtual-mysql-server
Conffiles:
/etc/apparmor.d/usr.sbin.mysqld 5b43a33a4995f3532bcea02d9c2c87c1
/etc/default/mysql 64e6d248978c07392628278d0be66888
/etc/init.d/mysql 52a3f49226c798a20e6e12e27e26381e
/etc/insserv.conf.d/mariadb 2588bf6ebd0da2f146befac246610658
/etc/logcheck/ignore.d.paranoid/mariadb-server-10_3 6babe46e791059cdd5a26f4f7fec9eca
/etc/logcheck/ignore.d.server/mariadb-server-10_3 a5b52544898b1d96ce64f96ec913ee65
/etc/logcheck/ignore.d.workstation/mariadb-server-10_3 a9766f2dd21ba5e5474526b9df4a82a7
/etc/logrotate.d/mysql-server 3b27c6ac3dbfe31c1c1db0f880b3a2f4
/etc/mysql/debian-start 8b54d37e689f0a3c54063930d931b8d6
/etc/mysql/mariadb.conf.d/50-mysqld_safe.cnf ace3390ea785e7bb3e87bee2ef0f9da8
/etc/mysql/mariadb.conf.d/50-server.cnf d9fb522444d1f9e27ea8ce366e592cdc
Description: MariaDB database server binaries
MariaDB is a fast, stable and true multi-user, multi-threaded SQL database
server. SQL (Structured Query Language) is the most popular database query
language in the world. The main goals of MariaDB are speed, robustness and
ease of use.
.
This package includes the server binaries.
Homepage: https://mariadb.org/
I have database backups and really only care about getting back configurations.

Thanks for any help (I realize that this isn't a ZM issue but don't know where else to turn to to get help- seems that this just keeps pulling me further down the rabbit hole).
SkippyDo
Posts: 219
Joined: Mon Nov 20, 2017 6:49 pm

Re: Need help reinstallimg mariaB on Debian

Post by SkippyDo »

I've flushed everything and am still unable to install mariaDB!

What is the newest viable release of mariaDB that is supposed to work with ZM 1.32?
lbm
Posts: 87
Joined: Mon Mar 26, 2018 7:44 pm

Re: Need help reinstallimg mariaB on Debian

Post by lbm »

Sounds like an debian issue, rather than an ZM issue ? Have you tried the debian forum ?
Anyway..

It seems like you are running unstable, why is this ? Is this deliberate ? You could try to install mariadb from testing to see if this solves the issue. But please be aware that mixing versions is often not an very good idea, since you could run in to dependency hells quite easily.

Can you you post your /etc/apt/source.list and cat /etc/debian_version ?
SkippyDo
Posts: 219
Joined: Mon Nov 20, 2017 6:49 pm

Re: Need help reinstallimg mariaB on Debian

Post by SkippyDo »

Wow, a blast from the past!

I bailed on ZM 1.32.3 and Debian Sid as it proved too unstable: back to running ZM 1.30.4 on Debian Stretch. I did, however, get things working, though kept getting database crashes; so, this combination, IMO, is not ready for prime time (and I would discourage others from trying it, unless they're bored and don't need a reliable setup).
bbunge
Posts: 2930
Joined: Mon Mar 26, 2012 11:40 am
Location: Pennsylvania

Re: Need help reinstallimg mariaB on Debian

Post by bbunge »

SkippyDo wrote: Thu Feb 21, 2019 3:36 am Wow, a blast from the past!

I bailed on ZM 1.32.3 and Debian Sid as it proved too unstable: back to running ZM 1.30.4 on Debian Stretch. I did, however, get things working, though kept getting database crashes; so, this combination, IMO, is not ready for prime time (and I would discourage others from trying it, unless they're bored and don't need a reliable setup).
Debian Sid is still in "unstable" state so you can expect issues.

As for Debian 9 with Mariadb and ZM 1.30,4... as stable as Ubuntu 16.04 or 18.04 with ZM 1.30.4! In fact I've been running a Pi 3B+ Raspberian with ZM 1.30.4 and Mariadb for some time with no issues. My Ubuntu 18.04 ZM 1.30.4 also uses Mariadb with no issues in fact runs better than MySQL IMHO.

If you are having database issues you should run mysqltuner and see where you need to add or change resources. SQL databases can eat up a lot of RAM and will, in time, require an increase in innodb_buffer_pool_size.
SkippyDo
Posts: 219
Joined: Mon Nov 20, 2017 6:49 pm

Re: Need help reinstallimg mariaB on Debian

Post by SkippyDo »

Yes, exactly, Debian Sid is unstable, in which case I decided to not spend a lot of time trying to do anything more with the database. For all I know there are/were underlying system libraries that were causing conflicts. I have plenty of system resources (I WAY over-spec'd my hardware), so probably not that. Was just seeing DB corruptions.

This is pretty much all I'm able to comment on this subject. Just figure it as an anecdotal warning to anyone else who may look to venture down the same path. I am, nonetheless, impressed with the new stuff in ZM; I'll just have to wait for the next stable version of Debian to enjoy them.
Post Reply