[sr-dev] [kamailio] Database timeout over SSL? (#406)

[Tobias Lindgren]

Ok, so I believe I may have found the issue, or rather I think I know what's happening, just not where it all goes wrong.

In my kamailio config I have logic for some users to call through a list of numbers to find a number where they are able to take the call, pretty much like a hunt-group, trying the numbers one by one.

When none of the numbers are answered and one of these calls time out and Request Timeout occurs, it looks like the `timer` process would like to write a row for each call leg/branch to the `missed_calls` table and here's where the issue seems to occur (I've added some debug output to be able to trace back what's happening and 54110017 below is the mysql thread ID):
```
Feb 16 21:05:24 host /usr/sbin/kamailio[2731]: WARNING: db_mysql [km_dbase.c:80]: db_mysql_submit_query(): 54110017 entering db_mysql_submit_query
Feb 16 21:05:24 host /usr/sbin/kamailio[2731]: WARNING: db_mysql [km_dbase.c:89]: db_mysql_submit_query(): 54110017 mysql ping done
Feb 16 21:05:24 host /usr/sbin/kamailio[2731]: WARNING: db_mysql [km_dbase.c:101]: db_mysql_submit_query(): 54110017 submit_query(): insert into `missed_calls` (branch 1 data)
Feb 16 21:05:24 host /usr/sbin/kamailio[2731]: WARNING: db_mysql [km_dbase.c:116]: db_mysql_submit_query(): 54110017 db_mysql_submit_query returned 0
Feb 16 21:05:24 host /usr/sbin/kamailio[2731]: WARNING: db_mysql [km_dbase.c:80]: db_mysql_submit_query(): 54110017 entering db_mysql_submit_query
Feb 16 21:05:24 host /usr/sbin/kamailio[2731]: WARNING: db_mysql [km_dbase.c:101]: db_mysql_submit_query(): 54110017 submit_query(): insert into `missed_calls` (branch 2 data)
Feb 16 21:05:24 host /usr/sbin/kamailio[2731]: ERROR: db_mysql [km_dbase.c:128]: db_mysql_submit_query(): 54110017 driver error on query: SSL connection error: socket layer receive error (2026)
Feb 16 21:05:24 host /usr/sbin/kamailio[2731]: ERROR: <core> [db_query.c:235]: db_do_insert_cmd(): error while submitting query
```

I'm guessing that the two db_mysql_submit_query() calls run at almost the same time and that the first insert has not completed before the second insert wants to run, at which point something similar to what's described here occurs: http://dev.mysql.com/doc/refman/5.6/en/c-api-multiple-queries.html

This is only observed when the connection is running over SSL, so there's probably something related there.

OR.. my config is screwed up and I'm not working with branches in the correct way :)

---
Reply to this email directly or view it on GitHub:
https://github.com/kamailio/kamailio/issues/406#issuecomment-184863893
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20160216/335755eb/attachment.html>