Filesystem is full error on first startup of MySQL

Hello,

I have run into an error /: write failed, filesystem is full when starting MySQL80
I may be over my head here, but I thought I would post in case there is an easy fix I’m overlooking or maybe useful info for the devs?

I’m new BSD in general, so I’m trying out NomadBSD with the goal of using Nomad to turn an old Dell Optiplex 755 into a server using NextCloud on a FAMP stack.

I ran into a similar error using Nomad1.3 when installing Apache and saw that issue was addressed in 1.4-RC1, so that is what I’m running now.

The error is below along with before and after output of du
Thanks

nomad@NomadBSD ~> df -h
Filesystem Size Used Avail Capacity Mounted on
/dev/label/nomadroot 3.7G 3.4G 77M 98% /
devfs 1.0K 1.0K 0B 100% /dev
tmpfs 2.9G 22M 2.9G 1% /tmp
tmpfs 2.9G 284K 2.9G 0% /var/log
procfs 4.0K 4.0K 0B 100% /proc
/dev/label/nomaddata 25G 972M 22G 4% /data
/dev/md0.uzip 6.5G 6.0G 446M 93% /unionfs/usr/local
/dev/fuse 31G 7.4G 22G 25% /usr/local
/data/compat 25G 972M 22G 4% /compat
/data/var/tmp 25G 972M 22G 4% /var/tmp
/data/var/db/freebsd-update 25G 972M 22G 4% /var/db/freebsd-update
/data/var/db/portsnap 25G 972M 22G 4% /var/db/portsnap
/data/usr/ports 25G 972M 22G 4% /usr/ports

nomad@NomadBSD ~> sudo service mysql-server start
Password:
/: write failed, filesystem is full
/usr.local.etc/rc.d/mysql-server: WARNING: failed precmd routine for mysql

nomad@NomadBSD ~ [1]> df -h
Filesystem Size Used Avail Capacity Mounted on
/dev/label/nomadroot 3.7G 3.4G 17M 100% /
devfs 1.0K 1.0K 0B 100% /dev
tmpfs 2.8G 22M 2.8G 1% /tmp
tmpfs 2.8G 288K 2.8G 0% /var/log
procfs 4.0K 4.0K 0B 100% /proc
/dev/label/nomaddata 25G 972M 22G 4% /data
/dev/md0.uzip 6.5G 6.0G 446M 93% /unionfs/usr/local
/dev/fuse 31G 7.4G 22G 25% /usr/local
/data/compat 25G 972M 22G 4% /compat
/data/var/tmp 25G 972M 22G 4% /var/tmp
/data/var/db/freebsd-update 25G 972M 22G 4% /var/db/freebsd-update
/data/var/db/portsnap 25G 972M 22G 4% /var/db/portsnap
/data/usr/ports 25G 972M 22G 4% /usr/ports
nomad@NomadBSD ~>

Hi @Splined,

there is very little space on /, so you need to move mysql's directory, and create a symlink:

# mv /var/db/mysql /data/var/db/
# ln -s /data/var/db/mysql /var/db/

Yes, that did the trick. For some reason I thought the entire /var/db directory was moved under /data in 1.4, instead of a select few sub-directories. And I could have sworn I double checked that that was the case, oh well.

Thanks very much for your help. Everything else installed with no issues.

This will be the case in 1.4 :slight_smile:

1 Like