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

[Brandon Armstead]

Timo,

   Let me also add

max_allowed_packet = 512M.

On Thu, Dec 8, 2011 at 2:52 PM, Brandon Armstead <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> 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
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20111208/67e06def/attachment.htm>