MariaDB server is down anyway to repair?


#1

Hello,

My Easy Engine server MariaDB MySQL isn’t running. I have reset the my.cnf file to default and still can’t start my MySQL server. Anyway to fix it without loosing data?

When I run “ee debug --mysql” it gives “(2003, "Can’t connect to MySQL Server on “localhost” ‘’ (111)

root@servername:~# sudo service mysql status

  • mariadb.service - MariaDB database server​​ Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled) Drop-In: /etc/systemd/system/mariadb.service.d -migrated-from-my.cnf-settings.conf Active: failed (Result: exit-code) since Thu 2016-12-15 05:02:07 UTC; 16s ago Process: 1544 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION Process: 1289 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=/usr/b Process: 1238 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=ex Process: 1207 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exi Main PID: 1544 (code=exited, status=2) Status: “MariaDB server is down”

Dec 15 05:02:06 servername.com mysqld[1544]: 2016-12-15 5:02:06 140586989086976 [ERROR] InnoDBDec 15 05:02:06 servername.com mysqld[1544]: 2016-12-15 5:02:06 140586989086976 [ERROR] PluginDec 15 05:02:06 servername.com mysqld[1544]: 2016-12-15 5:02:06 140586989086976 [ERROR] PluginDec 15 05:02:06 servername.com mysqld[1544]: 2016-12-15 5:02:06 140586989086976 [Note] Plugin Dec 15 05:02:06 servername.com mysqld[1544]: 2016-12-15 5:02:06 140586989086976 [ERROR] /usr/sDec 15 05:02:06 servername.com mysqld[1544]: 2016-12-15 5:02:06 140586989086976 [ERROR] AbortiDec 15 05:02:07 servername.com systemd[1]: mariadb.service: Main process exited, code=exited, sDec 15 05:02:07 servername.com systemd[1]: Failed to start MariaDB database server. Dec 15 05:02:07 servername.com systemd[1]: mariadb.service: Unit entered failed state. Dec 15 05:02:07 servername.com systemd[1]: mariadb.service: Failed with result ‘exit-code’. lines 1-22/22 (END)…skipping…

  • mariadb.service - MariaDB database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled) Drop-In: /etc/systemd/system/mariadb.service.d -migrated-from-my.cnf-settings.conf Active: failed (Result: exit-code) since Thu 2016-12-15 05:02:07 UTC; 16s ago Process: 1544 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status= Process: 1289 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=/usr/bin/galera_recovery`; [ Process: 1238 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS Process: 1207 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS) Main PID: 1544 (code=exited, status=2) Status: “MariaDB server is down”

Dec 15 05:02:06 servername.com mysqld[1544]: 2016-12-15 5:02:06 140586989086976 [ERROR] InnoDB: Cannot set log file Dec 15 05:02:06 servername.com mysqld[1544]: 2016-12-15 5:02:06 140586989086976 [ERROR] Plugin ‘InnoDB’ init functioDec 15 05:02:06 servername.com mysqld[1544]: 2016-12-15 5:02:06 140586989086976 [ERROR] Plugin ‘InnoDB’ registrationDec 15 05:02:06 servername.com mysqld[1544]: 2016-12-15 5:02:06 140586989086976 [Note] Plugin ‘FEEDBACK’ is disabledDec 15 05:02:06 servername.com mysqld[1544]: 2016-12-15 5:02:06 140586989086976 [ERROR] /usr/sbin/mysqld: unknown opDec 15 05:02:06 servername.com mysqld[1544]: 2016-12-15 5:02:06 140586989086976 [ERROR] Aborting Dec 15 05:02:07 servername.com systemd[1]: mariadb.service: Main process exited, code=exited, status=2/INVALIDARGUMENDec 15 05:02:07 servername.com systemd[1]: Failed to start MariaDB database server. Dec 15 05:02:07 servername.com systemd[1]: mariadb.service: Unit entered failed state. Dec 15 05:02:07 servername.com systemd[1]: mariadb.service: Failed with result ‘exit-code’. ~ lines 1-22/22 (END)…skipping…

  • mariadb.service - MariaDB database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled) Drop-In: /etc/systemd/system/mariadb.service.d -migrated-from-my.cnf-settings.conf Active: failed (Result: exit-code) since Thu 2016-12-15 05:02:07 UTC; 16s ago Process: 1544 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=2) Process: 1289 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-env Process: 1238 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Process: 1207 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS) Main PID: 1544 (code=exited, status=2) Status: “MariaDB server is down”

Dec 15 05:02:06 servername.com mysqld[1544]: 2016-12-15 5:02:06 140586989086976 [ERROR] InnoDB: Cannot set log file ./ib_logfile1 to size 50 MB Dec 15 05:02:06 servername.com mysqld[1544]: 2016-12-15 5:02:06 140586989086976 [ERROR] Plugin ‘InnoDB’ init function returned error. Dec 15 05:02:06 servername.com mysqld[1544]: 2016-12-15 5:02:06 140586989086976 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed. Dec 15 05:02:06 servername.com mysqld[1544]: 2016-12-15 5:02:06 140586989086976 [Note] Plugin ‘FEEDBACK’ is disabled. Dec 15 05:02:06 servername.com mysqld[1544]: 2016-12-15 5:02:06 140586989086976 [ERROR] /usr/sbin/mysqld: unknown option '–Error logging goes to syslDec 15 05:02:06 servername.com mysqld[1544]: 2016-12-15 5:02:06 140586989086976 [ERROR] Aborting Dec 15 05:02:07 servername.com systemd[1]: mariadb.service: Main process exited, code=exited, status=2/INVALIDARGUMENT Dec 15 05:02:07 servername.com systemd[1]: Failed to start MariaDB database server. Dec 15 05:02:07 servername.com systemd[1]: mariadb.service: Unit entered failed state. Dec 15 05:02:07 servername.com systemd[1]: mariadb.service: Failed with result ‘exit-code’. ~

lines 1-22/22 (END)…skipping…

  • mariadb.service - MariaDB database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled) Drop-In: /etc/systemd/system/mariadb.service.d -migrated-from-my.cnf-settings.conf Active: failed (Result: exit-code) since Thu 2016-12-15 05:02:07 UTC; 16s ago Process: 1544 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=2) Process: 1289 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, st Process: 1238 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Process: 1207 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS) Main PID: 1544 (code=exited, status=2) Status: “MariaDB server is down”

Dec 15 05:02:06 servername.com mysqld[1544]: 2016-12-15 5:02:06 140586989086976 [ERROR] InnoDB: Cannot set log file ./ib_logfile1 to size 50 MB Dec 15 05:02:06 servername.com mysqld[1544]: 2016-12-15 5:02:06 140586989086976 [ERROR] Plugin ‘InnoDB’ init function returned error. Dec 15 05:02:06 servername.com mysqld[1544]: 2016-12-15 5:02:06 140586989086976 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed. Dec 15 05:02:06 servername.com mysqld[1544]: 2016-12-15 5:02:06 140586989086976 [Note] Plugin ‘FEEDBACK’ is disabled. Dec 15 05:02:06 servername.com mysqld[1544]: 2016-12-15 5:02:06 140586989086976 [ERROR] /usr/sbin/mysqld: unknown option ‘–Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf.’ Dec 15 05:02:06 servername.com mysqld[1544]: 2016-12-15 5:02:06 140586989086976 [ERROR] Aborting Dec 15 05:02:07 servername.com systemd[1]: mariadb.service: Main process exited, code=exited, status=2/INVALIDARGUMENT Dec 15 05:02:07 servername.com systemd[1]: Failed to start MariaDB database server. Dec 15 05:02:07 servername.com systemd[1]: mariadb.service: Unit entered failed state. Dec 15 05:02:07 servername.com systemd[1]: mariadb.service: Failed with result ‘exit-code’. ~ lines 1-22/22 (END)


#2

same issue


#3

Can you open the following file, and check what bind-address is set to

nano /etc/mysql/my.cnf

Hit Ctrl+W and search for bind-address. It should be set to

bind-address = 127.0.0.1


#4

I am experiencing same problem with the yesterday night. Still didn’t able to work way out from this error.

Can somebody tell me how to fix this.


#5