Issue Plesk Panel Clone/Sync Crash Server

[MD_Broker]

I am new to the plesk setup. However, I think I am getting a handle on it. Today, we tried to clone a site from the workspace. This resulted in the server crashing. There was no response given on port 8443 and putty was unavailable.

ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[HY000]: General error: 1 Can't create/write to file '/var/tmp/#sql_48f_0.MAI' (Errcode: 28), query was: DESCRIBE `sessions`

Additionally, an exception has occurred while trying to report this error: Zend_Exception
No entry is registered for key 'translate' (Mysql.php:53)

We also tried to sync with the same result. This is a aws instance. So, our next step was to reboot. No luck there. We did a shutdown and startup to get the box back online. However, are able to recreate the issue fairly easy.

I am able to see that the directory is full:


Filesystem Size Used Avail Use% Mounted on
/dev/xvda1 20G 20G 8.9M 100% /


However, I am unable to delete anything up under it.

-bash-4.2$ ls
systemd-private-4768e57cfc7546c68a7e940a9b77a570-mariadb.service-qjBVHA
systemd-private-56ca18a2a06b494184c12d4d36046ddb-chronyd.service-HBJ1w2
systemd-private-56ca18a2a06b494184c12d4d36046ddb-dovecot.service-RQnqn4
systemd-private-56ca18a2a06b494184c12d4d36046ddb-httpd.service-uPrKP7
systemd-private-56ca18a2a06b494184c12d4d36046ddb-mariadb.service-oz3624
systemd-private-56ca18a2a06b494184c12d4d36046ddb-php-fpm.service-KJegK5
yum-centos-L0D5KC


Any ideas?

 

[MarkM]

Can you explain why you can't delete anything? Are you getting an error or ?

 

[MD_Broker]

This is where I show my newbie part. So, I was able to delete the folders under the /var/tmp. Oddly, it still throws the same error. So, I'm currently trying to see what else is full.

Filesystem Size Used Avail Use% Mounted on
/dev/xvda1 20G 20G 20K 100% /
devtmpfs 3.8G 0 3.8G 0% /dev
tmpfs 3.9G 0 3.9G 0% /dev/shm
tmpfs 3.9G 17M 3.9G 1% /run
tmpfs 3.9G 0 3.9G 0% /sys/fs/cgroup
tmpfs 783M 0 783M 0% /run/user/1000

I can see that /dev/xvda1 is full. However, I'm not sure how to get the folder sizes on the ls under that in order to find out what is killing the disk space.

Should these boxes have more than 20GB? If so, what is the recommended deployment. If not, is there a job that should be running to clean up space?

 

[MarkM]

Short term, run the following to find large files that you can purge;

Find Site Logs Over 10Mb [path corrected, backslash added before ;]
find /var/www/vhosts/*/logs/* -size +10M -exec ls -lh {} \; | awk '{print $5 , $9}'

Find Server Logs Over 10Mb [backslash added before ;]
find /var/log/* -size +10M -exec ls -lh {} \; | awk '{print $5 , $9}'

Find Mail Logs Over 10Mb:
find /var/log -name "maillog*" -size +10M -exec ls -lh {} \; | awk '{print $5 , $9}'

Long term; time for more disk space

 

[MD_Broker]

Yeah.. thinking we might need to figure out a way to move the wordpress installs to a secondary drive. They are real estate driven. So, 38k+ listings in the DB . This resides in AWS. So.. extra space not an issue Thanks again.. will keep tweaking

 

[MarkM]

You may want to consider moving "var" to a new secondary disk.

How to move var directory to a new hard drive in Plesk?

This method will also have you setup the secondary drive in an LVM which will allow you to expand it easily in the future.

You DEFINITELY want to make sure you have a backup if you try tackling this.