MySQL Connect Errors - sr-users

8 Oct 2015

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'
...