MariaDB tidak mau restart (restart failed)

Discussion in 'VPS (Virtual Private Server)' started by Justin B, 25 Jun 2016.

Tags:
Thread Status:
Not open for further replies.
  1. Justin B

    Justin B Beginner 2.0

    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    1
    Mohon bantuan Tuan-2 mastah...

    Beberapa hari ini WP ngga bisa konek ke database. Cek di VPS, ternyata database off. Database di restart (via panel Webuzo) bisa UP lagi tapi langsung DOWN.

    Coba via SSH, systemctl status mariadb.service bisa UP sebentar langsung DOWN lagi.

    Ini errornya:

    ● mariadb.service - MariaDB database server
    Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
    Drop-In: /etc/systemd/system/mariadb.service.d
    └─migrated-from-my.cnf-settings.conf
    Active: failed (Result: exit-code) since Sat 2016-06-25 12:52:34 NOVT; 5min ago
    Process: 11768 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER (code=exited, status=1/FAILURE)
    Main PID: 11768 (code=exited, status=1/FAILURE)
    Status: "InnoDB: Error: Ending processing because of a corrupt database page."
    CGroup: /system.slice/mariadb.service

    Jun 25 12:52:34 xx mysqld[11768]: /usr/sbin/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x64)[0x7fddda1f1044]
    Jun 25 12:52:34 xx mysqld[11768]: handler/ha_innodb.cc:4386(innobase_init)[0x7fddda0822e5]
    Jun 25 12:52:34 xx mysqld[11768]: sql/handler.cc:513(ha_initialize_handlerton(st_plugin_int*))[0x7fddda083c5a]
    Jun 25 12:52:34 xx mysqld[11768]: sql/sql_plugin.cc:1408(plugin_initialize)[0x7fddd9fdccba]
    Jun 25 12:52:34 xx mysqld[11768]: sql/mysqld.cc:5205(init_server_components)[0x7fddd9fe0ed3]
    Jun 25 12:52:34 xx mysqld[11768]: /lib64/libc.so.6(__libc_start_main+0xf5)[0x7fddd7b52b15]
    Jun 25 12:52:34 xx systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
    Jun 25 12:52:34 xx systemd[1]: Failed to start MariaDB database server.
    Jun 25 12:52:34 xx systemd[1]: Unit mariadb.service entered failed state.
    Jun 25 12:52:34 xx systemd[1]: mariadb.service failed.


    Config VPS: 2CPU, 2GB RAM, CentOS7, PHP7, Apache2, nginx, MariaDB10.1 + Webuzo

    Googling2 bbrp hari, coba berbagai saran di forum2, akhirnya saya reinstall MariaDB dari awal, hasilnya masih sama: failed

    Dugaan terakhir saya di "InnoDB: Error: Ending processing because of a corrupt database page"

    Apa langkah terbaik untuk betulin InnoDB?

    Terima kasih Tuan-2
     
  2. daiserver

    daiserver Apprentice 1.0

    Messages:
    370
    Likes Received:
    63
    Trophy Points:
    28
    Up down Up down bisa jadi webnya trafiknya tinggi kontennya tinggi database ga kuat nampung akhirnya down. Soalnya saya kasusnya seperti ini.
    Saya akalin dulu menggunakan crown tiap 5 menit, baru memutuskan untuk pindah resource ke lebih tinggi.

    itu web visitor berapa dan plugin yang digunain apa aja ?
     
    Justin B likes this.
  3. FluidaWeb

    FluidaWeb Expert 1.0

    Messages:
    648
    Likes Received:
    86
    Trophy Points:
    28
    Pengalaman pakai webuzo ada service mati biasanya kehabisan ram atau cpu
     
    Justin B likes this.
  4. Justin B

    Justin B Beginner 2.0

    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    1
    RAM 2GB masak ngga cukup? Isinya cuma 1 web WP

    Panel apa yg enteng untuk RAM 2GB?
     
  5. Hosting Bagus

    Hosting Bagus Apprentice 1.0

    Messages:
    210
    Likes Received:
    16
    Trophy Points:
    18
    coba di upgrade resourcenya tuan, atau coba restart vpsnya, shutdown now -r
     
  6. medanwebhost

    medanwebhost Poster 2.0

    Messages:
    112
    Likes Received:
    8
    Trophy Points:
    18
    VestaCP om
     
    Justin B likes this.
  7. Justin B

    Justin B Beginner 2.0

    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    1
    Yg urgent diupgrade RAM atau CPU?

    Restart VPS juga sudah
     
  8. Justin B

    Justin B Beginner 2.0

    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    1
    Terima kasih Tuan-2 inputnya

    Skrg, bagaimana best practice betulin innoDB Error?
     
  9. Hosting Bagus

    Hosting Bagus Apprentice 1.0

    Messages:
    210
    Likes Received:
    16
    Trophy Points:
    18
    RAMnya dulu tuan, best practice coba dari whmnya tuan ke easyapache, di rebuild saja tuan. Pake last previous config. Semoga lancar :D
     
  10. pangeran1995

    pangeran1995 Hosting Guru

    Messages:
    1,352
    Likes Received:
    105
    Trophy Points:
    63
    berbicara "masa gak cukup"
    ya giaman beratnya website tentunya dan optimizenya seperti apa :D
     
Loading...
Thread Status:
Not open for further replies.

Share This Page

Loading...