Debian – MariaDB cannot restart

debiandebian-jessiemariadb

Im running Mariadb on dedicated server with Debian Jessie suddenly get shut down when i try to start mysql it gives me this error:

Dec 31 20:18:20  mysqld[6630]: 2016-12-31 20:18:20 140334745393088 [Note] /usr/sbin/mysqld (mysqld 10.1.20-MariaDB-1~jessie) starting as process 6630 ...
Dec 31 20:19:50  systemd[1]: mariadb.service start operation timed out. Terminating.
Dec 31 20:20:32  systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Dec 31 20:20:32  systemd[1]: Failed to start MariaDB database server.
Dec 31 20:20:32  systemd[1]: Unit mariadb.service entered failed state.

the output of error.log shows something related to space how can resolve it

    2016-12-31 19:33:06 140069282318080 [Warning] mysqld: Disk is full writing '/var/lib/mysql/oem1/oempro_log_campaign_sends.MYI' (Errcode: 28 "No space left on device"). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
2016-12-31 19:33:06 140069282318080 [Warning] mysqld: Retry in 60 secs. Message reprinted in 600 secs

here's my server disk space:

    root@dc:/var/lib/mysql# df
Filesystem     1K-blocks      Used Available Use% Mounted on
/dev/sda3      106882096 101403084     26624 100% /
udev               10240         0     10240   0% /dev
tmpfs            1604908    164396   1440512  11% /run
tmpfs            4012268         0   4012268   0% /dev/shm
tmpfs               5120         0      5120   0% /run/lock
tmpfs            4012268         0   4012268   0% /sys/fs/cgroup
/dev/sda1         474730     32398    413302   8% /boot
/dev/sdb1      115247656     61060 109309248   1% /home

Best Answer

2016-12-31 19:33:06 140069282318080 [Warning] mysqld: Disk is full writing '/var/lib/mysql/oem1/oempro_log_campaign_sends.MYI' (Errcode: 28 "No space left on device").

The storage that contains /var/lib/mysql is full. These is no space left on it for you to use. You will have to free up some space, move your database files to a different device or increase the size of the storage.

How you free up storage space depends upon what is filling it. How you increase the size (or whether you can) depends upon what kind of storage you have.

Related Topic