Are you experiencing a 500 error when trying to load your website(s), or a web panel such as Plesk or cPanel? Do you have an error Database DB query failed: SQLSTATE[HY000]?
One of the most common reasons for a 500 error is that the server has run out of disk space or inodes.
- Log into the server via SSH. Even when a web server is experiencing 500 errors, SSH and overall system available should not be compromised. If they are, you’re looking at a bigger problem.
- Check disk space for all partitions:
df -h
If any partitions have reached 99 or 100%, you can expect 500 errors as a possible affect. - Check inode limit:
df -i
If IUse% is 99 or 100%, this can be another cause for 500 errors on a website, Plesk, or cPanel. - If either limit has been reached, you will need to either remove files to free up space, add space and expand the partition, or migrate to a larger server.
On a Plesk server, you can try to access the Repair Tool to remove temporary files:https://hostname:8443/repair/
You can also list backups on a Plesk server:/usr/local/psa/admin/bin/pmm-ras --get-dump-list | grep .xml:And remove them:/usr/local/psa/admin/bin/pmm-ras --verbose --debug --delete-dump --dump-specification=backup_info_2301201234.xml --session-path=/var/log/plesk/PMM
If SSH is available, SFTP should also be available to connect with an FTP client (such as FileZilla) on port 22 to navigate and remove unwanted files.
It is always mandatory to create a backup before making any changes to any server. If you do not have a backup: Purchase the IONOS Cloud Backup, follow the installation instructions, and complete a manual backup (video).