Question
After resize Droplet Maria DB stopped on Ubuntu16 Nginx
Hi After resizing my droplet to 4gb Ram and 2 CPU Maria DB does not start
Got this message
sudo service mysql start
Job for mariadb.service failed because a timeout was exceeded. See "systemctl status mariadb.service" and "journalctl -xe" for details.
systemctl status mariadb.service
mariadb.service - MariaDB 10.2.13 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: timeout) since Mon 2018-03-12 00:29:30 UTC; 1min 7s ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 2223 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 2068 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, status
Process: 2062 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 2056 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Main PID: 2223 (code=exited, status=0/SUCCESS)
Mar 12 00:29:29 lemp-s-1vcpu-1gb-fra1-01 mysqld[2223]: 2018-03-12 0:29:29 140371577255680 [Note] InnoDB: FTS optimize thread exiting.
Mar 12 00:29:29 lemp-s-1vcpu-1gb-fra1-01 mysqld[2223]: 2018-03-12 0:29:29 140372484671232 [Note] InnoDB: Starting shutdown...
Mar 12 00:29:29 lemp-s-1vcpu-1gb-fra1-01 mysqld[2223]: 2018-03-12 0:29:29 140371266889472 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
Mar 12 00:29:29 lemp-s-1vcpu-1gb-fra1-01 mysqld[2223]: 2018-03-12 0:29:29 140371266889472 [Note] InnoDB: Buffer pool(s) dump completed at 180312 0:29:29
Mar 12 00:29:30 lemp-s-1vcpu-1gb-fra1-01 mysqld[2223]: 2018-03-12 0:29:30 140372484671232 [Note] InnoDB: Shutdown completed; log sequence number 21026778
Mar 12 00:29:30 lemp-s-1vcpu-1gb-fra1-01 mysqld[2223]: 2018-03-12 0:29:30 140372484671232 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
Mar 12 00:29:30 lemp-s-1vcpu-1gb-fra1-01 mysqld[2223]: 2018-03-12 0:29:30 140372484671232 [Note] /usr/sbin/mysqld: Shutdown complete
Mar 12 00:29:30 lemp-s-1vcpu-1gb-fra1-01 systemd[1]: Failed to start MariaDB 10.2.13 database server.
Mar 12 00:29:30 lemp-s-1vcpu-1gb-fra1-01 systemd[1]: mariadb.service: Unit entered failed state.
Mar 12 00:29:30 lemp-s-1vcpu-1gb-fra1-01 systemd[1]: mariadb.service: Failed with result 'timeout'
Any Idea?
edited by bobbyiliev
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
×
@aargenis
The output you provided is not enough to help you.
You need to provide the last few lines of MariaDB error log which can be found here
/var/log/mysqld.logif you cannot find it execute this query to get its pathMariaDB> SHOW VARIABLES LIKE 'log_error';I believe it is a memory issue, how much memory did you have before?