Was this start attempt just after mariadb install where the archwiki
page got used or a start attempt after successful setup? If the former,
I had the same bad luck and went with postgresql and got postgresql up
and running.
On Fri, 27 Jan 2017, Peter Nabbefeld wrote:
Date: Fri, 27 Jan 2017 07:12:20
From: Peter Nabbefeld <peter.nabbefeld@xxxxxx>
Reply-To: General Discussion about Arch Linux <arch-general@xxxxxxxxxxxxx>
To: arch-general@xxxxxxxxxxxxx
Subject: MariaDB not starting
Hello,
I've got problems with MariaDB not working.
1) "systemctl status mariadb.service":
? mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor
preset: disabled)
Active: failed (Result: exit-code) since Fri 2017-01-27 13:04:10 CET; 13s
ago
Process: 4574 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER
$_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Process: 4519 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] &&
VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl
set-environment _WSREP_START_POSITION=$VAR
Process: 4517 ExecStartPre=/bin/sh -c systemctl unset-environment
_WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 4574 (code=exited, status=1/FAILURE)
Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10 140214454369792
[Note] Starting crash recovery...
Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10 140214454369792
[Note] Crash recovery finished.
Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10 140214454332160
[Warning] Failed to load slave replication state from table
mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos'
Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10 140214454369792
[ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't
exist
Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10 140214454369792
[Note] Server socket created on IP: '::'.
Jan 27 13:04:10 tuchola mysqld[4574]: 2017-01-27 13:04:10 140214454369792
[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user'
doesn't exist
Jan 27 13:04:10 tuchola systemd[1]: mariadb.service: Main process exited,
code=exited, status=1/FAILURE
Jan 27 13:04:10 tuchola systemd[1]: Failed to start MariaDB database server.
Jan 27 13:04:10 tuchola systemd[1]: mariadb.service: Unit entered failed
state.
Jan 27 13:04:10 tuchola systemd[1]: mariadb.service: Failed with result
'exit-code'.
2) "journalctl -xe":
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
