✓ Solved
Mysqld stop working
Hi,
cause of low memory i have (1GB, debian10) or something missing in the config files from mysql server? here are the logs
sudo tail -f /var/log/mysql/error.log
2021-07-26 7:56:28 0 [ERROR] InnoDB: mmap(137035776 bytes) failed; errno 12
2021-07-26 7:56:28 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2021-07-26 7:56:28 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2021-07-26 7:56:28 0 [Note] InnoDB: Starting shutdown...
2021-07-26 7:56:28 0 [ERROR] Plugin 'InnoDB' init function returned error.
2021-07-26 7:56:28 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2021-07-26 7:56:28 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-26 7:56:28 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2021-07-26 7:56:28 0 [ERROR] Aborting
sudo systemctl status mysqld
● mariadb.service - MariaDB 10.3.29 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Mon 2021-07-26 07:56:28 BST; 10h ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 8689 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 8692 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 8696 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_rec
Process: 8823 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILU
Main PID: 8823 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
Jul 26 07:56:23 extdebian-lon systemd[1]: Starting MariaDB 10.3.29 database server...
Jul 26 07:56:27 extdebian-lon mysqld[8823]: 2021-07-26 7:56:27 0 [Note] /usr/sbin/mysqld (mysqld 10.3.29-MariaDB-0+deb10u1) s
Jul 26 07:56:28 extdebian-lon systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jul 26 07:56:28 extdebian-lon systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jul 26 07:56:28 extdebian-lon systemd[1]: Failed to start MariaDB 10.3.29 database server.
Thanks in advance
3 Replies
✓ Best Answer
I’d assume that you’re running too much for the plan you have.
BUT…Check your swap file and memory usage. If your swap file is half or more used, you need to upgrade your plan.
It’s also possible that when you try to run your web server that it’s crashing due to lack of memory and therefore you might not see a memory issue currently.
Looks like you're running out memory. Check that you have swap space setup. It's possible that you need to upgrade to a higher memory plan.
Also, give us more details on what you are running.