[SR-Users] MySQL Connect Errors

[John Billings]

We are using kamailio 4.2.0 with auth_db enabled and connected to a MySQL server. Occasionally, in the middle of the night when there is no activity we get the following errors out of the blue (the last three lines are repeated indefinitely). According to the MySQL site <http://dev.mysql.com/doc/refman/5.0/en/error-lost-connection.html>, this can be caused by a connect timeout that is too short (We verified that Aborted_connects is steadily rising). The kamailio server is right next to the database server so there is no network latency.

We increased the db_mysql timeout_interval parameter, but we still see MySQL’s Aborted_connects counter incrementing. So it’s like kamailio is still timing out on connection attempts. Ideas?

Thanks.

Oct  1 02:34:49 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: <core> [db_query.c:132]: db_do_query_internal(): error while submitting query
Oct  1 02:34:49 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: auth_db [authorize.c:175]: get_ha1(): failed to query database
Oct  1 02:34:55 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: db_mysql [km_dbase.c:123]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server at 'reading authorization packet', system error: 11
Oct  1 02:34:55 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: <core> [db_query.c:132]: db_do_query_internal(): error while submitting query
Oct  1 02:34:55 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: auth_db [authorize.c:175]: get_ha1(): failed to query database
Oct  1 02:35:01 sip-proxy1 /usr/sbin/kamailio[9264]: ERROR: db_mysql [km_dbase.c:123]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server at 'reading authorization packet', system error: 11
Oct  1 02:35:01 sip-proxy1 /usr/sbin/kamailio[9264]: ERROR: <core> [db_query.c:132]: db_do_query_internal(): error while submitting query
Oct  1 02:35:01 sip-proxy1 /usr/sbin/kamailio[9264]: ERROR: auth_db [authorize.c:175]: get_ha1(): failed to query database
Oct  1 02:35:01 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: db_mysql [km_dbase.c:123]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server at 'reading authorization packet', system error: 11
Oct  1 02:35:01 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: <core> [db_query.c:132]: db_do_query_internal(): error while submitting query
Oct  1 02:35:01 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: auth_db [authorize.c:175]: get_ha1(): failed to query database
Oct  1 02:35:07 sip-proxy1 /usr/sbin/kamailio[9264]: ERROR: db_mysql [km_dbase.c:123]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server at 'reading authorization packet', system error: 11
Oct  1 02:35:07 sip-proxy1 /usr/sbin/kamailio[9264]: ERROR: <core> [db_query.c:132]: db_do_query_internal(): error while submitting query
Oct  1 02:35:07 sip-proxy1 /usr/sbin/kamailio[9264]: ERROR: auth_db [authorize.c:175]: get_ha1(): failed to query database
Oct  1 02:35:07 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: db_mysql [km_dbase.c:123]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server at 'reading authorization packet', system error: 11
Oct  1 02:35:07 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: <core> [db_query.c:132]: db_do_query_internal(): error while submitting query
Oct  1 02:35:07 sip-proxy1 /usr/sbin/kamailio[9260]: ERROR: auth_db [authorize.c:175]: get_ha1(): failed to query database
Oct  1 02:35:11 sip-proxy1 /usr/sbin/kamailio[9264]: ERROR: db_mysql [km_dbase.c:123]: db_mysql_submit_query(): driver error on query: Host ‘X.X.X.X' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
Oct  1 02:35:11 sip-proxy1 /usr/sbin/kamailio[9264]: ERROR: <core> [db_query.c:132]: db_do_query_internal(): error while submitting query
Oct  1 02:35:11 sip-proxy1 /usr/sbin/kamailio[9264]: ERROR: auth_db [authorize.c:175]: get_ha1(): failed to query database
Oct  1 02:35:11 sip-proxy1 /usr/sbin/kamailio[9264]: ERROR: db_mysql [km_dbase.c:123]: db_mysql_submit_query(): driver error on query: Host 'X.X.X.X' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
...
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20151007/3c8cfb3a/attachment.html>