mariadb issue

Owned by Jean-luc KRIKER
Last updated: Jun 10, 2020
2 min read





fail to connect
librenms@librenms:~$ mysql -u librenms -p
Enter password:    [ default:   D42nf23rewD  ]
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111 "Connection refused")
librenms@librenms:~$

msql status
librenms@librenms:/var/run/mysqld$ systemctl status mysql.service
● mariadb.service - MariaDB 10.1.44 database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
   Active: failed (Result: exit-code) since Wed 2020-06-10 10:57:49 UTC; 14min ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 1099 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 1097 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
  Process: 2142 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
  Process: 2081 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment
  Process: 2079 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 2076 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
 Main PID: 2142 (code=exited, status=1/FAILURE)
   Status: "MariaDB server is down"
librenms@librenms:/var/run/mysqld$

stop and start
librenms@librenms:/var/run/mysqld$ sudo systemctl stop mysql.service

librenms@librenms:/var/run/mysqld$ sudo systemctl start mysql.service

librenms@librenms:/var/run/mysqld$ systemctl status mysql.service
● mariadb.service - MariaDB 10.1.44 database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
   Active: active (running) since Wed 2020-06-10 11:13:23 UTC; 4s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 5159 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 5157 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
  Process: 5114 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment
  Process: 5112 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 5111 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
 Main PID: 5129 (mysqld)
   Status: "Taking your SQL requests now..."
    Tasks: 27 (limit: 522)
   CGroup: /system.slice/mariadb.service
           └─5129 /usr/sbin/mysqld
librenms@librenms:/var/run/mysqld$