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 <[email protected]
<mailto:[email protected]>> 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 <[email protected]
<mailto:[email protected]>> 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
[[email protected]],
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
[email protected]
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
--
Daniel-Constantin Mierla -- http://www.asipto.com
http://linkedin.com/in/miconda -- http://twitter.com/miconda
_______________________________________________
sr-dev mailing list
[email protected]
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
