[sr-dev] Lost connection to MySQL Server - Frequent Occurrence?

[Daniel-Constantin Mierla]

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>