[debian-mysql] Bug#926231: mariadb-server-10.3: dpkg configure error - upgrade from mysql

[Graham Cobb]

Package: mariadb-server-10.3
Version: 1:10.3.13-2
Followup-For: Bug #926231

I'm not sure what the "MariaDB error log" is but I have found the following entries in syslog:

Apr  3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: 
Apr  3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: Installation of system tables failed!  Examine the logs in
Apr  3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: /var/lib/mysql for more information.
Apr  3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: 
Apr  3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: The problem could be conflicting information in an external
Apr  3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: my.cnf files. You can ignore these by doing:
Apr  3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: 
Apr  3 20:31:00 novatech mariadb-server-10.3.postinst[8418]:     shell> /usr/bin/mysql_install_db --defaults-file=~/.my.cnf
Apr  3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: 
Apr  3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: You can also try to start the mysqld daemon with:
Apr  3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: 
Apr  3 20:31:00 novatech mariadb-server-10.3.postinst[8418]:     shell> /usr/sbin/mysqld --skip-grant-tables --general-log &
Apr  3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: 
Apr  3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: and use the command line tool /usr/bin/mysql
Apr  3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: to connect to the mysql database and look at the grant tables:
Apr  3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: 
Apr  3 20:31:00 novatech mariadb-server-10.3.postinst[8418]:     shell> /usr/bin/mysql -u root mysql
Apr  3 20:31:00 novatech mariadb-server-10.3.postinst[8418]:     mysql> show tables;
Apr  3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: 
Apr  3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: Try 'mysqld --help' if you have problems with paths.  Using
Apr  3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: --general-log gives you a log in /var/lib/mysql that may be helpful.
Apr  3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: 
Apr  3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: The latest information about mysql_install_db is available at
Apr  3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
Apr  3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: You can find the latest source at https://downloads.mariadb.org and
Apr  3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: the maria-discuss email list at https://launchpad.net/~maria-discuss
Apr  3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: 
Apr  3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: Please check all of the above before submitting a bug report
Apr  3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: at http://mariadb.org/jira
Apr  3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: 
Apr  3 20:31:00 novatech mariadb-server-10.3.postinst[8489]: 2019-04-03 20:31:00 0 [Note] /usr/sbin/mysqld (mysqld 10.3.13-MariaDB-2) starting as p

Reading those entries, I tried the following:

1) Looked for logs in /var/lib/mysql. I couldn't find anything that looked like an error log.

2) I tried starting the mysqld daemon but it exited after a couple of seconds.
It did write a log file in /var/lib/mysql containing:

/usr/sbin/mysqld, Version: 10.3.13-MariaDB-2-log (Debian buildd-unstable). started with:
Tcp port: 0  Unix socket: /run/mysqld/mysqld.sock
Time                Id Command  Argument

3) I searched for my.cnf files and found only:
/etc/mysql/my.cnf.fallback
/etc/mysql/my.cnf
/etc/alternatives/my.cnf (softlink to /etc/mysql/mariadb.cnf)

4) I notice that /etc/alternatives/my.cnf imports files from /etc/mysql/conf.d/ and /etc/mysql/mariadb.conf.d/

Those directories contain...

/etc/mysql/conf.d/
  mysql.cnf  mysqld_safe_syslog.cnf  mysqldump.cnf

/etc/mysql/mariadb.conf.d/
  50-client.cnf  50-mysql-clients.cnf  50-mysqld_safe.cnf  50-server.cnf


-- System Information:
Debian Release: buster/sid
  APT prefers testing
  APT policy: (900, 'testing')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 4.19.0-2-amd64 (SMP w/8 CPU cores)
Locale: LANG=en_IE.utf8, LC_CTYPE=en_IE.utf8 (charmap=UTF-8) (ignored: LC_ALL set to en_IE.utf8), LANGUAGE=en_GB (charmap=UTF-8) (ignored: LC_ALL set to en_IE.utf8)
Shell: /bin/sh linked to /bin/bash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled

Versions of packages mariadb-server-10.3 depends on:
ii  adduser                   3.118
ii  debconf [debconf-2.0]     1.5.71
ii  galera-3                  25.3.25-1
ii  gawk                      1:4.2.1+dfsg-1
ii  iproute2                  4.20.0-2
ii  libc6                     2.28-8
ii  libdbi-perl               1.642-1+b1
ii  libgnutls30               3.6.6-2
ii  libpam0g                  1.3.1-5
ii  libstdc++6                8.3.0-4
ii  lsb-base                  10.2019031300
ii  lsof                      4.91+dfsg-1
ii  mariadb-client-10.3       1:10.3.13-2
ii  mariadb-common            1:10.3.13-2
ii  mariadb-server-core-10.3  1:10.3.13-2
ii  passwd                    1:4.5-1.1
ii  perl                      5.28.1-5
ii  psmisc                    23.2-1
ii  rsync                     3.1.3-6
ii  socat                     1.7.3.2-2
ii  zlib1g                    1:1.2.11.dfsg-1

Versions of packages mariadb-server-10.3 recommends:
ii  libhtml-template-perl  2.97-1

Versions of packages mariadb-server-10.3 suggests:
ii  bsd-mailx [mailx]  8.1.2-0.20180807cvs-1
ii  mailutils [mailx]  1:3.5-3
ii  mailx              1:20081101-2
pn  mariadb-test       <none>
ii  netcat-openbsd     1.195-2
ii  tinyca             0.7.5-6

-- debconf information:
  mariadb-server-10.3/postrm_remove_databases: false
  mariadb-server-10.3/nis_warning:
  mariadb-server-10.3/old_data_directory_saved: