[OpenSIPS-Users] CallControl - CDRTool : MySQL server has gone away (2006)

[Adrian Georgescu]

Hi Carlo,

I am aware of this problem. To my dispair I could not find what is  
causing for it.

I have already captured both errors 2006 and 2013 at the lowest level  
possible in PHP code (in phplib/db_mysql.inc) where when such error  
code is detected a new connection to mysql server is initiated. This  
problem seems to bypass these checks altogether though if you follow  
through the code it would be logically impossible. As this happens  
only on particular systems while on others it does not, I suspect the  
cause is related to a particular version of mysql C client library or  
a combination of particular client and server versions.

So I am looking for hints myself for how to solve this nasty issue.

--
Adrian





On Oct 2, 2009, at 10:58 AM, Carlo Dimaggio wrote:

>
> Il giorno 24/lug/09, alle ore 15:02, Adrian Georgescu ha scritto:
>
>> If you lower the mysql connection timeout to a a few minutes you will
>> see in syslog that the software is able to reconnect correctly in  
>> case
>> of 2006 or 2013.
>>
>> But I have seen this myself too, randomly it fails and though the
>> error code is intercepted in mysql connection library used by cdrtool
>> (in db_mysql.inc) sometimes it still does not work as expected and
>> could not trace the reason how it can do this. Maybe you can inspect
>> that code add some debugging statements to it and find the culprit.
>
> Hi Adrian,
>
> I took your mail of last july because I'm experiencing with the same
> problems.
> After the mysql timeout (8 hours), cdrtool doesn't reconnect to mysql:
> "Database error for query 'select * from prepaid where account = '1000 at sip.xxx.it
> '': MySQL server has gone away (2006), link_id =Resource id #53,
> query_id = "
>
> I think is useful to tell you that I hadn't these problems with an
> ubuntu 8.04 installation (now I have a lenny 64bit)... There could be
> something in this last installation (like some parameters in mysql
> config?)
>
> Do you have hints for this?
>
> Thanks and regards,
> Carlo Dimaggio
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users