I have a VPS running for a long time. It's for some small websites and for private mail for myself and family. According to directadmin I was only using 10 gigabyte of space and the VPS should have 50 gigabyte.
Last week I was testing SQL queries. Yesterday I got the first error when phpmyadmin could not perform one SQL due to: no space left. Small queries did work. I updated my VPS plan from 50gb to 150gb and did an update:
yum check-update
yum update -y
/usr/local/directadmin/custombuild/build update
/usr/local/directadmin/custombuild/build update_versions
reboot
After the reboot Apache, Exim, MariaDB and Named stopped. Directadmin is running so I can access it but all my websites and my email are now unreachable.
When I performed:
[root@server domains]# systemctl status httpd.service
● httpd.service - The Apache HTTP Server
Loaded: loaded (/etc/systemd/system/httpd.service; enabled; vendor preset: disabled)
Active: failed (Result: resources)
Jun 20 21:53:32 server.intermagic.nl systemd[1]: httpd.service failed to run 'start' task: No space left on device
Jun 20 21:53:32 server.***.nl systemd[1]: Failed to start The Apache HTTP Server.
Jun 20 21:53:32 server.***.nl systemd[1]: Unit httpd.service entered failed state.
Jun 20 21:53:32 server.***.nl systemd[1]: httpd.service failed.
Jun 20 21:57:43 server.***.nl systemd[1]: httpd.service failed to run 'start' task: No space left on device
Jun 20 21:57:43 server.***.nl systemd[1]: Failed to start The Apache HTTP Server.
Jun 20 21:57:43 server.***.nl systemd[1]: httpd.service failed.
After a lot of reboots I now get:
[admin@server tmp]$ systemctl status httpd.service
● httpd.service - The Apache HTTP Server
Loaded: loaded (/etc/systemd/system/httpd.service; enabled; vendor preset: disabled)
Active: failed (Result: resources)
What could be the cause of it? Really too much of bad SQL queries? And what can I do about it? I can re-install everything, but...
Edit 1:
Filesystem Size Used Avail Use% Mounted on
devtmpfs 1.9G 0 1.9G 0% /dev
tmpfs 1.9G 0 1.9G 0% /dev/shm
tmpfs 1.9G 89M 1.8G 5% /run
tmpfs 1.9G 0 1.9G 0% /sys/fs/cgroup
/dev/mapper/vg_directadmin-lv_root 48G 20G 28G 42% /
/dev/vda1 497M 262M 236M 53% /boot
/dev/mapper/vg_directadmin-lv_tmp 1014M 1014M 0 100% /tmp