deepinuser17
deepin
2021-05-14 16:49 查看/etc/mysql/mariadb.conf.d/50-server.cnf.
"max_allowed_packet" is commented out with default value 16M.
If you have made any change to this file or another file, try backing out the change. and then restart mariadb server.
Reply Like 0 View the author


中文 
Hi Everyone
I successfully installed Mariadb. I then did a service shut
service mysql stop
but I cannot start it up due to the below errors.
Appreciate your help to debug.
Thinker550
root@xxx-PC:/var/run/mysqld# service mysql start
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
root@xxx-PC:/var/run/mysqld# systemctl status mariadb.service
● mariadb.service - MariaDB 10.3.27 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Thu 2021-05-13 20:28:52 +08; 12s ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 11835 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exite
Process: 11836 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exit
Process: 11838 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/
Process: 11915 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (
Main PID: 11915 (code=exited, status=1/FAILURE)
May 13 20:28:52 xxx-PC systemd[1]: Starting MariaDB 10.3.27 database server...
May 13 20:28:52 xxx-PC mysqld[11915]: Unknown suffix '"' used for variable 'max_allowed_packet' (v
May 13 20:28:52 xxx-PC mysqld[11915]: 2021-05-13 20:28:52 0 [Warning] option 'max_allowed_packet':
May 13 20:28:52 xxx-PC mysqld[11915]: 2021-05-13 20:28:52 0 [ERROR] /usr/sbin/mysqld: Error while
May 13 20:28:52 xxx-PC systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAI
May 13 20:28:52 xxx-PC systemd[1]: mariadb.service: Failed with result 'exit-code'.
May 13 20:28:52 xxx-PC systemd[1]: Failed to start MariaDB 10.3.27 database server.