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

[Tobias Lindgren]

Hello,

Have been running your latest patch for some days now and this issue still occurs, but much more seldom than before. I also removed some TCP-childs as I don't handle much TCP traffic.

Found one time where it looks like all/most processes got their connections dropped:
```
Dec 13 15:37:45 /usr/sbin/kamailio[31904]: WARNING: db_mysql [km_dbase.c:87]: db_mysql_submit_query(): driver error on ping: SSL connection error: socket layer receive error
Dec 13 15:37:45 /usr/sbin/kamailio[31904]: WARNING: db_mysql [km_dbase.c:87]: db_mysql_submit_query(): driver error on ping: SSL connection error: socket layer receive error
Dec 13 15:37:45 /usr/sbin/kamailio[31904]: WARNING: db_mysql [km_dbase.c:87]: db_mysql_submit_query(): driver error on ping: SSL connection error: socket layer receive error
Dec 13 15:37:50 /usr/sbin/kamailio[31904]: ERROR: db_mysql [km_dbase.c:131]: db_mysql_submit_query(): driver error on query: Can't connect to MySQL server on 'mysql' (4) (2003)
Dec 13 15:37:50 /usr/sbin/kamailio[31904]: ERROR: <core> [db_query.c:235]: db_do_insert_cmd(): error while submitting query
Dec 13 15:37:50 /usr/sbin/kamailio[31904]: WARNING: db_mysql [km_dbase.c:92]: db_mysql_submit_query(): mysql thread id changed due to reconnect on mysql_ping
Dec 13 15:37:50 /usr/sbin/kamailio[31901]: WARNING: db_mysql [km_dbase.c:92]: db_mysql_submit_query(): mysql thread id changed due to reconnect on mysql_ping
Dec 13 15:37:54 /usr/sbin/kamailio[31902]: WARNING: db_mysql [km_dbase.c:92]: db_mysql_submit_query(): mysql thread id changed due to reconnect on mysql_ping
Dec 13 15:37:55 /usr/sbin/kamailio[31894]: WARNING: db_mysql [km_dbase.c:92]: db_mysql_submit_query(): mysql thread id changed due to reconnect on mysql_ping
Dec 13 15:37:55 /usr/sbin/kamailio[31898]: WARNING: db_mysql [km_dbase.c:92]: db_mysql_submit_query(): mysql thread id changed due to reconnect on mysql_ping
Dec 13 15:37:59 /usr/sbin/kamailio[31900]: WARNING: db_mysql [km_dbase.c:92]: db_mysql_submit_query(): mysql thread id changed due to reconnect on mysql_ping
Dec 13 15:38:01 /usr/sbin/kamailio[31897]: WARNING: db_mysql [km_dbase.c:92]: db_mysql_submit_query(): mysql thread id changed due to reconnect on mysql_ping
Dec 13 15:38:07 /usr/sbin/kamailio[31891]: WARNING: db_mysql [km_dbase.c:92]: db_mysql_submit_query(): mysql thread id changed due to reconnect on mysql_ping
Dec 13 15:38:13 /usr/sbin/kamailio[31892]: WARNING: db_mysql [km_dbase.c:92]: db_mysql_submit_query(): mysql thread id changed due to reconnect on mysql_ping
```

```
Process::  ID=0 PID=31890 Type=attendant
Process::  ID=1 PID=31891 Type=udp receiver child=0 sock=127.0.0.1:5060
Process::  ID=2 PID=31892 Type=udp receiver child=1 sock=127.0.0.1:5060
Process::  ID=3 PID=31894 Type=udp receiver child=2 sock=127.0.0.1:5060
Process::  ID=4 PID=31897 Type=udp receiver child=3 sock=127.0.0.1:5060
Process::  ID=5 PID=31898 Type=udp receiver child=4 sock=127.0.0.1:5060
Process::  ID=6 PID=31900 Type=udp receiver child=5 sock=127.0.0.1:5060
Process::  ID=7 PID=31901 Type=udp receiver child=6 sock=127.0.0.1:5060
Process::  ID=8 PID=31902 Type=udp receiver child=7 sock=127.0.0.1:5060
Process::  ID=9 PID=31903 Type=slow timer
Process::  ID=10 PID=31904 Type=timer
Process::  ID=11 PID=31907 Type=MI FIFO
Process::  ID=12 PID=31909 Type=MI DATAGRAM
Process::  ID=13 PID=31911 Type=tcp receiver (generic) child=0
Process::  ID=14 PID=31912 Type=tcp receiver (generic) child=1
Process::  ID=15 PID=31913 Type=tcp main process
```

The issue is obviously network related, and kamailio cannot recover after that.

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