The MySQL server is currently offline

[shara nurul]

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

 

[junior riau]

cba paste isi dari /var/lib/mysql/hostname.err
sama isi tail -n 20 /usr/loca/cpanel/log/error_logs

 

[shara nurul]

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:rocess(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:rocess(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:rocess_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 0907 +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 0916 +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

 

[junior riau]

sepertinya ada crash sma db nya, coba di fix kan dulu db nya

 

[shara nurul]

@junior riau : caranya gimana mas ,mohon bantuannya

 

[junior riau]

mysqlrepair -c [dbname]

 

[mustafaramadhan]

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.

 

[idnix]

check table hs_hr_leave ada gak. takutnya table locked

 

[IIXPLANET]

@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

 

[shara nurul]

@all : mohon maaf baru membalas ,baru online

Masalah solved dengan repair database

Regards,
Shara Nurul