[Serusers] ERROR message : MySQL server has gone away

[Kostas Marneris]

Greetings to the list.

We have a setup with ser-0.9.6 and mysql-5.0.19.
We have compiled everything from sources and we used mysql-5.0.19 sources from
MySQL. Our x86 servers run Debian Sarge.

We have installed everything under /opt and we linked ser with the
mysql client libs under /opt/mysql/lib. There is no other installation
of MySQL (clients or development files).

In ser.cfg, we have the following mysql URIs:

fifo_db_url="mysql://ser:XXXXX@<IP_of_MySQL>/ser"
modparam("usrloc", "db_url", "mysql://ser:XXXXX@<IP_of_MySQL>/ser")


The PROBLEM:
We start ser via serctl (LD_LIBRARY_PATH needed) and we restart mysql.
If a new REGISTER comes to SER and then SER tries to write to MySQL,
we get the following error mesgs :
Apr 13 14:30:23 ./ser[26040]: submit_query(): MySQL server has gone away
Apr 13 14:30:23 ./ser[26040]: db_insert: Error while submitting query
Apr 13 14:30:23 ./ser[26040]: db_insert_ucontact(): Error while inserting contact
Apr 13 14:30:23 ./ser[26040]: insert_ucontact(): Error while inserting in database


Seems like SER's MySQL module does not auto-reconnect to MySQL server.


Please let us know what you need to further trace the issue.

thanks in advance for your help,


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

-- 
Kostas Marneris
e-mail: K.Marneris at otenet.gr
Tel   : +30-210-6151886