<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Segoe UI";
panose-1:2 11 5 2 4 2 4 2 2 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">Thanks, Walter. I will throw more hardware at it and see if this resolves the issues. The new system is running nearly the same specs as the 3.7.1 system except twice as many cpu cores. But SSD and more memory isn’t ever a bad idea.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I am much more concerned with the calls ending early. It has happened on 3 out of 10 calls today. I am going to try upgrading the hardware first, then revisit the new version of LTS.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks again!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Bill<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Walter Klomp [mailto:walter@myrepublic.net] <br>
<b>Sent:</b> Thursday, May 25, 2017 5:23 PM<br>
<b>To:</b> William Fulton <wfulton@thirdhatch.com><br>
<b>Cc:</b> spce-user@lists.sipwise.com<br>
<b>Subject:</b> Re: [Spce-user] Questions about mr4.5.4<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Hi Bill,<o:p></o:p></p>
</div>
<div id="AppleMailSignature">
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div id="AppleMailSignature">
<p class="MsoNormal">Depends a bit on how many users you have. MySQL is by far the biggest bottleneck in the operations and giving it more RAM (16GB minimum) and SSD drives (bigger impact) have helped us preventing these issues. (Obviously with 1 customer
this should not happen)<o:p></o:p></p>
</div>
<div id="AppleMailSignature">
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div id="AppleMailSignature">
<p class="MsoNormal">The log messages are just warnings as far as I know, shouldn't affect normal operations. <o:p></o:p></p>
</div>
<div id="AppleMailSignature">
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div id="AppleMailSignature">
<p class="MsoNormal">You may even want to look at MySQL slow logs as there are a few optimizations I made on indexes (just can't remember). The fraud script also is a very lengthy query that requires a lot of RAM and better indexing, especially if you have
a lot of customers (I'm running SPCE 3.8.x with > 40k live subscribers on a dell power edge with 4 cores and 1 half-hourly run takes about 5-10 minutes, with SSD.)<br>
<br>
Yours sincerely,<o:p></o:p></p>
<div>
<p class="MsoNormal">Walter<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
On 26 May 2017, at 6:21 AM, William Fulton <<a href="mailto:wfulton@thirdhatch.com">wfulton@thirdhatch.com</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal">As an update, we started getting this message as well just before calls are terminate early before either party hangs up:<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">WARNING: dialog [dlg_handlers.c:1226]: dlg_onroute(): unable to find dialog for ACK with route param '9a.9cf1' [169:8137]<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Thanks,<o:p></o:p></p>
<p class="MsoNormal">Bill<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Spce-user [<a href="mailto:spce-user-bounces@lists.sipwise.com">mailto:spce-user-bounces@lists.sipwise.com</a>]
<b>On Behalf Of </b>William Fulton<br>
<b>Sent:</b> Thursday, May 25, 2017 12:23 PM<br>
<b>To:</b> <a href="mailto:spce-user@lists.sipwise.com">spce-user@lists.sipwise.com</a><br>
<b>Subject:</b> [Spce-user] Questions about mr4.5.4<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="left" width="100%" style="width:100.0%">
<tbody>
<tr>
<td style="background:#910A19;padding:5.25pt 1.5pt 5.25pt 1.5pt"></td>
<td width="100%" style="width:100.0%;background:#FDF2F4;padding:5.25pt 3.75pt 5.25pt 11.25pt;word-wrap:break-word">
<p class="MsoNormal" style="mso-element:frame;mso-element-frame-hspace:1.8pt;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly">
<span style="font-size:9.0pt;font-family:"Segoe UI",sans-serif;color:#212121">This sender failed our fraud detection checks and may not be who they appear to be. Learn about <a href="http://aka.ms/LearnAboutSpoofing">spoofing</a></span><o:p></o:p></p>
</td>
<td width="75" style="width:56.25pt;background:#FDF2F4;padding:5.25pt 3.75pt 5.25pt 3.75pt;word-wrap:break-word;align:left">
<p class="MsoNormal" style="mso-element:frame;mso-element-frame-hspace:1.8pt;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly">
<span style="font-size:9.0pt;font-family:"Segoe UI",sans-serif;color:#212121"><a href="http://aka.ms/SafetyTipsFeedback">Feedback</a></span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<div>
<p class="MsoNormal">Hello,<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt">We have been using mr3.7.1 with very few problems for the past few years. The only minor thing we found is that around 180 days or so we have to perform a reboot or our sip clients lose connectivity at random
intervals. This is all manageable and not really an issue for us. However, we want to move to mr4.5.4 LTS version. I have been testing this for a few days with the same sip providers, but am getting some warnings and errors in the proxy log as well as what
seems like inconsistent call connectivity. Here are the Notices we are getting:<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">NOTICE: <core> [action.c:1560]: run_actions(): alert - action [save (25)] cfg [/etc/kamailio/proxy/registrar.cfg:159] took too long [125 ms]<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">NOTICE: <core> [db_query.c:60]: db_do_submit_query(): alert - query execution too long [125 ms] for [update `location` set `expires`='2017-05-25 12:13:]<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">NOTICE: <core> [db_query.c:60]: db_do_submit_query(): alert - query execution too long [125 ms] for [update `dialog` set `state`=4,`timeout`=1495782546]<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"> <o:p></o:p></p>
<p class="MsoNormal">Is it possible that some of these notices are the cause of our inconsistent connectivity? I’m surprised that query executions are taking too long. This is a test server with one subscriber. It also has a lot of processing power with 8 Xeon
cores and 4GB of memory with SAS hard drives. Does anyone have any insight in to what could be the cause of these notices? Are they normal? Can I make adjustments to the config.yml to fix them?<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Thanks,<o:p></o:p></p>
<p class="MsoNormal">Bill<o:p></o:p></p>
</div>
</div>
</blockquote>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal">_______________________________________________<br>
Spce-user mailing list<br>
<a href="mailto:Spce-user@lists.sipwise.com">Spce-user@lists.sipwise.com</a><br>
<a href="https://lists.sipwise.com/listinfo/spce-user">https://lists.sipwise.com/listinfo/spce-user</a><o:p></o:p></p>
</div>
</blockquote>
</div>
</body>
</html>