16 Feb
2016
16 Feb
'16
10:30 p.m.
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