Backup error -> MySQL server has gone away

[Egor4ik]

The problem replicates when doing SQL backups on big databases with compression.

for ISPCP 1.0.3 It looks like:

Code:

# /var/www/ispcp/engine/backup/ispcp-backup-all yes
Can't use string ("") as an ARRAY ref while "strict refs" in use at /var/www/ispcp/engine/backup/ispcp-backup-all line 148.
#

If {PrintError=1} in ispcp_common_methods.pl the output getting more informative:

Code:

DBD::mysql::db selectall_arrayref failed: MySQL server has gone away at /var/www/ispcp/engine/backup/../ispcp_common_methods.pl line 276.
Can't use string ("") as an ARRAY ref while "strict refs" in use at /var/www/ispcp/engine/backup/ispcp-backup-all line 148.

Fixed with:
my.cnf:
wait_timeout = 28800 (default !)
net_read_timeout = 600 (default 30 sec)