<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p><br>
</p>
<br>
<div class="moz-cite-prefix">On 03/05/16 09:01, Juha Heinanen wrote:<br>
</div>
<blockquote cite="mid:22312.19653.746966.743530@lohi.tutpro.com"
type="cite">
<pre wrap="">Daniel-Constantin Mierla writes:
</pre>
<blockquote type="cite">
<pre wrap="">These ones are no longer related to xmlrpc, but triggered by an sqlops
query - first bracktrace, the other two are during the signal
handling.
</pre>
</blockquote>
<pre wrap="">
OK, but there must be some kind of relation to xmlrpc, because I have
had this same test system running without any problems for months and
now suddenly I started to experience crashes, which happen always after
xmlrpc queries.
</pre>
<blockquote type="cite">
<pre wrap="">The one for sqlops leads quite a bit inside the libmysqlclient, which
can happen because there is a buffer overflow in kamailio for the
operations in the system memory or an issue in the libmysqlclient.
Trying to investigate on the first option -- does it happen always after
an xmlrpc command? If yes, it is any kind of command or a specific
xmlrpc command (I see you used htable.reload)?
</pre>
</blockquote>
<pre wrap="">
Yes. I made another test. I sent three xmlrpc queries (htable.reload)
and got crash after the third. Why after third could be explained by
this sql_query that gets executed once per minute:
route [cleaner] { # Clean old statistics from database
sql_query_async("sip_proxy_usage", "DELETE FROM statistics WHERE (unix_timestamp() - time_stamp) > 86400");
}
So xmlrpc query or queries did something and that something triggered
subsequent sql_query to crash.
</pre>
</blockquote>
What is the version of kamailio running there?<br>
<br>
xmlrpc is compiled by default to use system memory manager
(expecting to need big chunks for some responses), can you recompile
it to use the pkg? You have to edit modules/xmlrpc/Makefile and
remove the line:<br>
<br>
DEFS+=-DXMLRPC_SYSTEM_MALLOC<br>
<br>
If there is a buffer overflow, it should be easier to catch using
the internal memory manager checks -- some error messages should be
printed inside the syslog as well.<br>
<br>
Cheers,<br>
Daniel<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
<a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a>
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a>
Kamailio World Conference, Berlin, May 18-20, 2016 - <a class="moz-txt-link-freetext" href="http://www.kamailioworld.com">http://www.kamailioworld.com</a></pre>
</body>
</html>