[SR-Users] Kamailio stops processing requests over UDP

[Daniel-Constantin Mierla]

On 29.08.19 13:02, Juha Heinanen wrote:
> Daniel-Constantin Mierla writes:
>
>> Being reply processing, one potential operation that can be slow is
>> writing the acc record to the database. Any external tool blocking the
>> acc tables?
> I'm not sure about that.  Unfortunately there was no SIP over TCP calls
> during the UDP freeze so that accounting records would be produced.
>
> Isn't there any timeout on writing accounting records to database, i.e.,
> if writing doesn't succeed in short time, K would give up and create en
> error message to syslog?

There is a timeout in db_mysql modules, which sets an option to
libmysqlclient, but, the docs from mysql site (at least for some
versions) said that timeout might not happen in some cases, like disk
full - I made a related comment at:

  * https://github.com/kamailio/kamailio/issues/1895#issuecomment-501139692

Also, when I got access to a system that was reported with memory leaks,
I found the timer process blocked due to a mysql query (and because
timer was blocked, expired transactions were not cleaned) -- the mysql
timeout didn't fired there:

  * https://github.com/kamailio/kamailio/issues/1895#issuecomment-500895303

That's why backtrace would help to see where the processes are stuck.

Cheers,
Daniel

-- 
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda