[Serusers] ERROR message : MySQL server has gone away

Leo Papadopoulos leo at telecomcto.com
Tue Apr 11 03:34:55 CEST 2006


John,

I just saw that message today as well. I had to restart SER. I didn't know
what it was, but I would be like to know if you find a solution. This seems
to have something to do with the newest version of MySQL I think. I am
running v5.0.18 for the first time. This does not happen on MySQL v4.1.16.

Leo P.

________________________________________
From: serusers-bounces at iptel.org [mailto:serusers-bounces at lists.iptel.org] On
Behalf Of "???"
Sent: Friday, March 31, 2006 9:01 AM
To: serusers at lists.iptel.org
Subject: [Serusers] ERROR message : MySQL server has gone away

please help.....
 
 
If i restart MySQL(version 5.0.19), SER shows next error message.
 
 
 
Mar 31 22:37:18 localhost /usr/local/sbin/ser[32701]: submit_query(): MySQL
server has gone away 
Mar 31 22:37:18 localhost /usr/local/sbin/ser[32701]: submit_query(): Error
while submitting query 
Mar 31 22:37:18 localhost /usr/local/sbin/ser[32701]: get_ha1(): Error while
querying database 
Mar 31 22:37:22 localhost /usr/local/sbin/ser[32703]: Binding
'1234 at 192.9.2.1','sip:1234 at 192.9.2.11:5060' has expired 
 
 
 
As appear in upside message, SER does not auto-reconnect to mysql.
 
If MySQL restarted, SER must be able to do Auto-Reconnect.
 
Is no there way that SER can do Auto-Reconnect to MySQL?
 






More information about the sr-users mailing list