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

[Brandon Armstead]

Hello,

    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.

Thanks for your time & input in advance!

Sincerely,
Brandon Armstead
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20111208/41bb6dd1/attachment.htm>