{"id":3401,"date":"2022-01-04T22:45:33","date_gmt":"2022-01-04T17:15:33","guid":{"rendered":"https:\/\/www.24x7serversupport.com\/blog\/?p=3401"},"modified":"2023-01-23T16:19:04","modified_gmt":"2023-01-23T10:49:04","slug":"mysql-fails-to-start-when-a-plesk-server-lacks-disk-space-sqlstatehy000-no-space-left-on-device-500-pleskexceptiondatabase-2","status":"publish","type":"post","link":"https:\/\/www.24x7serversupport.com\/blog\/mysql-fails-to-start-when-a-plesk-server-lacks-disk-space-sqlstatehy000-no-space-left-on-device-500-pleskexceptiondatabase-2\/","title":{"rendered":"MySQL fails to start when a Plesk server lacks disk space: SQLSTATE[HY000] No space left on device 500 Plesk\\Exception\\Database"},"content":{"rendered":"\n<ol class=\"wp-block-list\">\n<li>Connect to a Plesk server via&nbsp;SSH&nbsp;as root.<\/li>\n\n\n\n<li>Delete temporary files that are older than&nbsp;<strong>14<\/strong>&nbsp;days:#&nbsp;find \/tmp -type f -mtime +<strong>14<\/strong>&nbsp;-exec rm {} \\;<br># find \/var\/tmp -type f -mtime +<strong>14<\/strong>&nbsp;-exec rm {} \\;as well as Plesk temporary files:#&nbsp;rm -rf \/usr\/local\/psa\/PMM\/tmp\/* \/usr\/local\/psa\/tmp\/*<\/li>\n\n\n\n<li>Check the size and clean package cache (cache of previously downloaded packages) with the following command for Ubuntu:#&nbsp;du -sh \/var\/cache\/apt\/<br># sudo apt-get cleanand for Centos:#&nbsp;yum clean all<\/li>\n\n\n\n<li>Next, if disk space is still shows&nbsp;<strong>100%<\/strong>&nbsp;you may want to remove the oldest Plesk backup file. First get the list of backup files by copy\/pasting below command:#&nbsp;\/usr\/local\/psa\/admin\/bin\/pmm-ras &#8211;get-dump-list &#8211;type=server | grep &#8216;message&#8217; | grep -v [0-9]_[0-9]<br>&lt;message&gt;<strong>backup_info_00000.xm<\/strong>l: &lt;\/message&gt;<br>&lt;message&gt;<strong>backup_info_00000.xml<\/strong>: &lt;\/message&gt;If you have just one backup, it is better not to remove it. If you have several then the first one in the output is the oldest one. Remove it using its name:#&nbsp;\/usr\/local\/psa\/admin\/bin\/pmm-ras &#8211;verbose &#8211;debug &#8211;delete-dump &#8211;dump-specification=<strong>backup_info_00000.xm<\/strong>l &#8211;session-path=\/var\/log\/plesk\/PMM<\/li>\n\n\n\n<li>Restart services:#&nbsp;service psa restart<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":3484,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[1],"tags":[],"class_list":["post-3401","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"jetpack_publicize_connections":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MySQL fails to start when a Plesk server lacks disk space: SQLSTATE[HY000] No space left on device 500 Plesk\\Exception\\Database | 24x7serversupport Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.24x7serversupport.com\/blog\/mysql-fails-to-start-when-a-plesk-server-lacks-disk-space-sqlstatehy000-no-space-left-on-device-500-pleskexceptiondatabase-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL fails to start when a Plesk server lacks disk space: SQLSTATE[HY000] No space left on device 500 Plesk\\Exception\\Database | 24x7serversupport Blog\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.24x7serversupport.com\/blog\/mysql-fails-to-start-when-a-plesk-server-lacks-disk-space-sqlstatehy000-no-space-left-on-device-500-pleskexceptiondatabase-2\/\" \/>\n<meta property=\"og:site_name\" content=\"24x7serversupport Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-01-04T17:15:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-01-23T10:49:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2022\/01\/execptional-data-base.png\" \/>\n\t<meta property=\"og:image:width\" content=\"268\" \/>\n\t<meta property=\"og:image:height\" content=\"100\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"24x7support\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@24x7serversuppo\" \/>\n<meta name=\"twitter:site\" content=\"@24x7serversuppo\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"24x7support\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/mysql-fails-to-start-when-a-plesk-server-lacks-disk-space-sqlstatehy000-no-space-left-on-device-500-pleskexceptiondatabase-2\/\",\"url\":\"https:\/\/www.24x7serversupport.com\/blog\/mysql-fails-to-start-when-a-plesk-server-lacks-disk-space-sqlstatehy000-no-space-left-on-device-500-pleskexceptiondatabase-2\/\",\"name\":\"MySQL fails to start when a Plesk server lacks disk space: SQLSTATE[HY000] No space left on device 500 Plesk\\\\Exception\\\\Database | 24x7serversupport Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/mysql-fails-to-start-when-a-plesk-server-lacks-disk-space-sqlstatehy000-no-space-left-on-device-500-pleskexceptiondatabase-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/mysql-fails-to-start-when-a-plesk-server-lacks-disk-space-sqlstatehy000-no-space-left-on-device-500-pleskexceptiondatabase-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i0.wp.com\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2022\/01\/execptional-data-base.png?fit=268%2C100&ssl=1\",\"datePublished\":\"2022-01-04T17:15:33+00:00\",\"dateModified\":\"2023-01-23T10:49:04+00:00\",\"author\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/mysql-fails-to-start-when-a-plesk-server-lacks-disk-space-sqlstatehy000-no-space-left-on-device-500-pleskexceptiondatabase-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.24x7serversupport.com\/blog\/mysql-fails-to-start-when-a-plesk-server-lacks-disk-space-sqlstatehy000-no-space-left-on-device-500-pleskexceptiondatabase-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/mysql-fails-to-start-when-a-plesk-server-lacks-disk-space-sqlstatehy000-no-space-left-on-device-500-pleskexceptiondatabase-2\/#primaryimage\",\"url\":\"https:\/\/i0.wp.com\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2022\/01\/execptional-data-base.png?fit=268%2C100&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2022\/01\/execptional-data-base.png?fit=268%2C100&ssl=1\",\"width\":268,\"height\":100,\"caption\":\"MySQL fails to start when a Plesk server lacks disk space: SQLSTATE[HY000] No space left on device 500 PleskExceptionDatabase\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/mysql-fails-to-start-when-a-plesk-server-lacks-disk-space-sqlstatehy000-no-space-left-on-device-500-pleskexceptiondatabase-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.24x7serversupport.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL fails to start when a Plesk server lacks disk space: SQLSTATE[HY000] No space left on device 500 Plesk\\\\Exception\\\\Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#website\",\"url\":\"https:\/\/www.24x7serversupport.com\/blog\/\",\"name\":\"24x7serversupport Blog\",\"description\":\"Linux | CPanel | WHM | webhosting| Plesk | DirectAdmin | CentOs | Debian | Ubuntu Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.24x7serversupport.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401\",\"name\":\"24x7support\",\"url\":\"https:\/\/www.24x7serversupport.com\/blog\/author\/24x7support\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL fails to start when a Plesk server lacks disk space: SQLSTATE[HY000] No space left on device 500 Plesk\\Exception\\Database | 24x7serversupport Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.24x7serversupport.com\/blog\/mysql-fails-to-start-when-a-plesk-server-lacks-disk-space-sqlstatehy000-no-space-left-on-device-500-pleskexceptiondatabase-2\/","og_locale":"en_US","og_type":"article","og_title":"MySQL fails to start when a Plesk server lacks disk space: SQLSTATE[HY000] No space left on device 500 Plesk\\Exception\\Database | 24x7serversupport Blog","og_url":"https:\/\/www.24x7serversupport.com\/blog\/mysql-fails-to-start-when-a-plesk-server-lacks-disk-space-sqlstatehy000-no-space-left-on-device-500-pleskexceptiondatabase-2\/","og_site_name":"24x7serversupport Blog","article_published_time":"2022-01-04T17:15:33+00:00","article_modified_time":"2023-01-23T10:49:04+00:00","og_image":[{"width":268,"height":100,"url":"https:\/\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2022\/01\/execptional-data-base.png","type":"image\/png"}],"author":"24x7support","twitter_card":"summary_large_image","twitter_creator":"@24x7serversuppo","twitter_site":"@24x7serversuppo","twitter_misc":{"Written by":"24x7support","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.24x7serversupport.com\/blog\/mysql-fails-to-start-when-a-plesk-server-lacks-disk-space-sqlstatehy000-no-space-left-on-device-500-pleskexceptiondatabase-2\/","url":"https:\/\/www.24x7serversupport.com\/blog\/mysql-fails-to-start-when-a-plesk-server-lacks-disk-space-sqlstatehy000-no-space-left-on-device-500-pleskexceptiondatabase-2\/","name":"MySQL fails to start when a Plesk server lacks disk space: SQLSTATE[HY000] No space left on device 500 Plesk\\Exception\\Database | 24x7serversupport Blog","isPartOf":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/mysql-fails-to-start-when-a-plesk-server-lacks-disk-space-sqlstatehy000-no-space-left-on-device-500-pleskexceptiondatabase-2\/#primaryimage"},"image":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/mysql-fails-to-start-when-a-plesk-server-lacks-disk-space-sqlstatehy000-no-space-left-on-device-500-pleskexceptiondatabase-2\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2022\/01\/execptional-data-base.png?fit=268%2C100&ssl=1","datePublished":"2022-01-04T17:15:33+00:00","dateModified":"2023-01-23T10:49:04+00:00","author":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401"},"breadcrumb":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/mysql-fails-to-start-when-a-plesk-server-lacks-disk-space-sqlstatehy000-no-space-left-on-device-500-pleskexceptiondatabase-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.24x7serversupport.com\/blog\/mysql-fails-to-start-when-a-plesk-server-lacks-disk-space-sqlstatehy000-no-space-left-on-device-500-pleskexceptiondatabase-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.24x7serversupport.com\/blog\/mysql-fails-to-start-when-a-plesk-server-lacks-disk-space-sqlstatehy000-no-space-left-on-device-500-pleskexceptiondatabase-2\/#primaryimage","url":"https:\/\/i0.wp.com\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2022\/01\/execptional-data-base.png?fit=268%2C100&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2022\/01\/execptional-data-base.png?fit=268%2C100&ssl=1","width":268,"height":100,"caption":"MySQL fails to start when a Plesk server lacks disk space: SQLSTATE[HY000] No space left on device 500 PleskExceptionDatabase"},{"@type":"BreadcrumbList","@id":"https:\/\/www.24x7serversupport.com\/blog\/mysql-fails-to-start-when-a-plesk-server-lacks-disk-space-sqlstatehy000-no-space-left-on-device-500-pleskexceptiondatabase-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.24x7serversupport.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MySQL fails to start when a Plesk server lacks disk space: SQLSTATE[HY000] No space left on device 500 Plesk\\Exception\\Database"}]},{"@type":"WebSite","@id":"https:\/\/www.24x7serversupport.com\/blog\/#website","url":"https:\/\/www.24x7serversupport.com\/blog\/","name":"24x7serversupport Blog","description":"Linux | CPanel | WHM | webhosting| Plesk | DirectAdmin | CentOs | Debian | Ubuntu Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.24x7serversupport.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401","name":"24x7support","url":"https:\/\/www.24x7serversupport.com\/blog\/author\/24x7support\/"}]}},"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2022\/01\/execptional-data-base.png?fit=268%2C100&ssl=1","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts\/3401","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/comments?post=3401"}],"version-history":[{"count":3,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts\/3401\/revisions"}],"predecessor-version":[{"id":3485,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts\/3401\/revisions\/3485"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/media\/3484"}],"wp:attachment":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/media?parent=3401"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/categories?post=3401"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/tags?post=3401"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}