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

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