{"id":834,"date":"2022-09-05T11:22:13","date_gmt":"2022-09-05T11:22:13","guid":{"rendered":"https:\/\/sunucucozumleri.com\/?p=834"},"modified":"2024-02-08T02:43:49","modified_gmt":"2024-02-07T23:43:49","slug":"sqlstatehy000-general-error-1030-got-error-28-from-storage-engine-cozumu","status":"publish","type":"post","link":"https:\/\/sunucucozumleri.com\/blog\/sqlstatehy000-general-error-1030-got-error-28-from-storage-engine-cozumu\/","title":{"rendered":"SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine \u00c7\u00f6z\u00fcm\u00fc"},"content":{"rendered":"<p>Merhabalar,<br \/>\nBu makalemizde plesk kullanan m\u00fc\u015fterilerimizi ve plesk kullanan ziyaret\u00e7ilerimizin kar\u015f\u0131la\u015fabilece\u011fi,\u00a0SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine uyar\u0131s\u0131na \u00e7\u00f6z\u00fcm \u00fcretece\u011fiz.<\/p>\n<p>\u00d6ncelikle yap\u0131lmas\u0131 gereken,<br \/>\nSunucumuza veya\u00a0<a href=\"https:\/\/sunucucozumleri.com\/sunucu\/sanal-sunucu\/\" target=\"_blank\" rel=\"noopener\"><strong>sanal sunucu<\/strong><\/a>muza root olarak terminal \u00fczerinden giri\u015f yap\u0131yoruz.<\/p>\n<pre>df -h\r\n<\/pre>\n<p>komutuyla sunucumuzda yeterli disk alan\u0131 olup olmad\u0131\u011f\u0131n\u0131 kontrol edelim. \u00d6rnek \u00e7\u0131kt\u0131 a\u015fa\u011f\u0131daki gibi olacakt\u0131r.<\/p>\n<p><img decoding=\"async\" title=\"plesk df-h\" src=\"https:\/\/image.prntscr.com\/image\/5c8a0e242335439899102c37bbde0c97.png\" alt=\"\" width=\"552\" height=\"101\"><\/p>\n<p>\u00d6rnek \u00e7\u0131kt\u0131dan da g\u00f6rebilece\u011fimiz \u00fczere disk alan\u0131n\u0131 %100 kullanmaktay\u0131z.<\/p>\n<p>\u015eimdi ise,<\/p>\n<pre>cd \/\r\ndf -h --max-depth=1\r\n<\/pre>\n<p>Komutuyla hangi klas\u00f6r\u00fcn ne kadar disk alan\u0131 kulland\u0131\u011f\u0131n\u0131 kontrol edelim.<\/p>\n<p>\u00d6rnek \u00e7\u0131kt\u0131<br \/>\n<img decoding=\"async\" src=\"https:\/\/image.prntscr.com\/image\/a1d86f8412844a0395aaedfff1217af6.png\" alt=\"\" width=\"616\" height=\"467\" title=\"\"><\/p>\n<p>Ekran g\u00f6r\u00fcnt\u00fcs\u00fcnde g\u00f6rebilece\u011fimiz \u00fczere, tmp klas\u00f6r\u00fc 14GB disk alan\u0131 kullanmaktad\u0131r. \u00a0cd \/tmp\/ yazarak ilgili klas\u00f6r\u00fcn i\u00e7erisine girelim ve ls -la komutuyla klas\u00f6r i\u00e7erisinde bulunan verileri listeleyelim.<\/p>\n<p>\u00d6rnek \u00e7\u0131kt\u0131 a\u015fa\u011f\u0131daki gibidir.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/image.prntscr.com\/image\/c422bb8965714473a6b62492c225ddf2.png\" alt=\"\" width=\"1036\" height=\"637\" title=\"\"><\/p>\n<p>Ekran g\u00f6r\u00fcnt\u00fcs\u00fcne bakt\u0131\u011f\u0131m\u0131z zaman bu i\u015flemin ayn\u0131 anda birden fazla yedek al\u0131m\u0131 ba\u015flat\u0131lm\u0131\u015f g\u00f6r\u00fcnmektedir.<\/p>\n<p>\u0130lgili dosyalar\u0131,<\/p>\n<pre>rm -rf dump*\r\n<\/pre>\n<p>komutuyla silelim.<\/p>\n<p>\u015eimdi tekrar<\/p>\n<pre>df -h\r\n<\/pre>\n<p>komutu \u00e7al\u0131\u015ft\u0131rarak sunucumuzda bo\u015f yer var m\u0131 yok mu kontrol edelim.<br \/>\n<img decoding=\"async\" src=\"https:\/\/image.prntscr.com\/image\/2c19b3763174409480a9412cf9e05368.png\" alt=\"\" width=\"548\" height=\"96\" title=\"\"><br \/>\n\u015euanda ilgili disk alan\u0131m\u0131zda 12GB daha bo\u015f alan oldu\u011fu g\u00f6r\u00fcnmektedir.<\/p>\n<p>Son olarak e\u011fer plesk disk kullan\u0131m\u0131z\u0131 g\u00fcncel olarak g\u00f6rm\u00fcyorsa, a\u015fa\u011f\u0131daki komutla plesk&#8217;i yeniden ba\u015flatabiliriz.<\/p>\n<pre><code> \/etc\/init.d\/sw-cp-server <a href=\"https:\/\/sunucucozumleri.com\/blog\/reboot-ve-restart-arasindaki-farklar-nedir\/\">restart<\/a><\/code><\/pre>\n<p>Bol trafikli g\u00fcnler dileriz.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Merhabalar, Bu makalemizde plesk kullanan m\u00fc\u015fterilerimizi ve plesk kullanan ziyaret\u00e7ilerimizin kar\u015f\u0131la\u015fabilece\u011fi,\u00a0SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine uyar\u0131s\u0131na \u00e7\u00f6z\u00fcm \u00fcretece\u011fiz. \u00d6ncelikle yap\u0131lmas\u0131 gereken, Sunucumuza veya\u00a0sanal sunucumuza root olarak terminal \u00fczerinden giri\u015f yap\u0131yoruz. df -h komutuyla sunucumuzda yeterli disk alan\u0131 olup olmad\u0131\u011f\u0131n\u0131 kontrol edelim. \u00d6rnek \u00e7\u0131kt\u0131 a\u015fa\u011f\u0131daki gibi olacakt\u0131r. \u00d6rnek \u00e7\u0131kt\u0131dan da g\u00f6rebilece\u011fimiz &hellip;<\/p>\n","protected":false},"author":1,"featured_media":1456,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-834","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux"],"acf":[],"_links":{"self":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts\/834","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/comments?post=834"}],"version-history":[{"count":0,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts\/834\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/media\/1456"}],"wp:attachment":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/media?parent=834"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/categories?post=834"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/tags?post=834"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}