MariaDB : Result: exit-code & Internal Server Error

I was really stucked at DropBox Settings, and already seen many people also stucked at same point. Still, No proper documentation. Anyway, This incident help me to lean new chapter.

Was doing DropBox Settings as mentioned here{Not Getting Link Back}. Anyway, By updating access key & secret to site_config.json file. This result nothing. Just removed input from DropBox Setting while still not able to allow access. Anyway, nothing happen there. But had given another gift to me.

“Internal Server Error”. As per previous experince, tried update bench, restart mysql both way a. /etc/init.d/mysqld start & b. sudo service mysql restart Got to know MariaDB server error. I don’t know why,this may resolve my error > Error when installing erpnext on fresh ubuntu 16.04 via script - #7 by navdeepghai

But still afraid to do. Help me out. In production.

root@ip-17X-31-XX-137:/home/frappe/frappe-bench# sudo service mysql restart Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details. root@ip-17X-31-XX-137:/home/frappe/frappe-bench# systemctl status mariadb.service ● 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 Sat 2017-04-08 00:06:57 UTC; 14s ago Process: 1475 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Process: 1471 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS) Process: 6189 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE) Process: 6009 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSRE
Process: 6001 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 5997 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Main PID: 6189 (code=exited, status=1/FAILURE)
Status: “MariaDB server is down”

Apr 08 00:06:57 ip-17X-31-XX-137 mysqld[6189]: 2017-04-08 0:06:57 140575479642368 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
Apr 08 00:06:57 ip-17X-31-XX-137 mysqld[6189]: 2017-04-08 0:06:57 140575479642368 [ERROR] Plugin ‘InnoDB’ init function returned error.
Apr 08 00:06:57 ip-17X-31-XX-137 mysqld[6189]: 2017-04-08 0:06:57 140575479642368 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
Apr 08 00:06:57 ip-17X-31-XX-137 mysqld[6189]: 2017-04-08 0:06:57 140575479642368 [Note] Plugin ‘FEEDBACK’ is disabled.
Apr 08 00:06:57 ip-17X-31-XX-137 mysqld[6189]: 2017-04-08 0:06:57 140575479642368 [ERROR] Unknown/unsupported storage engine: InnoDB
Apr 08 00:06:57 ip-17X-31-XX-137 mysqld[6189]: 2017-04-08 0:06:57 140575479642368 [ERROR] Aborting
Apr 08 00:06:57 ip-17X-31-XX-137 systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Apr 08 00:06:57 ip-17X-31-XX-137 systemd[1]: Failed to start MariaDB database server.
Apr 08 00:06:5717X-31-XX-137 systemd[1]: mariadb.service: Unit entered failed state.
Apr 08 00:06:5717X-31-XX-137 systemd[1]: mariadb.service: Failed with result ‘exit-code’.
lines 1-24/24 (END)`

1 Like

I faced a similar issue a while ago.
This worked for me: 15.10 - Why does mariadb keep dying? How do I stop it? - Ask Ubuntu

1 Like

WOW !! :heart_eyes:
Again, You helped me. Thank You so much Sagar.

I want to ask, why dropbox is not configuring with my ERPNext Server? Will you please help me regarding that. Any thread or any post written?