[debian-mysql] Bug#922644: Bug#922644: mariadb-server-10.3: Unable to reinstall

[Janusz S. Bień]

On Fri, Feb 22 2019 at 15:51 +02, Otto Kekäläinen wrote:
> Control: tags -1 moreinfo
>
> Hello!
>
> ma 18. helmik. 2019 klo 21.54 Janusz S. Bień (jsbien at mimuw.edu.pl) kirjoitti:
>> When I try to reinstall the package, I get
>>
>> --8<---------------cut here---------------start------------->8---
>> Setting up mariadb-server-10.3 (1:10.3.12-2) ...
>> dpkg: error processing package mariadb-server-10.3 (--configure):
>>  installed mariadb-server-10.3 package post-installation script subprocess returned error exit status 7
>> --8<---------------cut here---------------end--------------->8---
>
> Thanks for reporting! Unfortunately the information above does not
> reveal anything. What about the syslog/journald? Anything related
> logged in /var/log or /var/lib/mysql ?

Thank you very much for your interest in my problem.

I've just reproduced the problem again.

In syslog I found

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

but this instruction is confusing:

1. I don't see anything readable in /var/lib/mysql, ib_logfile0 seems to
me to be binary.

2. I don't have .my.cnf file at all.

3. I don't have /usr/sbin/mysqld.

4. I don't have /usr/sbin/mysql.

Moreover I don't think the process 23461 actually started.

Best regards

Janusz

-- 
             ,   
Janusz S. Bien
emeryt (emeritus)
https://sites.google.com/view/jsbien