lost mysql connections - sr-users

19 Dec 2015

for some reason once in a while kamailio processes fail to execute mysql
queries while at the same time an mysql test script that is run once per
second from cron works fine.

kamailio executes mysql queries during normal sip message processing and
also when it processes an OPTIONS ping test request:

sql_query("sip_proxy", "SELECT table_version FROM version WHERE
table_name='domain'", "result");
if ($rc == 1) {
  sql_result_free("result");
  options_reply();
} else {
  xlog("L_ERR", "$rm <$ru> failed sql test\n");
  sql_result_free("result");
  send_reply("500", "Server Internal Error");
};

here is an example:

...
Dec 15 00:51:08 proxy1 php: MySQL server test succeeded
Dec 15 00:51:09 proxy1 php: MySQL server test succeeded
Dec 15 00:51:10 proxy1 /usr/bin/sip-proxy[29894]: ERROR: db_mysql [km_dbase.c:123]:
db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during
query
Dec 15 00:51:10 proxy1 /usr/bin/sip-proxy[29894]: ERROR: db_mysql [km_dbase.c:145]:
db_mysql_async_exec_task(): failed to execute query on async worker
Dec 15 00:51:10 proxy1 php: MySQL server test succeeded
Dec 15 00:51:11 proxy1 php: MySQL server test succeeded
Dec 15 00:51:13 proxy1 php: MySQL server test succeeded
Dec 15 00:51:13 proxy1 /usr/bin/sip-proxy[29891]: ERROR: db_mysql [km_dbase.c:123]:
db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during
query
Dec 15 00:51:13 proxy1 /usr/bin/sip-proxy[29891]: ERROR: <core> [db_query.c:291]:
db_do_delete(): error while submitting query
Dec 15 00:51:13 proxy1 /usr/bin/sip-proxy[29883]: ERROR: OPTIONS <sip:xxx:5060>
failed sql test
Dec 15 00:51:14 proxy1 php: MySQL server test succeeded
Dec 15 00:51:14 proxy1 /usr/bin/sip-proxy[29886]: ERROR: OPTIONS <sip:xxx:5060>
failed sql test
Dec 15 00:51:15 proxy1 php: MySQL server test succeeded
Dec 15 00:51:15 proxy1 /usr/bin/sip-proxy[29885]: ERROR: OPTIONS <sip:xxx:5060>
failed sql test
Dec 15 00:51:16 proxy1 php: MySQL server test succeeded
Dec 15 00:51:17 proxy1 php: MySQL server test succeeded
Dec 15 00:51:18 proxy1 php: MySQL server test succeeded
...

all db_mysql module params are at their default values.

any idea why kamailio at connection loss does not automatically create
new connections?

is there a means to somehow debug this further?

-- juha