<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hello,<br>
<br>
do you call any sql query in failure routes?<br>
<br>
I want to see of worth looking at if the query is too slow for the
transaction to stay in memory after there is a final response to it.<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<div class="moz-cite-prefix">On 16/01/14 11:51, Uri Shacked wrote:<br>
</div>
<blockquote
cite="mid:CAMMbDhQhNk6EQwnzPHX2F9BVfd7hyjVFqVsjKRjk9A8Ug67Kow@mail.gmail.com"
type="cite">
<div dir="ltr"><br>
<div class="gmail_quote">
<div dir="ltr">
<p class="MsoNormal" style="margin:0cm 0cm
0.0001pt;direction:ltr;font-size:11pt;font-family:Calibri,sans-serif">Daniel
hi,</p>
<p class="MsoNormal" style="margin:0cm 0cm
0.0001pt;direction:ltr;font-size:11pt;font-family:Calibri,sans-serif">
</p>
<p class="MsoNormal" style="margin:0cm 0cm
0.0001pt;direction:ltr;font-size:11pt;font-family:Calibri,sans-serif">I
attached the following file:</p>
<p
style="font-family:arial,sans-serif;font-size:13px;margin-right:0cm;margin-left:36pt;margin-bottom:0.0001pt;direction:ltr">1.<span
style="font-size:7pt;font-family:'Times New Roman'"> </span><span
dir="LTR"></span>"bt full" and "log" for each of the 3
servers.</p>
<p
style="font-family:arial,sans-serif;font-size:13px;margin-right:0cm;margin-left:36pt;margin-bottom:0.0001pt;direction:ltr">2.<span
style="font-size:7pt;font-family:'Times New Roman'"> </span><span
dir="LTR"></span>The central MySQL slow queries log</p>
<p
style="font-family:arial,sans-serif;font-size:13px;margin-right:0cm;margin-left:36pt;margin-bottom:0.0001pt;direction:ltr">3.<span
style="font-size:7pt;font-family:'Times New Roman'"> </span><span
dir="LTR"></span>The var/log/messages from one server.</p>
<p class="MsoNormal" style="margin:0cm 0cm
0.0001pt;direction:ltr;font-size:11pt;font-family:Calibri,sans-serif"> </p>
<p class="MsoNormal" style="margin:0cm 0cm
0.0001pt;direction:ltr;font-size:11pt;font-family:Calibri,sans-serif">
The servers crashed at different times but:</p>
<p
style="font-family:arial,sans-serif;font-size:13px;margin-right:0cm;margin-left:36pt;margin-bottom:0.0001pt;direction:ltr">1.<span
style="font-size:7pt;font-family:'Times New Roman'"> </span><span
dir="LTR"></span>The MySQL server was very slow between
16:10:00 till 16:12:00 (approximately).</p>
<p
style="font-family:arial,sans-serif;font-size:13px;margin-right:0cm;margin-left:36pt;margin-bottom:0.0001pt;direction:ltr">2.<span
style="font-size:7pt;font-family:'Times New Roman'"> </span><span
dir="LTR"></span>On each server, I am pretty sure,
kamailio crashed while doing the data reload from modules
like MTREE, HTABLE, DIALPLAN and CARRIERROUTE (all and all
round 100,000 rows).</p>
<p class="MsoNormal" style="margin:0cm 0cm
0.0001pt;direction:ltr;font-size:11pt;font-family:Calibri,sans-serif">Thanks
again,</p>
<p class="MsoNormal" style="margin:0cm 0cm
0.0001pt;direction:ltr;font-size:11pt;font-family:Calibri,sans-serif">
Uri</p>
</div>
<div class="HOEnZb">
<div class="h5">
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Thu, Jan 16, 2014 at 2:17
AM, Daniel-Constantin Mierla <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:daniel@asipto.com" target="_blank">daniel@asipto.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF"> Hello,<br>
<br>
the backtrace shows a crash in tm module, not
sqlops.<br>
<br>
Can you tell which of the log files correspond to
the instance that produced the core file from
where you took the back trace you attached?<br>
<br>
Can you give the backtraces from all cores? You
say there were 3 crashes. It is important to see
if the backtrace is the same everywhere.<br>
<br>
Cheers,<br>
Daniel</div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<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></pre>
</body>
</html>