forum.excito.org

Hi,

I'm using my Bubba 2 server as database for my XBMC installations, but recently I got problems with the configuration and my XBMC was unable to get all information for the database.

I restarted the Bubba 2 to see if this solved the issue, it didn't. But when I tried to manually start the mysql server i got the error message below.

/etc/init.d/mysql: ERROR: The partition with /var/lib/mysql is too full! ... failed!

I googled some and found out that the command apt-get clean could remove some data.

When I run the command

df -h /dev/sda1

I get the result:

Filesystem Size Used Avail Use% Mounted on
/dev/sda1 9.2G 9.0G 0 100% /

But I still can't start up mysql.

Have anyone else encountered the same issue? How did you solve it?

Thanks in advance.

There have been several reports on flooding of the root partition. Most of them involve emails sent by the cron daemon to root, so you should most definitely check the disk usage of root's mail directory.

Gordon wrote:There have been several reports on flooding of the root partition. Most of them involve emails sent by the cron daemon to root, so you should most definitely check the disk usage of root's mail directory.

Thanks for the fast answer, can you please say where this is located?

Find complete answer in THIS thread

Gordon wrote:Find complete answer in THIS thread

Hi Gordon,
I have had a look in that thread and when i execute the command
I get the response:
find: `/root/Mail': No such file or directory
0

when i use the command the response is
No mail for root

and the command gives me the response:
Cannot open mailbox /root/MAIL/: Is a directory
No mail for root

Any other ideas?

linux is case sensitive

"/root/Mail" is something different than "/root/MAIL"
But I agree, Gordons solution does not work for me either. You need to first find out what your actual mail format is for root, and then adjust the mail command accordingly

That's kind of weird. On the B3, the default is for the mail directory to be named "Mail". But yes, it can be named differently and in that case you the config files for postfix and dovecot need to be changed accordingly.
If the mailbox for root does not exist then you are in deeper trouble. The emails intended for root will then stay in the mail queue and they will stay there indefinitely. Clearing that mail queue is a tedious job I'm afraid.

Just to be on the safe side: what's your size of /var/mail/root?

Edit: skip that last question. `mail` already responded there was no mail.

Come to think of it, if you don't have a mailbox for root and the mail queue is piled with messages for root that may be not so bad after all. You can go straight to the optional part of making admin an alias for root and then postfix should start delivering the stalled emails in admin's mailbox (i.e. away from the root partition).

why not avoid filling roots mailbox with crap and first run a "postsuper -D ALL" to start with a clean slate?

I've sovled my issues, it wasn't the mail that was using all the space it was backup files located in the /nmt/bubba-backup/ folder.

I found them by using the command
I removed these files and now I can start up the mysql server again.

Why does the Bubba store backupfiles there when I have chosen another location during the setup?