..
fix mariadb service timeout
现象: sudo systemctl status mariadb
mariadb.service - MariaDB 10.3.32 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Active: failed (Result: timeout) since Wed 2022-01-19 03:26:04 UTC; 2min 30s ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 35373 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 35374 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 35376 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>
Process: 35427 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 35427 (code=exited, status=0/SUCCESS)
Jan 19 03:11:02 ip-10-0-0-78 systemd[1]: Starting MariaDB 10.3.32 database server...
Jan 19 03:11:02 ip-10-0-0-78 mysqld[35427]: 2022-01-19 3:11:02 0 [Note] /usr/sbin/mysqld (mysqld 10.3.32-MariaDB-0ubuntu0.20.04.1) starting as process 35427 ...
Jan 19 03:26:03 ip-10-0-0-78 systemd[1]: mariadb.service: start operation timed out. Terminating.
Jan 19 03:26:04 ip-10-0-0-78 systemd[1]: mariadb.service: Failed with result 'timeout'.
Jan 19 03:26:04 ip-10-0-0-78 systemd[1]: Failed to start MariaDB 10.3.32 database server.
fix
$ echo "/usr/sbin/mysqld { }" > /etc/apparmor.d/usr.sbin.mysqld
$ apparmor_parser -v -R /etc/apparmor.d/usr.sbin.mysqld
$ systemctl restart mariadb