Backup completed but error occurred and disk usage warning

psytanium

• March 22, 2020 03:09

Hello, I'm receiving 2 notification emails, i think the 2 problems are related so I posted both in the same thread. My back up configuration is set to daily backup, and 1 retention copy. Everyday I receive : The backup process encountered the following error: [2020-03-22 02:04:02 +0200] The "Mysql" failed with an error: Failed after 3 times; last error: STDERR: mysqldump: Error 1194: Table 'sessions' is marked as crashed and should be repaired when dumping table `sessions` at row: 490957 and, I receive another notification on low disk capacity, My disk reached 170GB / 200 GB but I'm sure the needed capacity is 85 GB, why the used capacity is doubled ? is it because of backup failing after 3 times ? Need help, thanks :))

• 

  quietFinn

  • March 22, 2020 15:29

  My back up configuration is set to daily backup, and 1 retention copy. Everyday I receive : The backup process encountered the following error: [2020-03-22 02:04:02 +0200] The "Mysql" failed with an error: Failed after 3 times; last error: STDERR: mysqldump: Error 1194: Table 'sessions' is marked as crashed and should be repaired when dumping table `sessions` at row: 490957

  
  Go to WHM -> SQL services -> Repair MySQL Database, find the database where that error occurs and click "Repair Database". [QUOTE] and, I receive another notification on low disk capacity, My disk reached 170GB / 200 GB but I'm sure the needed capacity is 85 GB, why the used capacity is doubled ? is it because of backup failing after 3 times ? Need help, thanks :))
  In your configuration there has to be room for 3 backup sets. Also it's possible that because of those backup errors cPanel does not remove the oldest backup. How many backups do you see in the /backup folder?

  0
• 

  psytanium

  • March 22, 2020 16:05

  Go to WHM -> SQL services -> Repair MySQL Database, find the database where that error occurs and click "Repair Database".

  
  How can I know which database need repair. is there a way to repair all 70 databases ?

  0
• 

  quietFinn

  • March 22, 2020 16:31

  There should be the full backup log attached in the email you got. To repair all databases, see instructions here:

  0
• 

  psytanium

  • March 23, 2020 06:27

  There should be the full backup log attached in the email you got. To repair all databases, see instructions here:

  0
• 

  cPanelLauren

  • March 24, 2020 13:39

  How big are each of the backups when a full backup is complete? Unless you have strict retention enabled partial backups (failed backups included) aren't removed

  0
• 

  psytanium

  • March 25, 2020 06:32

  Now the backup complete without any error and the disk space is back to normal.. thx for the fix : mysqlcheck --all-databases -A
  

  0

Please sign in to leave a comment.