TRANSFER: Account : Insufficient disk space is available. /var/lib/mysql
Trying to do an account transfer between servers and on 2 of the accounts I'm getting an error:
TRANSFER: Account "d****s": Insufficient disk space is available. "/var/lib/mysql" on host "*****.cprapid.com" has 63.44 GB free and requires at least 70.46 GB free, which includes space for temporary files.
Obviously I understand it is saying it doesn't have the necessary space available to move the database. However, there is a massive amount of free space on the drive partition.
Is this a tmpfs directory? What is the easiest way to fix the issue?
I'm comfortable on the terminal, but not overly experienced with Linux sysadmin or file system management
-
You can use df -h to see partition usage. 0 -
You can use df -h to see partition usage.
Thanks, so did the person that provisioned the server partition the home directly unnecessarily large? Filesystem Size Used Avail Use% Mounted on devtmpfs 4.0M 0 4.0M 0% /dev tmpfs 63G 0 63G 0% /dev/shm tmpfs 26G 43M 25G 1% /run /dev/mapper/almalinux00-root 70G 7.5G 63G 11% / /dev/sda2 1014M 212M 803M 21% /boot /dev/sda1 599M 7.1M 592M 2% /boot/efi /dev/mapper/almalinux00-home 1.7T 20G 1.7T 2% /home /dev/loop0 3.2G 212K 3.1G 1% /tmp (more readable screenshot attached)0 -
Your root file system (/) only has 64 GB of available space. /var/lib/mysql lives in the root file system, so they is not enough room for that large database. Most of your spaces is allocated in /home file system. 0 -
exactly, luckily you most likely be able to resize /root by shrinking /home but I would rather get rid of /home completely and just allocate all space to / (root). Make sure full backup is done beforehand as this is a risky procedure so it is suggested to get this done by a professional if you are not tech savvy enough. 0 -
exactly, luckily you most likely be able to resize /root by shrinking /home but I would rather get rid of /home completely and just allocate all space to / (root). Make sure full backup is done beforehand as this is a risky procedure so it is suggested to get this done by a professional if you are not tech savvy enough.
Thanks guys. This was supposed to be the "standard" cpanel deployment on Raid 10. Is there any reason they would have provisioned it like this? Or was someone just lazy and dedicated all remaining space to the /home file system?0 -
I think this was done using a template. I'm not 100% sure that this would be the default partition layout if done manually from like an ISO. 0 -
Is it a VPS or dedi? Whats the host? OVH? It might be worth re-provisioning this from Almalinux template without pre-installed cPanel then and if that looks fine then installing cPanel or the resize way to go. 0 -
Is it a VPS or dedi? Whats the host? OVH? It might be worth re-provisioning this from Almalinux template without pre-installed cPanel then and if that looks fine then installing cPanel or the resize way to go.
It's kind of a hybrid between dedicated and bare metal. And we've already re-provisioned once. lol0 -
Whats the output of /etc/fstab? 0 -
Whats the output of /etc/fstab?
Permission Denied?0 -
........I would either hire somebody or open a ticket with your provider and ask them to provision the server the way you wish, preferably with all space allocated to /root and swap, thats all. I would probably be able to provide you instructions but I hate writing commands here as somebody later on just come here by google and blindly copy-paste the commands then cry that we broke his system :( 0 -
Permission Denied?
He meant: cat /etc/fstab0 -
He meant: cat /etc/fstab
Thanks. This is the output:0 -
No matter what you do, you'll have to tweak the disk to be able to handle that large database. Whether that is a reimage and start over, or a reallocation. Your host would be able to let you know if they can adjust the partitions without the need to rebuild the system. 0
Please sign in to leave a comment.
Comments
14 comments