forum.excito.org

Posted: **31 Jan 2014, 16:38**

Hi all,

My HomeAutomation stopped working as mysql cannot start, turns out that:

root@b3:/# df -h
Filsystem          Storlek Anvnt Tillg Anv% Monterat på
/dev/sda1             9,9G  9,7G     0 100% /

Code: Select all

root@b3:/# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
root@b3:/# /etc/init.d/mysql start
/etc/init.d/mysql: ERROR: The partition with /var/lib/mysql is too full! ... failed!
root@b3:/#

I've searched the forum for similar problems, the nearest (?) problem might be in http://forum.excito.net/viewtopic.php?f=9&t=4398, but I don't have the mail activated so no solution there for me.

I've searched the disk with

Code: Select all

du -s -h -x /*

giving me the following:

4,4M /bin
3,4M /boot
140K /dev
7,8M /etc
837G /home
47M /lib
16K /lost+found
4,0K /media
4,0K /mnt
4,0K /opt
du: kan inte komma åt "/proc/10088/task/10088/fd/4": No such file or directory
du: kan inte komma åt "/proc/10088/task/10088/fdinfo/4": No such file or directory
du: kan inte komma åt "/proc/10088/fd/4": No such file or directory
du: kan inte komma åt "/proc/10088/fdinfo/4": No such file or directory
du: kan inte komma åt "/proc/10581": No such file or directory
0 /proc
100K /root
5,6M /sbin
4,0K /selinux
4,0K /srv
0 /sys
0 /tmp
1,2G /usr
6,0G /var
4,0K /work

From here I don't know how to proceed, which directories are safe to clean...??

System version installed on my B3: 2.6.0.2

Posted: **01 Feb 2014, 02:43**

your problem is in var and most likely in /var/spool/mail because of excessive mail to root. I'd continue your du with

Code: Select all

du -shx /var/*

and further down untll you find the issues. in var you can empty almost anything but dont hesitate to ask if you're not sure. If the problem is indeed in /var/mail/root you also need additional steps later to prevent relapse. This has been discusses a fair few times in this forum alread. So please have a look there first but dont hesitste to check back here if you cant manage

EDIT: you state that you do not have mail activated, but that does not mean there is no mail. Linux systems send a lot of internal mail. Turning off the mail services on the GUI does not change this

Posted: **01 Feb 2014, 02:45**

The 6G on /var is likely the issue. I'd suggest you narrow that down, but I suspect that /var/lib/mysql will be a high candidate.

forum.excito.org

/dev/sda1 full?! (No mail service activated...)

/dev/sda1 full?! (No mail service activated...)

Re: /dev/sda1 full?! (No mail service activated...)

Re: /dev/sda1 full?! (No mail service activated...)