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

[Alberto Listas]

Hi,

I am having this same problem. Has someone found a solution?

Thanks,
Alberto
----- Original Message ----- 
From: "Adrian Georgescu" <ag at ag-projects.com>
To: "OpenSIPS users mailling list" <users at lists.opensips.org>
Sent: Sunday, October 04, 2009 7:35 AM
Subject: Re: [OpenSIPS-Users] CallControl - CDRTool : MySQL server has 
goneaway (2006)


> 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
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users


--------------------------------------------------------------------------------



No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.409 / Virus Database: 270.14.3/2412 - Release Date: 10/03/09 
18:34:00