Hi, I am having this same problem. Has someone found a solution?
Thanks, Alberto ----- Original Message ----- From: "Adrian Georgescu" <a...@ag-projects.com> To: "OpenSIPS users mailling list" <users@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 = >> '1...@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@lists.opensips.org >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > _______________________________________________ > Users mailing list > Users@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 _______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users