<div dir="ltr"><pre style="white-space:pre-wrap">Hi,</pre><pre style="white-space:pre-wrap">I do use SQL query in several places.</pre><pre style="white-space:pre-wrap">1. In the failure route to insert an event to the local DB where ACC module does not do it. It is an insert to the local server DB and seems to be very fast.</pre>
<pre style="white-space:pre-wrap">2. In the "event_route[<b>dialog:end</b>]" I call a procedure to delete a row based on the callid as primary key. This is on the central DB and might be slow when the DB is down or network is slow.</pre>
<pre style="white-space:pre-wrap"><pre style="white-space:pre-wrap">2. In the "event_route[<b>dialog:failure</b>]" I call a procedure to delete a row based on the callid as primary key. This is on the central DB and might be slow when the DB is down or network is slow.</pre>
</pre>
<pre style="white-space:pre-wrap">Thanks,</pre><pre style="white-space:pre-wrap">Uri</pre><pre style="white-space:pre-wrap">>Hello,
>
>do you call any sql query in failure routes?
>
>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.
>
>Cheers,
>Daniel
</pre><div><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Jan 16, 2014 at 12:51 PM, Uri Shacked <span dir="ltr"><<a href="mailto:ushacked@gmail.com" target="_blank">ushacked@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><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,<u></u><u></u></p><div class="im"><p class="MsoNormal" style="margin:0cm 0cm 0.0001pt;direction:ltr;font-size:11pt;font-family:Calibri,sans-serif">
<u></u> <u></u></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:<u></u><u></u></p><p style="font-family:arial,sans-serif;font-size:13px;margin-right:0cm;margin-left:36pt;margin-bottom:0.0001pt;direction:ltr">
<u></u>1.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u><span dir="LTR"></span>"bt full" and "log" for each of the 3 servers.<u></u><u></u></p>
<p style="font-family:arial,sans-serif;font-size:13px;margin-right:0cm;margin-left:36pt;margin-bottom:0.0001pt;direction:ltr"><u></u>2.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u><span dir="LTR"></span>The central MySQL slow queries log<u></u><u></u></p>
<p style="font-family:arial,sans-serif;font-size:13px;margin-right:0cm;margin-left:36pt;margin-bottom:0.0001pt;direction:ltr"><u></u>3.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u><span dir="LTR"></span>The var/log/messages from one server.<u></u><u></u></p>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt;direction:ltr;font-size:11pt;font-family:Calibri,sans-serif"><u></u> <u></u></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:<u></u><u></u></p><p style="font-family:arial,sans-serif;font-size:13px;margin-right:0cm;margin-left:36pt;margin-bottom:0.0001pt;direction:ltr"><u></u>1.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u><span dir="LTR"></span>The MySQL server was very slow between 16:10:00 till 16:12:00 (approximately).<u></u><u></u></p>
<p style="font-family:arial,sans-serif;font-size:13px;margin-right:0cm;margin-left:36pt;margin-bottom:0.0001pt;direction:ltr"><u></u>2.<span style="font-size:7pt;font-family:'Times New Roman'"> </span><u></u><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).<u></u><u></u></p>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt;direction:ltr;font-size:11pt;font-family:Calibri,sans-serif">Thanks again,<u></u><u></u></p><p class="MsoNormal" style="margin:0cm 0cm 0.0001pt;direction:ltr;font-size:11pt;font-family:Calibri,sans-serif">
Uri</p></div></div><div class="im"><div><div><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 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></div>
</blockquote></div><br></div>