<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hello,<br>
<br>
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?<br>
<br>
Thanks,<br>
Daniel<br>
<br>
On 12/8/11 11:53 PM, Brandon Armstead wrote:
<blockquote
cite="mid:CACr1DbCAF-qAmwtUzq_gH+dYYUJNj4io4kTgA2EU+Qw9K8_R=Q@mail.gmail.com"
type="cite">Timo,
<div><br>
</div>
<div> Let me also add</div>
<div><br>
</div>
<div>max_allowed_packet = 512M.<br>
<br>
<div class="gmail_quote">On Thu, Dec 8, 2011 at 2:52 PM, Brandon
Armstead <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:brandon@cryy.com">brandon@cryy.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex;">Timo,
<div><br>
</div>
<div> Thanks for this reference - I actually have been
playing / tweaking with various mentioned items in this
reference earlier.</div>
<div><br>
</div>
<div>My current settings are as follows:</div>
<div>
<br>
</div>
<div>
<div>connect_timeout = 30</div>
<div>net_read_timeout = 180 </div>
<div>net_write_timeout = 180 </div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>Sincerely,</div>
<span class="HOEnZb"><font color="#888888">
<div>Brandon Armstead</div>
</font></span>
<div>
<div class="h5"><br>
<div class="gmail_quote">On Thu, Dec 8, 2011 at 2:48
PM, Timo Reimann <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:sr@foo-lounge.de" target="_blank">sr@foo-lounge.de</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">Hey
Brandon,<br>
<br>
<br>
Am 08.12.2011 um 20:32 schrieb Brandon Armstead:<br>
<div>
<div>> 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).<br>
><br>
> Dec 8 19:21:15
/usr/local/sbin/kamailio[4149]: INFO: dialog
[dlg_db_handler.c:584]: trying to remove
dialog
[<a class="moz-txt-link-abbreviated" href="mailto:c9d5ed0-13c4-4ee10778-92e3eb21-a90244c@XXX.XXX.XXX.XXX">c9d5ed0-13c4-4ee10778-92e3eb21-a90244c@XXX.XXX.XXX.XXX</a>],
update_flag is 4<br>
> 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<br>
> Dec 8 19:21:16
/usr/local/sbin/kamailio[4149]: ERROR:
<core> [db_query.c:242]: error while
submitting query<br>
> Dec 8 19:21:16
/usr/local/sbin/kamailio[4149]: ERROR: dialog
[dlg_db_handler.c:598]: failed to delete
database information<br>
><br>
> *** MOD PARAM CONFIG ***<br>
><br>
> # database ping<br>
> modparam("db_mysql", "ping_interval",
150)<br>
> modparam("db_mysql", "auto_reconnect", 1)<br>
><br>
> Any thoughts on what may be happening?
It seems the overall connection (network)
between the two servers is great.<br>
<br>
</div>
</div>
The MySQL documentation enumerates a number of
reasons:<br>
<br>
<a moz-do-not-send="true"
href="http://dev.mysql.com/doc/refman/5.1/en/error-lost-connection.html"
target="_blank">http://dev.mysql.com/doc/refman/5.1/en/error-lost-connection.html</a><br>
(This is the URL to MySQL version 5.1
documentation.)<br>
<br>
You may want to check those for possible
matchings.<br>
<br>
<br>
Cheers,<br>
<br>
--Timo</blockquote>
</div>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
sr-dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-dev@lists.sip-router.org">sr-dev@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla -- <a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a>
<a class="moz-txt-link-freetext" href="http://linkedin.com/in/miconda">http://linkedin.com/in/miconda</a> -- <a class="moz-txt-link-freetext" href="http://twitter.com/miconda">http://twitter.com/miconda</a></pre>
</body>
</html>