9 Dec
2011
9 Dec
'11
11:03 a.m.
Daniel,
It was not related - I am still experiencing this very frequently.
The crash however was happening due to a modification I made it the
Db_mysql module to further track down why it is happening.
Sent from my iPhone
On Dec 8, 2011, at 10:51 PM, Daniel-Constantin Mierla <miconda(a)gmail.com> wrote:
Hello,
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?
Thanks,
Daniel
On 12/8/11 11:53 PM, Brandon Armstead wrote:
Timo,
Let me also add
max_allowed_packet = 512M.
On Thu, Dec 8, 2011 at 2:52 PM, Brandon Armstead <brandon(a)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(a)foo-lounge.de> wrote:
Hey Brandon,
Am 08.12.2011 um 20:32 schrieb Brandon Armstead:
--
Daniel-Constantin Mierla -- http://www.asipto.com
http://linkedin.com/in/miconda -- http://twitter.com/miconda 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(a)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
_______________________________________________
sr-dev mailing list
sr-dev(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev