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