Backup error -> MySQL server has gone away

Backup error -> MySQL server has gone away - Printable Version

+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Usage (/forum-34.html)
+--- Thread: Backup error -> MySQL server has gone away (/thread-12639.html)

Backup error -> MySQL server has gone away - Elber - 01-10-2011 08:29 PM

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 ?

RE: Backup error -> MySQL server has gone away - mydebians - 01-13-2011 09:18 AM

Hi, try to comment this line

Code:

wait_timeout = 2000

RE: Backup error -> MySQL server has gone away - Egor4ik - 06-26-2012 07:52 PM

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)