[Newbies] mariaDB cannot restart
Tofloor
poster avatar
thinker550
deepin
2021-05-14 04:34
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.

Reply Favorite View the author
All Replies
deepinuser17
deepin
2021-05-14 16:49
#1

查看/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 View the author