MySQL fails to start when a Plesk server lacks disk space: SQLSTATE[HY000] No space left on device 500 Plesk\Exception\Database

Follow

Comments

11 comments

  • Avatar
    Ops-team

    Unfortunately this also did not work. Had to restart the Container this cleared it. Problem was not that the Inodes were full. It was something else 

    df -i
    Filesystem Inodes IUsed IFree IUse% Mounted on
    /dev/ploop24907p1 4587520 835456 3752064 19% /

    0
    Comment actions Permalink
  • Avatar
    Denis Bykov

    @Ops-team

    It may happen if there is not enough disk space or free inodes on a hardware node or due to some limits which are set for the container are reached.

    If the issue occurs again, try to check if failcnt value for any limit is greater than zero by running the following inside the container:

    # cat /proc/user_beancounters
    0
    Comment actions Permalink
  • Avatar
    Chaudhry Nabil Shahzad

    I resolved it by adding new virtual / portable drive and mounted it to /var/tmp

    If you need any help on partitioning formatting & mounting follow this article -->  

    https://www.digitalocean.com/community/tutorials/how-to-partition-and-format-storage-devices-in-linux

    0
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    Hello Chaudhry Nabil Shahzad,

    Thank you for sharing your experience.

    It may be useful for other Pleskians.

    0
    Comment actions Permalink
  • Avatar
    Peter Kayode

    I have the same issue but now, I can't even log in to my admin portal, can't do anything to raise a ticket. 

    0
    Comment actions Permalink
  • Avatar
    Pasitviwat

    I can't login to admin portal as well. Trying to ssh and clear but usage still at 100%

    0
    Comment actions Permalink
  • Avatar
    gabe estrada

    realice todo pero no se resuelve, sigo recibiendo el mismo error, pase de 100% a 30% de espacio utilizado

    0
    Comment actions Permalink
  • Avatar
    Christopher Mulholland

    Hi i have a 

    500: Plesk\Exception\Database
     
    Warning and unable to repair the Plesk Installation, my disk space isnt anywhere near full, i have over 70% free space.What could be causing this issue? 
     
    All my wordpress sites are fully accessible
    0
    Comment actions Permalink
  • Avatar
    Golf nitro

    @Chaudhry Nabil Shahzad  Thank you for Your shared article, https://www.digitalocean.com/community/tutorials/how-to-partition-and-format-storage-devices-in-linux. It would very help full to partition and format storage devices. Now I easily handle it.

    0
    Comment actions Permalink
  • Avatar
    Gravu Trad

    Not the only reason. I have space i have the problem. The problem is still not founded?

    0
    Comment actions Permalink
  • Avatar
    kalin clements

    We're getting this SQLSTATE error, but the "500: Plesk\Exception\Database" one and not the disk space one.  The older CentOS6 Plesk servers never had this problem, but ALL our servers we migrated to with CentOS 7 and Plesk with wordpress sites do this - generally a couple times a day.  We've been troubleshooting for MONTHS and can't find the issue and have used every practical solution we've found via research.  The servers are brand new and are less than 50% full.  We've tweaked countless settings for Apache, Nginx, SQL, swappiness, PHP, etc.  The servers were all doing this for longer periods and more often initially and over the months the new settings seem to have helped some, but it still happens.  No change has ever immediately shown to be a certain fix or help as the situation happens so randomly and inexplicably that we can't determine a cause/effect troubleshooting pattern for tracking.

    The Problem:
    The CPU load average spikes within seconds from the normal ~3 to 40-60+, and kswapd0 jumps to 100% cpu, and the server including all sites, Plesk, and SSH will be inaccessible.  Over 3-5 minutes the load average gradually calms down then everything is totally fine again for hours.

    If ANYONE can figure out a true cause/fix PLEASE let us know.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request