MariaDB tidak mau restart (restart failed)


Status
Not open for further replies.

Justin B

Beginner 2.0
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
 

Hosting Bagus

Apprentice 1.0
RAMnya dulu tuan, best practice coba dari whmnya tuan ke easyapache, di rebuild saja tuan. Pake last previous config. Semoga lancar :D
 
Status
Not open for further replies.

Top