[Ask]ERROR! MySQL server PID file could not be found!

Discussion in 'VPS (Virtual Private Server)' started by T36o3h, 26 Aug 2015.

Thread Status:
Not open for further replies.
  1. T36o3h

    T36o3h Poster 1.0

    Messages:
    99
    Likes Received:
    2
    Trophy Points:
    8
    Aku baru restart mysql dan muncul ERROR! MySQL server PID file could not be found! di lognya kenapa ya ??
    Aku pake centos dan cpanel ...
    Tolong dibantu ya para master sekalian
     
  2. masiqbal

    masiqbal Expert 2.0

    Messages:
    865
    Likes Received:
    249
    Trophy Points:
    43
    Coba cek apa yang terjadi di: /var/lib/mysql/<nama hostname server>.err
     
  3. T36o3h

    T36o3h Poster 1.0

    Messages:
    99
    Likes Received:
    2
    Trophy Points:
    8
    InnoDB: The log sequence number in ibdata files does not match
    InnoDB: the log sequence number in the ib_logfiles!
    141124 6:06:47 InnoDB: Database was not shut down normally!
    InnoDB: Starting crash recovery.
    InnoDB: Reading tablespace information from the .ibd files...
    InnoDB: Restoring possible half-written data pages from the doublewrite
    InnoDB: buffer...
    141124 6:06:50 InnoDB: Waiting for the background threads to start
    141124 6:06:51 InnoDB: 5.5.40 started; log sequence number 362324147
    141124 6:06:51 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    141124 06:06:46 mysqld_safe Starting mysqld daemon with databases from /var/lib$
    141124 6:06:46 [Note] Plugin 'FEDERATED' is disabled.
    141124 6:06:47 InnoDB: The InnoDB memory heap is disabled
    141124 6:06:47 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    141124 6:06:47 InnoDB: Compressed tables use zlib 1.2.3
    141124 6:06:47 InnoDB: Using Linux native AIO
    141124 6:06:47 InnoDB: Initializing buffer pool, size = 128.0M
    141124 6:06:47 InnoDB: Completed initialization of buffer pool
    141124 6:06:47 InnoDB: highest supported file format is Barracuda.
    itu hasilnya ...
     
  4. masiqbal

    masiqbal Expert 2.0

    Messages:
    865
    Likes Received:
    249
    Trophy Points:
    43
    Cuman itu doang? Coba cek proses mysql seperti apa? Apakah di situ ketahuan pid file-nya di mana lokasinya. biasanya di --pid-file=sebuah file

    ps aux|grep mysql

    Nah, coba cek pid tersebut ada apa tidak? Kalau ada apakah ownersihp dan permissionnya sudah benar.
     
  5. T36o3h

    T36o3h Poster 1.0

    Messages:
    99
    Likes Received:
    2
    Trophy Points:
    8
    root 21786 0.4 0.0 9476 1652 ? S 13:53 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/ix.balihostingmurah.com.pid
    mysql 28002 14.0 2.4 384532 45196 ? Sl 13:57 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/ix.balihostingmurah.com.err --pid-file=/var/lib/mysql/ix.balihostingmurah.com.pid
    root 28020 0.0 0.0 6440 708 pts/0 S+ 13:57 0:00 grep mysql
     
  6. masiqbal

    masiqbal Expert 2.0

    Messages:
    865
    Likes Received:
    249
    Trophy Points:
    43
    coba:

    ls -l /var/lib/mysql/ix.balihostingmurah.com.pid

    Harusnya dapat response seperti ini:

    -rw-rw----. 1 mysql mysql 5 Aug 24 12:27 /var/lib/mysql/ix.balihostingmurah.com.pid
     
  7. T36o3h

    T36o3h Poster 1.0

    Messages:
    99
    Likes Received:
    2
    Trophy Points:
    8
    /bin/ls: cannot access /var/lib/mysql/ix.balihostingmurah.com.pid: No such file or directory
     
  8. masiqbal

    masiqbal Expert 2.0

    Messages:
    865
    Likes Received:
    249
    Trophy Points:
    43
    Nah berarti pid file gak ada ya? Atau Anda login bukan sebagai root?
    Kalau pid file tidak ada, bisa dibuat dengan cara begini:


    touch /var/lib/mysql/ix.balihostingmurah.com.pid
    chown mysql:mysql /var/lib/mysql/ix.balihostingmurah.com.pid
     
  9. T36o3h

    T36o3h Poster 1.0

    Messages:
    99
    Likes Received:
    2
    Trophy Points:
    8
    saya masuk pake root
    sudah saya cb hasilnya :
    chown: cannot access `/var/lib/mysql/ix.balihostingmurah.com.pid': No such file or directory
     
  10. masiqbal

    masiqbal Expert 2.0

    Messages:
    865
    Likes Received:
    249
    Trophy Points:
    43
    Perintah ini dulu:

    touch /var/lib/mysql/ix.balihostingmurah.com.pid
    baru
    chown mysql:mysql /var/lib/mysql/ix.balihostingmurah.com.pid
     
Loading...
Thread Status:
Not open for further replies.

Share This Page

Loading...