The MySQL server is currently offline

Discussion in 'Software Hosting dan Control Panel' started by shara nurul, 1 Mar 2016.

Thread Status:
Not open for further replies.
  1. shara nurul

    shara nurul Apprentice 1.0

    Messages:
    234
    Likes Received:
    1
    Trophy Points:
    18
    Selamat Pagi ,

    Saya punya VPS di mana ada salah satu situs teman saya tidak bisa buka database dengan pesan error sbb:

    The MySQL server is currently offline.
    The adminbin “cpmysql” in the “Cpanel” namespace call to function “DBCACHE” ended prematurely: The subprocess reported error number 2 when it ended.

    Ini terjadi hanya pada salah satu akun saja di akun lain yang masih satu VPS tidak ada masalah.

    Sudah saya restart cpanel dan sql nya masih belum bisa

    service cpanel restart
    service mysql restart

    Mohon pencerahnnya

    Regards,
    Shara Nurul
     
  2. junior riau

    junior riau Hosting Guru Web Hosting

    Messages:
    3,228
    Likes Received:
    515
    Trophy Points:
    113
    cba paste isi dari /var/lib/mysql/hostname.err
    sama isi tail -n 20 /usr/loca/cpanel/log/error_logs
     
  3. shara nurul

    shara nurul Apprentice 1.0

    Messages:
    234
    Likes Received:
    1
    Trophy Points:
    18
    ini mas error dari /var/lib/mysql/hostname.err

    2016-03-01 05:00:00 265924 [ERROR] Event Scheduler: [username_sdm1@localhost][username_sdm.leave_taken_status_change] Table 'username_sdm.hs_hr_leave' doesn't exist
    2016-03-01 05:00:00 265924 [Note] Event Scheduler: [username_sdm1@localhost].[username_sdm.leave_taken_status_change] event execution failed.

    terus ini log cpanelnya

    Template::Service::process(Template::Service=HASH(0x59a1b98), "/usr/local/cpanel/base/frontend/paper_lantern/sql/PhpMyAdmin."..., HASH(0x59a1340)) called at /usr/local/cpanel/3rdparty/perl/514/lib64/perl5/cpanel_lib/x86_64-linux-64int/Template.pm line 66
    Template::process(Template=HASH(0x59a1820), "/usr/local/cpanel/base/frontend/paper_lantern/sql/PhpMyAdmin."..., HASH(0x59a1340), SCALAR(0x3f3de80)) called at /usr/local/cpanel/Cpanel/Template.pm line 435
    Cpanel::Template::process_template("cpanel", HASH(0x59a1340), HASH(0x59a11a8)) called at cpanel.pl line 1215
    cpanel::cpanel::cptt_exectag("/usr/local/cpanel/base/frontend/paper_lantern/sql/PhpMyAdmin."..., 1) called at cpanel.pl line 5214
    cpanel::cpanel::run_standard_mode() called at cpanel.pl line 869
    cpanel::cpanel::script("cpanel::cpanel", "./frontend/paper_lantern/sql/PhpMyAdmin.html.tt") called at cpanel.pl line 331
    [2016-03-01 09:36:07 +0700] warn [Mysql::updateprivs] Encountered error in Mysql::updateprivs: The adminbin “cpmysql” in the “Cpanel” namespace call to function “UPDATEPRIVS” ended prematurely: The subprocess reported error number 2 when it ended.
    [2016-03-01 09:37:16 +0700] info [perlinstaller] /root/.cpanel/datastore/Cpanel::Sys::Compiler::test_compile_gcc
    [2016-03-01 09:50:14 +0700] info [cpsrvd] Internal Server Error: "POST /cpsess4649979060/3rdparty/roundcube/?_task=mail&_action=refresh HTTP/1.1" 500 The cPanel Server operation timed out at cpsrvd.pl line 539.

    Sebelumnya saya enable event_scheduler apakah terjadi crash ?

    mohon pencerahannya

    Regards,
    Shara Nurul
     
  4. junior riau

    junior riau Hosting Guru Web Hosting

    Messages:
    3,228
    Likes Received:
    515
    Trophy Points:
    113
    sepertinya ada crash sma db nya, coba di fix kan dulu db nya
     
  5. shara nurul

    shara nurul Apprentice 1.0

    Messages:
    234
    Likes Received:
    1
    Trophy Points:
    18
  6. junior riau

    junior riau Hosting Guru Web Hosting

    Messages:
    3,228
    Likes Received:
    515
    Trophy Points:
    113
    mysqlrepair -c [dbname]
     
  7. mustafaramadhan

    mustafaramadhan Hosting Guru

    Messages:
    3,237
    Likes Received:
    857
    Trophy Points:
    113
    Dari hostname.err, kelihatan ada table yang hilang/tidak ada. Pada aplikasi tertentu (misalnya afterlogic webmail), update aplikasi seringkali harus diiringi dengan update data dari mysql.
     
  8. idnix

    idnix Hosting Guru

    Messages:
    1,003
    Likes Received:
    189
    Trophy Points:
    63
    check table hs_hr_leave ada gak. takutnya table locked :D
     
  9. vishualhost

    vishualhost Expert 2.0

    Messages:
    813
    Likes Received:
    81
    Trophy Points:
    28
    @TS sudah coba disabled ini :

    Tweak Settings » SQL » Use INFORMATION_SCHEMA to acquire MySQL disk usage" .

    apabila masih ON coba disabled dan restart cpanel dan mysqlnya
     
    pluto01 likes this.
  10. shara nurul

    shara nurul Apprentice 1.0

    Messages:
    234
    Likes Received:
    1
    Trophy Points:
    18
    @all : mohon maaf baru membalas ,baru online

    Masalah solved dengan repair database

    Regards,
    Shara Nurul
     
Loading...
Thread Status:
Not open for further replies.

Share This Page

Loading...