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 _______________________________________________ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
