Backup error -> MySQL server has gone away

[Elber]

Hi, i have problem with my backup...

Quote:[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: setfmode(), msg: Starting...
[DEBUG] push_el() sub_name: setfmode(), msg: Ending...
[DEBUG] push_el() sub_name: backup_sql(), 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: 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 155.

In my my.cnf i have

Quote:wait_timeout = 2000
interactive_timeout = 100
connect_timeout = 100

How to fix my problem ?

[mydebians]

Hi, try to comment this line

Code:

wait_timeout = 2000

[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)