[arch-general] About tty

[Marcus Hoffmann]

Hi Philippe,

On 08.11.21 17:20, Philippe Delavalade via arch-general wrote:
> Hi list.
> 
> I'm new with archlinux and especially systemd. I'm using linux since around
> twenty years, so i'm not realy newbie but...
> 
> I have many questions but I'll ask one by one.
> 
> I read wiki about systemctl and I'm not sure to have understood
> everything :-(
> 
> For instance, to have a daemon at boottime, I have tried :
> systemctl enable --now ...
> It seems to be OK with ntp, fcron and NetworkManager.
> 
> But with mariadb I obtain a failure.
> 
> Job for mariadb.service failed because the control process exited with error code.
> See "systemctl status mariadb.service" and "journalctl -xeu mariadb.service" for details.
> 
> I tried
> systemctl status mariadb
> and obtained
> × mariadb.service - MariaDB 10.6.4 database server
>       Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
>       Active: failed (Result: exit-code) since Mon 2021-11-08 18:03:16 CET; 1min 47s ago
>         Docs: man:mariadbd(8)
>               https://mariadb.com/kb/en/library/systemd/
>      Process: 515 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
>      Process: 516 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
>      Process: 524 ExecStart=/usr/bin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
>     Main PID: 524 (code=exited, status=1/FAILURE)
>       Status: "MariaDB server is down"
>          CPU: 95ms
> 
> nov. 08 18:03:15 messier31 mariadbd[524]: 2021-11-08 18:03:15 0 [Note] InnoDB: Buffer pool(s) load completed at 211108 18:03:15
> nov. 08 18:03:15 messier31 mariadbd[524]: 2021-11-08 18:03:15 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
> nov. 08 18:03:15 messier31 mariadbd[524]: 2021-11-08 18:03:15 0 [Note] Server socket created on IP: '0.0.0.0'.
> nov. 08 18:03:15 messier31 mariadbd[524]: 2021-11-08 18:03:15 0 [Note] Server socket created on IP: '::'.
> nov. 08 18:03:15 messier31 mariadbd[524]: 2021-11-08 18:03:15 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist
> nov. 08 18:03:15 messier31 mariadbd[524]: 2021-11-08 18:03:15 0 [ERROR] Aborting
> nov. 08 18:03:16 messier31 mariadbd[524]: Warning: Memory not freed: 280
> nov. 08 18:03:16 messier31 systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
> nov. 08 18:03:16 messier31 systemd[1]: mariadb.service: Failed with result 'exit-code'.
> nov. 08 18:03:16 messier31 systemd[1]: Failed to start MariaDB 10.6.4 database server.
> 
> Those messages don't help me.

Look the the lines containing [ERROR] at the bottom, those hint at some 
prerequisites of the service not being correct.

Did you follow https://wiki.archlinux.org/title/MariaDB#Installation? 
I.e. the part about running the command before trying to start the service?

> 
> Can someone tell me more ?
> 
> Regards.
> 


Best,
Marcus