Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Database marked as crashed and should be repaired

Discussion in 'Database Discussion' started by Apurv Chaturvedi, Nov 20, 2018.

  1. Apurv Chaturvedi

    Apurv Chaturvedi Registered

    Joined:
    Nov 20, 2018
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Delhi
    cPanel Access Level:
    Website Owner
    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.
     
  2. GOT

    GOT Get Proactive! PartnerNOC

    Joined:
    Apr 8, 2003
    Messages:
    1,372
    Likes Received:
    154
    Trophy Points:
    193
    Location:
    Chesapeake, VA
    cPanel Access Level:
    DataCenter Provider
    Go I to phpmyadmin and repair all the tables in that database,
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    5,815
    Likes Received:
    443
    Trophy Points:
    233
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    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!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice