Current time: 07-11-2020, 01:20 AM Hello There, Guest! (LoginRegister)


Post Reply 
Backup error -> MySQL server has gone away
Author Message
Elber Offline
Junior Member
*

Posts: 51
Joined: Oct 2009
Reputation: 0
Post: #1
Backup error -> MySQL server has gone away
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 ?
01-10-2011 08:29 PM
Find all posts by this user Quote this message in a reply
mydebians Offline
Junior Member
*

Posts: 27
Joined: Apr 2007
Reputation: 0
Post: #2
RE: Backup error -> MySQL server has gone away
Hi, try to comment this line

Code:
wait_timeout = 2000
01-13-2011 09:18 AM
Find all posts by this user Quote this message in a reply
Egor4ik Offline


Posts: 3
Joined: Nov 2011
Reputation: 0
Post: #3
RE: Backup error -> MySQL server has gone away
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)
06-26-2012 07:52 PM
Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)