[sr-dev] Lost connection to MySQL Server - Frequent Occurrence?
Daniel-Constantin Mierla
miconda at gmail.com
Fri Dec 9 07:51:25 CET 2011
Hello,
was it related to the item in the bug tracker (which I just closed due
to PM on tracker from you)? What was the cause for it?
Thanks,
Daniel
On 12/8/11 11:53 PM, Brandon Armstead wrote:
> Timo,
>
> Let me also add
>
> max_allowed_packet = 512M.
>
> On Thu, Dec 8, 2011 at 2:52 PM, Brandon Armstead <brandon at cryy.com
> <mailto:brandon at cryy.com>> wrote:
>
> Timo,
>
> Thanks for this reference - I actually have been playing /
> tweaking with various mentioned items in this reference earlier.
>
> My current settings are as follows:
>
> connect_timeout = 30
> net_read_timeout = 180
> net_write_timeout = 180
>
> The issue still seems to be quite prevalent. I will say that the
> amount of aborted connects currently (41) is way lower than the
> actual amount of syslog lost connection errors.
>
> Sincerely,
> Brandon Armstead
>
> On Thu, Dec 8, 2011 at 2:48 PM, Timo Reimann <sr at foo-lounge.de
> <mailto:sr at foo-lounge.de>> wrote:
>
> Hey Brandon,
>
>
> Am 08.12.2011 um 20:32 schrieb Brandon Armstead:
> > I am very very very frequently seeing in logs "Lost
> connection to MySQL Server" --- the MySQL server that it is
> connecting to is less than 1 ms away (essentially sitting in
> the same rack).
> >
> > Dec 8 19:21:15 /usr/local/sbin/kamailio[4149]: INFO:
> dialog [dlg_db_handler.c:584]: trying to remove dialog
> [c9d5ed0-13c4-4ee10778-92e3eb21-a90244c at XXX.XXX.XXX.XXX],
> update_flag is 4
> > Dec 8 19:21:16 /usr/local/sbin/kamailio[4149]: ERROR:
> db_mysql [km_dbase.c:122]: driver error on query: Lost
> connection to MySQL server during query
> > Dec 8 19:21:16 /usr/local/sbin/kamailio[4149]: ERROR:
> <core> [db_query.c:242]: error while submitting query
> > Dec 8 19:21:16 /usr/local/sbin/kamailio[4149]: ERROR:
> dialog [dlg_db_handler.c:598]: failed to delete database
> information
> >
> > *** MOD PARAM CONFIG ***
> >
> > # database ping
> > modparam("db_mysql", "ping_interval", 150)
> > modparam("db_mysql", "auto_reconnect", 1)
> >
> > Any thoughts on what may be happening? It seems the overall
> connection (network) between the two servers is great.
>
> The MySQL documentation enumerates a number of reasons:
>
> http://dev.mysql.com/doc/refman/5.1/en/error-lost-connection.html
> (This is the URL to MySQL version 5.1 documentation.)
>
> You may want to check those for possible matchings.
>
>
> Cheers,
>
> --Timo
>
>
>
>
>
> _______________________________________________
> sr-dev mailing list
> sr-dev at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
--
Daniel-Constantin Mierla -- http://www.asipto.com
http://linkedin.com/in/miconda -- http://twitter.com/miconda
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20111209/09f3a912/attachment-0001.htm>
More information about the sr-dev
mailing list