Database marked as crashed and should be repaired

[Apurv Chaturvedi]

Unable to access the backend dashboard of my website after a failed backup today.

[2018-11-20 02:02:50 +0000] i2182544_wp12: mysqldump: Got error: 145: Table './i2182544_wp12/AWP_options' is marked as crashed and should be repaired when using LOCK TABLES




Review the attached log “/usr/local/cpanel/logs/cpbackup/1542679202.log” for further details.
[2018-11-20 02:34:56 +0000] homesize is: 56961150976
[2018-11-20 02:34:56 +0000]
[2018-11-20 02:34:56 +0000] homefiles is: 868157
[2018-11-20 02:34:56 +0000] pkgacct completed
[2018-11-20 02:34:57 +0000] info [backup] Successfully backed up account “apurv1984” to “/backup/2018-11-20/accounts”
[2018-11-20 02:34:57 +0000] info [backup] Adding metadata information for apurv1984 to backup at /backup/2018-11-20
[2018-11-20 02:43:51 +0000] info [backup] Queuing daily backup copy of “apurv1984” for transport of “/backup/2018-11-20/accounts/apurv1984.tar.gz” to “2018-11-20/accounts/apurv1984.tar.gz”
[2018-11-20 02:43:51 +0000] info [backup] This particular transport will be queued with keep_local = 1 , based on the need to copy weekly () and/or monthly () copies as well.
[2018-11-20 02:44:21 +0000] info [backup] Queuing transport of file: /backup/2018-11-20/accounts/apurv1984.tar.gz
[2018-11-20 02:44:21 +0000] info [backup] no_transport = 0 .. and queueid = TQ:TaskQueue:214
[2018-11-20 02:44:21 +0000] info [backup] leaving queue_backup_transport_item
[2018-11-20 02:44:21 +0000] info [backup] Queuing transport of meta file: /backup/2018-11-20/accounts/.master.meta
[2018-11-20 02:44:21 +0000] info [backup] no_transport = 0 .. and queueid = TQ:TaskQueue:215
[2018-11-20 02:44:21 +0000] info [backup] leaving queue_backup_transport_item
[2018-11-20 02:44:21 +0000] info [backup] Queuing transport of file: /backup/2018-11-20/backup_incomplete
[2018-11-20 02:44:21 +0000] info [backup] no_transport = 0 .. and queueid = TQ:TaskQueue:216
[2018-11-20 02:44:21 +0000] info [backup] leaving queue_backup_transport_item
[2018-11-20 02:44:21 +0000] warn [backup] Pruning of backup files skipped due to errors. at /usr/local/cpanel/bin/backup line 394.
bin::backup::run("bin::backup") called at /usr/local/cpanel/bin/backup line 122
[2018-11-20 02:44:21 +0000] info [backup] Scheduling backup metadata vacuum
[2018-11-20 02:44:21 +0000] info [backup] Queuing transport reporter
[2018-11-20 02:44:21 +0000] info [backup] no_transport = 0 .. and queueid = TQ:TaskQueue:217
[2018-11-20 02:44:21 +0000] info [backup] leaving queue_backup_transport_item
[2018-11-20 02:44:21 +0000] info [backup] Completed at Tue Nov 20 02:44:21 2018
[2018-11-20 02:44:21 +0000] info [backup] Final state is Backup::PartialFailure (0)

Can someone plz help with this.

 

[GOT]

Go I to phpmyadmin and repair all the tables in that database,

 

[cPanelLauren]

HI @Apurv Chaturvedi

The advice provided by @GOT here is what I would also suggest. Let us know if you have any further issues with the backups after that.

Thanks!