Hello,<div><br></div><div> This is still happening - I've tweaked almost all kernel networking / tcp and mysql configurations to see if I can isolate / resolve this matter -- however it seems that this error is still persistent.</div>
<div><br></div><div>Any thoughts / suggestions? Move to postgresql? :P</div><div><br></div><div>Sincerely,</div><div>Brandon Armstead<br><br><div class="gmail_quote">On Sat, Dec 10, 2011 at 9:03 PM, Brandon Armstead <span dir="ltr"><<a 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">Daniel,<div><br></div><div> Just confirming again - that I am still very very frequently seeing these syslog events posted ---- I still am unable to locate any plausible reason for such events occurring.</div>
<div><br></div>
<div>The crash that was happening was related to me moving a piece of code down into the error block to see what the exact query was that it was failing on (during query). It seemed most queries were related to dialog - however not all. All queries were referencing the same database server (different databases).</div>
<div><br></div><div>Any other ideas why this may be happening? Or any suggestions on how I can further track it down / isolate the matter?</div><div><br></div><div>Look forward to hearing back from you, thanks!</div><div>
<br></div><div>Sincerely,</div><div><span class="HOEnZb"><font color="#888888">Brandon Armstead</font></span><div><div class="h5"><br><br><div class="gmail_quote">On Thu, Dec 8, 2011 at 10:51 PM, Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div 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<div><div><br>
<br>
On 12/8/11 11:53 PM, Brandon Armstead wrote:
</div></div><blockquote type="cite"><div><div>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 href="mailto:brandon@cryy.com" target="_blank">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><font color="#888888">
<div>Brandon Armstead</div>
</font></span>
<div>
<div><br>
<div class="gmail_quote">On Thu, Dec 8, 2011 at 2:48
PM, Timo Reimann <span dir="ltr"><<a 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 href="mailto:c9d5ed0-13c4-4ee10778-92e3eb21-a90244c@XXX.XXX.XXX.XXX" target="_blank">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 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></fieldset>
<br>
</div></div><pre>_______________________________________________
sr-dev mailing list
<a href="mailto:sr-dev@lists.sip-router.org" target="_blank">sr-dev@lists.sip-router.org</a>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev</a><span><font color="#888888">
</font></span></pre><span><font color="#888888">
</font></span></blockquote><span><font color="#888888">
<br>
<pre cols="72">--
Daniel-Constantin Mierla -- <a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a href="http://linkedin.com/in/miconda" target="_blank">http://linkedin.com/in/miconda</a> -- <a href="http://twitter.com/miconda" target="_blank">http://twitter.com/miconda</a></pre>
</font></span></div>
</blockquote></div><br></div></div></div>
</blockquote></div><br></div>