[arch-general] MariaDB not starting

[Jude DaShiell]

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 at gmx.de>
> Reply-To: General Discussion about Arch Linux <arch-general at archlinux.org>
> To: arch-general at archlinux.org
> Subject: [arch-general] 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
>

--