Backup is failing

[dirkson]

Hey, that was useful! Error message, now with verbosity:

Code:

# cat /var/log/ispcp/ispcp-backup-*
DEBUG: push_el() sub_name: backup_all_start_up(), msg: Starting...
DEBUG: push_el() sub_name: lock_backup_all_system(), msg: Starting...
DEBUG: push_el() sub_name: sys_command(), msg: Starting...
DEBUG: push_el() sub_name: sys_command('/usr/bin/touch /tmp/ispcp-backup-all.lock'), msg: Ending...
DEBUG: push_el() sub_name: lock_backup_all_system(), msg: Ending...
DEBUG: push_el() sub_name: get_conf(), msg: Starting...
DEBUG: push_el() sub_name: get_file(), msg: Starting...
DEBUG: push_el() sub_name: get_file(), msg: Ending...
DEBUG: push_el() sub_name: setup_main_vars(), msg: Starting...
DEBUG: push_el() sub_name: decrypt_db_password(), msg: Starting...
DEBUG: push_el() sub_name: decrypt_db_password(), msg: Ending...
DEBUG: push_el() sub_name: setup_main_vars(), msg: Ending...
DEBUG: push_el() sub_name: get_conf(), msg: Ending...
DEBUG: push_el() sub_name: backup_all_start_up(), msg: Ending...
DEBUG: push_el() sub_name: database_revision(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: Ending...
DEBUG: push_el() sub_name: database_revision(), msg: Ending...
DEBUG: push_el() sub_name: backup_all_engine(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: Ending...
DEBUG: push_el() sub_name: get_human_date(), msg: Starting...
DEBUG: push_el() sub_name: get_human_date(), msg: Ending...
DEBUG: push_el() sub_name: doSQL(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: Ending...
DEBUG: push_el() sub_name: sys_command(), msg: Starting...
DEBUG: push_el() sub_name: sys_command('/bin/tar --create --directory=/var/www/virtual/frogstar.com --gzip --file=/var/www/virtual/frogstar.com/frogstar.com-backup-2009.03.24-101915.tar.gz --exclude=logs --exclude=phptmp --exclude=backups --exclude=frogstar.com-backup-2009.03.24-101915.tar.gz . 2> /var/www/virtual/frogstar.com/frogstar.com-backup-2009.03.24-101915.tar.gz.log'), msg: Ending...
DEBUG: push_el() sub_name: sys_command(), msg: Starting...
DEBUG: push_el() sub_name: sys_command('/bin/rm -rf /var/www/virtual/frogstar.com/frogstar.com-backup-2009.03.24-101915.tar.gz.log'), msg: Ending...
DEBUG: push_el() sub_name: sys_command(), msg: Starting...
DEBUG: push_el() sub_name: sys_command('/bin/rm -rf /var/www/virtual/frogstar.com/backups/frogstar.com-*.tar.*'), msg: Ending...
DEBUG: push_el() sub_name: sys_command(), msg: Starting...
DEBUG: push_el() sub_name: sys_command('/bin/mv -f /var/www/virtual/frogstar.com/frogstar.com-backup-2009.03.24-101915.tar.gz /var/www/virtual/frogstar.com/backups'), msg: Ending...
DEBUG: push_el() sub_name: setfmode(), msg: Starting...
DEBUG: push_el() sub_name: setfmode(), msg: Ending...
DEBUG: push_el() sub_name: get_human_date(), msg: Starting...
DEBUG: push_el() sub_name: get_human_date(), msg: Ending...
DEBUG: push_el() sub_name: doSQL(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: ERROR: Incorrect SQL Query -> MySQL server has gone away
Can't use string ("") as an ARRAY ref while "strict refs" in use at /var/www/ispcp/engine/backup/ispcp-backup-all line 324.

So mysql has "gone away"? This is odd- mysql never gives any issues elsewhere, and it's being used all the time.

First two entries (All that matter) from the mysql statement:

Code:

+-----------+-------------------------------+---------------+------------+------------+-------------------------------+----------------------+
| domain_id | domain_name                   | domain_status | domain_uid | domain_gid | admin_name                    | email                |
+-----------+-------------------------------+---------------+------------+------------+-------------------------------+----------------------+
|         1 | frogstar.com                  | ok            |       2004 |       2004 | frogstar.com                  | dirkson@frogstar.com |
|         2 | arizer.com                    | ok            |       2011 |       2011 | arizer.com                    | dirkson@frogstar.com |

It appears to be borking on arizer.com, which is only about 50mb. It appears to do frogstar.com just fine, which is 500mb or so. Neither of these currently have a mysql database.