[Spce-user] Lost connection to MySQL server during query (2013)

[Matthias Hohl]

Hello, 

we found a problem with SPCE and MySQL, so subscribers can't connect at some time: 
If we check log file, we see that the MySQL DB has a lost connection error. 

We have a intention that it maybe has something in common with our mySQL backup script, cause it just happens, and this not everytime, when the cronjob doing the script. 
I think it could be a problem with the mysqldump, that this freeze the tables and SPCE couldn't write into the tables. 

We try now with "--lock-tables=false" and waiting, if this happens again in the next few hours. 
What do you think, any other idea about that? 

Thanks. 



Backup-Job: 

#!/bin/sh 

DEST=backup-`date +"%Y%m%d-%H%M"` 

PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin" 

export PATH 



/usr/bin/mysqldump -uroot -pvN85tzTPp65QfW9 -A --events > /tmp/$DEST.mysql.sql 

tar czpf /tmp/$DEST.tgz -C / etc/ngcp-config etc/mysql home/jail/home/cdrexport -C /tmp $DEST.mysql.sql 

rm -f /tmp/$DEST.mysql.sql 



/usr/bin/ftp -pn >/dev/null 2>&1 <<end 

open ftp.xxx.xxx 

user xxx.xxx xxxx 

put /tmp/$DEST.tgz $DEST.tgz 

bye 

end 



rm -f /tmp/$DEST.tgz 



Cronjob: 

0,30 * * * * /root/backup.sh 



ERROR MESSAGE: 


Feb 10 00 :00:25 spce (local7.err) proxy[3749]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 

Feb 10 00 :00:25 spce (local7.err) proxy[3753]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 

Feb 10 00 :00:28 spce (local7.err) proxy[3741]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 

Feb 10 00 :00:29 spce (local7.err) proxy[3756]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 

Feb 10 00 :00:29 spce (local7.err) proxy[3752]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 

Feb 10 00 :00:31 spce (local7.err) proxy[3742]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 

Feb 10 00 :00:31 spce (local7.err) proxy[3747]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 

Feb 10 00 :30:18 spce (local7.err) proxy[3745]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 

Feb 10 00 :30:19 spce (local7.err) proxy[3742]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 

Feb 10 00 :30:19 spce (local7.err) proxy[3756]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 

Feb 10 00 :30:19 spce (local7.err) proxy[3741]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 

Feb 10 02 :00:17 spce (local7.err) proxy[3752]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 

Feb 10 02 :00:17 spce (local7.err) proxy[3749]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 

Feb 10 02 :00:17 spce (local7.err) proxy[3745]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 

Feb 10 02 :30:22 spce (local7.err) proxy[3752]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 

Feb 10 02 :30:22 spce (local7.err) proxy[3742]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 

Feb 10 02 :30:22 spce (local7.err) proxy[3747]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 

Feb 10 02 :30:22 spce (local7.err) proxy[3745]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 

Feb 10 02 :30:23 spce (local7.err) proxy[3753]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 

Feb 10 03 :00:19 spce (local7.err) proxy[3747]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 

Feb 10 03 :00:20 spce (local7.err) proxy[3749]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 

Feb 10 03 :00:22 spce (local7.err) proxy[3753]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 

Feb 10 03 :00:22 spce (local7.err) proxy[3745]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 

Feb 10 03 :00:23 spce (local7.err) proxy[3752]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 

Feb 10 03 :00:26 spce (local7.err) proxy[3749]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 

Feb 10 03 :30:22 spce (local7.err) proxy[3747]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 

Feb 10 03 :30:22 spce (local7.err) proxy[3753]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 

Feb 10 03 :30:23 spce (local7.err) proxy[3749]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 

Feb 10 06 :30:19 spce (local7.err) proxy[3747]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 

Feb 10 06 :30:19 spce (local7.err) proxy[3752]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 

Feb 10 06 :30:19 spce (local7.err) proxy[3742]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 

Feb 10 06 :30:19 spce (local7.err) proxy[3753]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 

Feb 10 06 :30:19 spce (local7.err) proxy[3741]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 

Feb 10 06 :30:19 spce (local7.err) proxy[3756]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 

Feb 10 08 :30:20 spce (local7.err) proxy[3747]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query (2013) 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20160211/6a4cb818/attachment.html>