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">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 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 [c9d5ed0-13c4-4ee10778-92e3eb21-a90244c@XXX.XXX.XXX.XXX], 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>