{"id":2146,"date":"2025-10-14T16:56:40","date_gmt":"2025-10-14T13:56:40","guid":{"rendered":"https:\/\/saviorhost.com\/blog\/?p=2146"},"modified":"2025-10-14T16:57:22","modified_gmt":"2025-10-14T13:57:22","slug":"500-pleskexceptiondatabase-hatasi-sqlstate-2002-kesin-cozum-rehberi","status":"publish","type":"post","link":"https:\/\/saviorhost.com\/blog\/500-pleskexceptiondatabase-hatasi-sqlstate-2002-kesin-cozum-rehberi\/","title":{"rendered":"500 Plesk\\Exception\\Database Hatas\u0131 (SQLSTATE 2002) \u2013 Kesin \u00c7\u00f6z\u00fcm Rehberi"},"content":{"rendered":"

\u201c500 Plesk\\Exception\\Database\u201d tipik olarak Plesk\u2019in kendi veritaban\u0131na (psa<\/em>) ya da alttaki MySQL\/MariaDB\/Plesk SQL Server hizmetine ba\u011flanamamas\u0131yla olu\u015fur. Nedeni \u00e7o\u011funlukla servis kapal\u0131, disk dolu, socket\/port hatas\u0131, bozulmu\u015f psa<\/em> tablolar\u0131 veya ge\u00e7ici \u201crepair\u201d i\u015flemleridir. Plesk\u2019in resmi Repair Utility<\/strong> arac\u0131 \u00e7o\u011fu olay\u0131 tek komutla tespit ve onar\u0131r. docs.plesk.com<\/span>+1<\/span><\/span><\/span><\/a><\/span><\/span><\/p>\n

\n

\u0130lk Te\u015fhis: G\u00fcnl\u00fckleri (Log) ve Servis Durumunu Kontrol Edin<\/h2>\n
    \n
  1. \n

    Plesk aray\u00fcz\u00fc eri\u015filemiyorsa<\/strong>, sunucuya SSH ile ba\u011flan\u0131n ve MariaDB\/MySQL durumuna bak\u0131n:<\/p>\n

    \n
    \n
    \n
    <\/div>\n<\/div>\n<\/div>\n
    systemctl status mariadb
    \njournalctl -u mariadb -n 200 --no-pager
    \n<\/code><\/div>\n<\/div>\n

    (Windows\u2019ta Olay G\u00f6r\u00fcnt\u00fcleyici ve Plesk SQL Server servisini kontrol edin.) support.plesk.com<\/span><\/span><\/span><\/a><\/span><\/span><\/p>\n<\/li>\n

  2. \n

    Ge\u00e7mi\u015f boot loglar\u0131n\u0131<\/strong> inceleyin (\u00f6zellikle beklenmedik yeniden ba\u015flatma sonras\u0131):<\/p>\n

    \n
    \n
    \n
    <\/div>\n<\/div>\n<\/div>\n
    journalctl --boot=-1 -n 5000
    \n<\/code><\/div>\n<\/div>\n

    (Forumda do\u011frulanan pratik bir yakla\u015f\u0131m.) Plesk Forum<\/span><\/span><\/span><\/a><\/span><\/span><\/p>\n<\/li>\n

  3. \n

    Disk doluluk<\/strong>:<\/p>\n

    \n
    \n
    \n
    <\/div>\n<\/div>\n<\/div>\n
    df<\/span> -h
    \ndu<\/span> -sh \/var\/lib\/mysql\/* | sort<\/span> -h
    \n<\/code><\/div>\n<\/div>\n
    \n

    H\u0131zl\u0131 Onar\u0131m: Plesk Repair Utility (\u00d6nerilen)<\/h2>\n

    \u00c7al\u0131\u015ft\u0131r\u0131n:<\/strong><\/p>\n

    \n
    \n
    \n
    <\/div>\n<\/div>\n<\/div>\n
    plesk repair db
    \n<\/code><\/div>\n<\/div>\n

    Bu komut Plesk veritaban\u0131 tutarl\u0131l\u0131\u011f\u0131n\u0131 denetler, gerekirse otomatik yedek (dump) al\u0131r ve onar\u0131m dener. Linux\/Windows\u2019ta kullan\u0131labilir. Ek se\u00e7enek gerekmez. docs.plesk.com<\/span>+2<\/span><\/span>plesk.com<\/span>+2<\/span><\/span><\/span><\/a><\/span><\/span><\/p>\n

    \n

    Not \u2013 Ge\u00e7ici 500 Hatas\u0131:<\/strong> plesk repair installation<\/code> gibi geni\u015f onar\u0131m \u00e7al\u0131\u015f\u0131rken Plesk k\u0131sa s\u00fcre eri\u015filemez ve 500 hatas\u0131 g\u00f6r\u00fclebilir; bu, bilinen bir Repair Kit davran\u0131\u015f\u0131\/bug\u2019\u0131d\u0131r ve i\u015flem bitince kaybolur. support.plesk.com<\/span><\/span><\/span><\/a><\/span><\/span><\/p>\n<\/blockquote>\n

    \n

    Senaryo A: SQLSTATE[HY000][2002] Connection refused<\/strong><\/h2>\n

    Belirti:<\/strong><\/p>\n

    \n
    \n
    \n
    <\/div>\n<\/div>\n<\/div>\n
    DB query failed: \"SET sql_mode = ''\"
    \nError: SQLSTATE<\/span>[HY000][2002<\/span>] Connection<\/span> refused
    \n<\/code><\/div>\n<\/div>\n

    Neden:<\/strong> MariaDB\/MySQL servisinin down olmas\u0131 veya ba\u015flayamamas\u0131.
    \u00c7\u00f6z\u00fcm:<\/strong><\/p>\n

      \n
    1. \n

      Servisi ba\u015flat\u0131n\/yeniden ba\u015flat\u0131n:<\/p>\n

      \n
      \n
      \n
      <\/div>\n<\/div>\n<\/div>\n
      systemctl restart mariadb
      \nsystemctl status mariadb
      \n<\/code><\/div>\n<\/div>\n<\/li>\n
    2. \n

      Loglardaki temel sebebi giderin (\u00f6r. yap\u0131land\u0131rma, port \u00e7ak\u0131\u015fmas\u0131, izinler).<\/p>\n<\/li>\n

    3. \n

      Ard\u0131ndan plesk repair db<\/code> \u00e7al\u0131\u015ft\u0131r\u0131n.
      Kaynak ve ayn\u0131 hatan\u0131n resmi analizi: support.plesk.com<\/span><\/span><\/span><\/a><\/span><\/span><\/p>\n<\/li>\n<\/ol>\n

      \n

      Senaryo B: SQLSTATE[HY000][2002] No such file or directory<\/strong><\/h2>\n

      Belirti:<\/strong><\/p>\n

      \n
      \n
      \n
      <\/div>\n<\/div>\n<\/div>\n
      ...<\/span> [2002<\/span><\/span>] No such file or<\/span> directory
      \n<\/code><\/div>\n<\/div>\n

      Neden:<\/strong> MySQL socket dosyas\u0131 yok\/yanl\u0131\u015f yol, servis kapal\u0131 veya disk ta\u015fmas\u0131 sonucunda soket olu\u015fmuyor.
      \u00c7\u00f6z\u00fcm:<\/strong><\/p>\n

        \n
      1. \n

        Servisi yeniden ba\u015flat\u0131n; \/etc\/my.cnf<\/code> i\u00e7indeki socket<\/code> yolunu ve \/var\/lib\/mysql\/mysql.sock<\/code> varl\u0131\u011f\u0131n\u0131 do\u011frulay\u0131n.<\/p>\n<\/li>\n

      2. \n

        Disk doluysa alan a\u00e7\u0131n (bkz. Senaryo D).<\/p>\n<\/li>\n

      3. \n

        Gerekirse \/tmp<\/code> izinlerini ve AppArmor\/SELinux k\u0131s\u0131tlar\u0131n\u0131 kontrol edin.
        Do\u011frulama: Plesk Forum<\/span>+1<\/span><\/span><\/span><\/a><\/span><\/span><\/p>\n<\/li>\n<\/ol>\n

        \n

        Senaryo C: Plesk SQL Server Error 1053 (Windows) \/ Port \u00c7ak\u0131\u015fmas\u0131<\/strong><\/h2>\n

        Belirti:<\/strong> 1053; Event Viewer\u2019da \u201cBind on TCP\/IP port 3306\u2026 already in use\u201d.
        Neden:<\/strong> Plesk SQL Server servis yap\u0131land\u0131rmas\u0131 hatal\u0131 ya da 3306 portunu ba\u015fka bir mysqld kullan\u0131yor.
        \u00c7\u00f6z\u00fcm:<\/strong><\/p>\n

          \n
        1. \n

          Hizmetin \u201cPath to executable\u201d ayar\u0131n\u0131 do\u011fru my.ini bilgisiyle g\u00fcncelleyin.<\/p>\n<\/li>\n

        2. \n

          Port \u00e7ak\u0131\u015fmas\u0131 varsa ba\u011flanan di\u011fer MySQL \u00f6rne\u011fini kapat\u0131n\/portu de\u011fi\u015ftirin.
          Kaynak:           support.plesk.com<\/span><\/span><\/span><\/a><\/span><\/span><\/p>\n<\/li>\n<\/ol>\n

          \n

          Senaryo D: Disk Dolu (No space left on device)<\/strong><\/h2>\n

          Belirti:<\/strong> MySQL ba\u015flat\u0131lam\u0131yor; g\u00fcnl\u00fcklerde \u201cNo space left on device\u201d.
          \u00c7\u00f6z\u00fcm:<\/strong><\/p>\n

            \n
          1. \n

            df -h<\/code> ile dolu diskleri tespit edin, gereksiz log\/backuplar\u0131 temizleyin.<\/p>\n<\/li>\n

          2. \n

            MariaDB\u2019yi yeniden ba\u015flat\u0131n, ard\u0131ndan plesk repair db<\/code>.
            Resmi Plesk \u00e7\u00f6z\u00fcm makalesi:             Plesk Forum<\/span><\/span><\/span><\/a><\/span><\/span><\/p>\n<\/li>\n<\/ol>\n

            \n

            Senaryo E: Bozulmu\u015f Plesk Sistem Veritabanlar\u0131 (psa<\/em> vb.)<\/strong><\/h2>\n

            Belirti:<\/strong> psa<\/em> tablolar\u0131 \u201ccrashed\u201d\/tutars\u0131z; Plesk aray\u00fcz\u00fc 500 veriyor.
            \u00c7\u00f6z\u00fcm (\u00f6nce yedek al\u0131n):<\/strong><\/p>\n

              \n
            1. \n

              Repair Utility<\/strong>:<\/p>\n

              \n
              \n
              \n
              <\/div>\n<\/div>\n<\/div>\n
              plesk repair db
              \n<\/code><\/div>\n<\/div>\n<\/li>\n
            2. \n

              Gerekirse g\u00fcnl\u00fck yedekten geri y\u00fckleme<\/strong> (Plesk\u2019in otomatik dump\u2019lar\u0131):
              Plesk g\u00fcnl\u00fck\/pre-upgrade dump\u2019tan psa<\/em>\u2019y\u0131 geri y\u00fckleme ad\u0131mlar\u0131 resmi rehberde anlat\u0131l\u0131r. (\u00d6rnek komutlar ve de\u011fi\u015ftirme notlar\u0131 rehberde mevcut.)               plesk.com<\/span><\/span><\/span><\/a><\/span><\/span><\/p>\n<\/li>\n

            3. \n

              Alternatif CLI restore notlar\u0131 (ilerseviye): dump\u2019tan apsc<\/em>\/psa<\/em> geri y\u00fckleme pratikleri. (Topluluk deneyimi; dikkatle uygulay\u0131n.) The WP Guru<\/span><\/span><\/span><\/a><\/span><\/span><\/p>\n<\/li>\n<\/ol>\n

              \n

              Uyar\u0131:<\/strong> Manuel mysqlcheck --repair<\/code> veya innodb_force_recovery<\/code> gibi ad\u0131mlar verinizi riske sokabilir; \u00f6nce resmi repair<\/strong> ve resmi geri y\u00fckleme<\/strong> yollar\u0131n\u0131 deneyin. docs.plesk.com<\/span>+1<\/span><\/span><\/span><\/a><\/span><\/span><\/p>\n<\/blockquote>\n

              \n

              Senaryo F: Ge\u00e7ici \u2014 Repair \u00c7al\u0131\u015f\u0131rken Plesk \u0130naccessible<\/strong><\/h2>\n

              Belirti:<\/strong> plesk repair installation<\/code> s\u0131ras\u0131nda panel 500 hatas\u0131 d\u00f6ner.
              \u00c7\u00f6z\u00fcm:<\/strong> \u0130\u015flem tamamlan\u0131nca d\u00fczelir; bilinen bir davran\u0131\u015f\/bug kayd\u0131 mevcuttur.               support.plesk.com<\/span><\/span><\/span><\/a><\/span><\/span><\/p>\n

              \n

              Senaryo G: Eksik\/Silinmi\u015f Dosya veya Antivir\u00fcs Karantinas\u0131 (Windows)<\/strong><\/h2>\n

              Belirti:<\/strong> \u201c500 Internal Server Error \u2013 Failed opening required \u2026\u201d
              \u00c7\u00f6z\u00fcm:<\/strong> Eksik dosyay\u0131 ayn\u0131 s\u00fcr\u00fcm \u00e7al\u0131\u015fan bir Plesk\u2019ten geri getirin; antivir\u00fcse %plesk_dir%<\/strong> i\u00e7in istisna ekleyin.               support.plesk.com<\/span><\/span><\/span><\/a><\/span><\/span><\/p>\n

              \n

              Ad\u0131m Ad\u0131m Standart D\u00fczeltme Ak\u0131\u015f\u0131 (\u00d6nerilen Playbook)<\/h2>\n
                \n
              1. \n

                Servisleri kontrol et:<\/strong> systemctl status mariadb<\/code> \u2192 hata varsa log oku. support.plesk.com<\/span><\/span><\/span><\/a><\/span><\/span><\/p>\n<\/li>\n

              2. \n

                Disk alan\u0131:<\/strong> df -h<\/code> \u2192 doluysa temizle. Plesk Forum<\/span><\/span><\/span><\/a><\/span><\/span><\/p>\n<\/li>\n

              3. \n

                Repair Utility \u00e7al\u0131\u015ft\u0131r:<\/strong> plesk repair db<\/code> (Linux\/Windows). docs.plesk.com<\/span>+1<\/span><\/span><\/span><\/a><\/span><\/span><\/p>\n<\/li>\n

              4. \n

                Socket\/Port do\u011frula:<\/strong> mysql.sock<\/code> yolu ve 3306 \u00e7ak\u0131\u015fmas\u0131. (Windows\u2019ta hizmet yap\u0131land\u0131rmas\u0131.) support.plesk.com<\/span>+1<\/span><\/span><\/span><\/a><\/span><\/span><\/p>\n<\/li>\n

              5. \n

                H\u00e2l\u00e2 sorun var m\u0131?<\/strong> Plesk sistem DB\u2019lerini<\/strong> dump\u2019tan geri y\u00fckle (\u00f6rn. psa<\/em>). plesk.com<\/span><\/span><\/span><\/a><\/span><\/span><\/p>\n<\/li>\n

              6. \n

                Ge\u00e7ici 500 mi?<\/strong> Repair esnas\u0131nda olu\u015ftuysa g\u00f6rmezden gelebilirsiniz; i\u015flem bitince panel geri gelir. support.plesk.com<\/span><\/span><\/span><\/a><\/span><\/span><\/p>\n<\/li>\n<\/ol>\n

                \n

                SSS<\/h2>\n

                Bu hata neden \u201cgenel\u201d g\u00f6z\u00fck\u00fcyor?<\/strong>
                \u201c500 Plesk\\Exception\\Database\u201d \u015femsiye bir hatad\u0131r; somut sebep loglarda \u00e7\u0131kar.                 Plesk Forum<\/span><\/span><\/span><\/a><\/span><\/span><\/p>\n

                Plesk\u2019te veritaban\u0131n\u0131 GUI\u2019den de onarabilir miyim?<\/strong>
                Evet; \u201cWebsites & Domains \u2192 Databases \u2192 Check and Repair\u201d. (S\u00fcr\u00fcm\u00fcn\u00fcze g\u00f6re g\u00f6r\u00fcn\u00fcm de\u011fi\u015febilir.)                 lets-rebuild.com<\/span><\/span><\/span><\/a><\/span><\/span><\/p>\n

                Repair s\u0131ras\u0131nda 500 g\u00f6r\u00fcrsem?<\/strong>
                Bu beklenen bir davran\u0131\u015f olabilir; repair bitince panel geri gelir (EXTPLESK-3451).                 support.plesk.com<\/span><\/span><\/span><\/a><\/span><\/span><\/p>\n

                \n

                \u0130leri D\u00fczey Notlar ve \u0130pu\u00e7lar\u0131<\/h2>\n

    Diskin dolmas\u0131, MySQL\u2019in ba\u015flamas\u0131n\u0131 engeller ve 500 hatas\u0131na yol a\u00e7ar. Plesk Forum<\/span><\/span><\/span><\/a><\/span><\/span><\/p>\n<\/li>\n<\/ol>\n