Comment # 4 on bug 1061532 from
As of today I cannot reproduce it anymore neither on docker (opensuse:42.3
image) nor in Virtualbox on a fresh standard install (btrfs). Even though the
permissions on /var/lib/mysql are set to root:root by default, rcmysql starts
just fine.

Thanks for spending time on the investigation.

Just for your information these are the logs I can get from journald when I had
encounter this issue at the first time.

-------------
Mar 03 22:04:22 microchuck systemd[1]: Starting MySQL server...
Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: Creating MySQL
privilege database...
Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: Installing
MariaDB/MySQL system tables in '/var/lib/mysql' ...
Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: 180303 22:04:22 [Note]
/usr/sbin/mysqld (mysqld 10.0.33-MariaDB) starting as process 31824 ...
Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: cat: write error:
Broken pipe
Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: Installation of system
tables failed!  Examine the logs in
Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: /var/lib/mysql for more
information.
Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: The problem could be
conflicting information in an external
Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: my.cnf files. You can
ignore these by doing:
Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]:     shell>
/usr/bin/mysql_install_db --defaults-file=~/.my.cnf
Mar 03 22:04:22 microchuck systemd[1]: mysql.service: Control process exited,
code=exited status=1
Mar 03 22:04:22 microchuck systemd[1]: Failed to start MySQL server.
Mar 03 22:04:22 microchuck systemd[1]: mysql.service: Unit entered failed
state.
Mar 03 22:04:22 microchuck systemd[1]: mysql.service: Failed with result
'exit-code'.
Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: You can also try to
start the mysqld daemon with:
Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]:     shell>
/usr/sbin/mysqld --skip-grant --general-log &
Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: and use the command
line tool /usr/bin/mysql
Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: to connect to the mysql
database and look at the grant tables:
Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]:     shell>
/usr/bin/mysql -u root mysql
Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]:     mysql> show tables;
Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: Try 'mysqld --help' if
you have problems with paths.  Using
Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: --general-log gives you
a log in /var/lib/mysql that may be helpful.
Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: The latest information
about mysql_install_db is available at
Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]:
https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: MariaDB is hosted on
launchpad; You can find the latest source and
Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: email lists at
http://launchpad.net/maria
Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: Please check all of the
above before submitting a bug report
Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: at
http://mariadb.org/jira
Mar 03 22:04:22 microchuck mysql-systemd-helper[31785]: Creation of MySQL
databse in /var/lib/mysql failed
Mar 03 22:04:22 microchuck polkitd[31773]: Unregistered Authentication Agent
for unix-process:31768:5312640 (system bus name :1.199, object path
/org/freedesktop/PolicyKit1/AuthenticationAgent, locale POSIX) (di
Mar 03 22:04:22 microchuck sudo[31758]: pam_unix(sudo:session): session closed
for user mysql

-------------


You are receiving this mail because: