[HELP] ERROR! MySQL server PID file could not be found! saat Restart mysql

Discussion in 'VPS (Virtual Private Server)' started by Wawan Setiawan, 21 Jul 2016.

Thread Status:
Not open for further replies.
  1. Wawan Setiawan

    Wawan Setiawan Beginner 2.0

    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    1
    Beberapa blog di VPS (Panel Webuzo) mengalami 'Error establishing a database connection'.

    Setelah diselidiki ternyata masalahnya ada di mysql yang eror. Di restart melalui panel webuzo nya tidak bisa dilakukan.
    Ketika melalui terminal konsol menggunakan
    perintah /etc/init.d/mysqld restart muncul pesan eror yaitu

    ERROR! MySQL server PID file could not be found!

    Mohon dibantu kawan
     

    Attached Files:

  2. IDreg.Net

    IDreg.Net Expert 2.0 Web Hosting (Company)

    Messages:
    818
    Likes Received:
    226
    Trophy Points:
    43
    cek penyebab nya disini
    Code:
    /var/lib/mysql/$hostname.err
    /var/log/mysqld.log
     
  3. antmediahost

    antmediahost Apprentice 1.0

    Messages:
    262
    Likes Received:
    41
    Trophy Points:
    28
    nah tuh sudah di kasih tahu, login ke server dan cek dikedua logs di atas...
     
  4. sentabi

    sentabi Expert 1.0

    Messages:
    681
    Likes Received:
    35
    Trophy Points:
    28
    buat file PID buat mysql nya lalu restart.
     
  5. Wawan Setiawan

    Wawan Setiawan Beginner 2.0

    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    1
    Sudah Fix ternyata tadi masalahnya karena error log domain di nginx yg berjibun, jumlahnya 34 GB lebih wkwkwkwkwkkwk... Makanya DB ente langsung error, karena disk penuh, sisa 6GB dipakai buat system dan webuzo. Saya sudah disable error lognya per domain di Nginx, tapi bisa kembali muncul kalo ente nambah domain baru di webuzo atau ganti versi PHP. Karena pengaturan virtual host nginx di Webuzo sifatnya dinamis, gak bisa dikunci.
     
  6. mustafaramadhan

    mustafaramadhan Hosting Guru

    Messages:
    3,237
    Likes Received:
    857
    Trophy Points:
    113
    Biasa karena ada config yang tidak pas.
     
  7. pluto01

    pluto01 Hosting Guru Web Hosting

    Messages:
    3,692
    Likes Received:
    757
    Trophy Points:
    113
    Error logs 34GB
    Hanya saran saja, disabled logs mungkin solusi bukan permanent namun ada bagusnya errors tersebut dianalisa dan difix agar tdk hadir lg
    yang namanya error logs itu artinya pemberitahuan ada 'sesuatu' yg kurang 'benar' dan perlu tindakan pembenaran


    CMIIW
     
  8. mustafaramadhan

    mustafaramadhan Hosting Guru

    Messages:
    3,237
    Likes Received:
    857
    Trophy Points:
    113
    Apa nama file lognya?. Jangan-jangan itu file ib_logfile* punya innodb di mysql.
     
  9. Wawan Setiawan

    Wawan Setiawan Beginner 2.0

    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    1
    lupa lagi mas mustafa :3 kemarin2 ngerjain bareng sama temen
     
Loading...
Thread Status:
Not open for further replies.

Share This Page

Loading...