[Serusers] ERROR message : MySQL server has gone away

[Jan Janak]

Yes, there was a change in the mysql client library in 5.x. Try to use
the latest stable SER version (0.9.6), the re-connect problem should be
fixed there.

  Jan.

Leo Papadopoulos wrote:
> 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?
>  
> 
> 
> 
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
>