Backup problem - 3 MB becomes 1TB

zlygis

• June 02, 2014 01:53

Hi, I have a bit of a problem with backups (two days in a row). As you can see from the log below, while creating a backup of mysql database (the size of database in question is about 3M), backup software writes to backup destination >1TB (in this case " 1165212626944 bytes). This causes backup to stuck and i have to kill process manualy. Any ideas what could be the problem? Copying homedir............. Done Calculating nobody files............ Done Entering timeout safety mode Determining mysql dbs......mysql version: 5.5......mysqldump version: 5.5...Sav$ ...Done Storing mysql dbs............ cpuser _rerich......... (3603105 bytes) cpuser _bibl......... ......... ......... ......... <...> (1165212626944 bytes) cpuser _film(0 bytes) cpuser_teos......... (0 bytes) cpuser_gs1......... (0 bytes) ERROR: Failed to dump one or more databases ...Done Copying cpuser file.......Done Copying crontab file.......Done Copying quota info.......Done Storing Subdomains.... Done Storing Parked Domains.... Done Storing Addon Domains.... Done Creating Archive ..............................................................$ ................................................................................ ................................................................................ ............... <...> [Here Ive killed the pkgacct process] pkgacct started. pkgacct version 10 - user : nextuser - tarball: 1 - target mysql : default - sp$ pkgacct using '/usr/local/cpanel/3rdparty/bin/pigz -4 --processes 4 --blocksize$ Bailing out.. you must set a valid destination for backups /usr/bin/md5...
Some server info: MySQL version 5.5.36-cll Linux xxx.xxxt.com 2.6.32-531.11.2.lve1.2.55.el6.x86_64 #1 SMP Fri Apr 18 09:06:31 EDT 2014 x86_64 x86_64 x86_64 GNU/Linux WHM 11.42.1 (build 16) Thank You in advance. [COLOR="silver">- - - Updated - - - P.S. Yesterday the same problem occured with another MySQL database.

• 

  cPanelMichael

  • June 02, 2014 14:23

  Hello :) Could you open a support ticket using the link in my signature so we can attempt to reproduce the issue on your system and determine why it's happening? You can post the ticket number here so we can update this thread with the outcome. Thank you.

  0
• 

  zlygis

  • June 06, 2014 11:28

  Hi, I think this happened because the MySQL database was broken. After repairing all databases on MySQL server, the scheduled backup completed without any problems. As a feature request: perhaps backup software could check if everything is ok with database before trying to dump and backup it. Or auto-repair all databases before backup ;)

  0
• 

  cPanelMichael

  • June 06, 2014 14:23

  That would likely be classified as a bug report. Were you able to submit a ticket so we could reproduce the issue? Thank you.

  0

Please sign in to leave a comment.