The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Backup problem - 3 MB becomes 1TB

Discussion in 'Data Protection' started by zlygis, Jun 2, 2014.

  1. zlygis

    zlygis Registered

    Joined:
    Jun 2, 2014
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    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?

    Code:
    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.

    - - - Updated - - -

    P.S. Yesterday the same problem occured with another MySQL database.
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  3. zlygis

    zlygis Registered

    Joined:
    Jun 2, 2014
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    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 ;)
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page