<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <div class="moz-cite-prefix"><tt>Hi Pasan,<br>
        <br>
        What db_mode do you use in the usrloc module ? I hope not 3 :D .<br>
        <br>
        Regards,<br>
      </tt>
      <pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
      On 28.07.2014 05:18, Pasan Meemaduma wrote:<br>
    </div>
    <blockquote
      cite="mid:1406513902.81651.YahooMailNeo@web163402.mail.gq1.yahoo.com"
      type="cite">
      <div style="color:#000; background-color:#fff; font-family:times
        new roman, new york, times, serif;font-size:10pt">
        <div><span>Hi Bogdan,</span></div>
        <div style="color: rgb(0, 0, 0); font-size: 13.3333px;
          font-family: times new roman,new york,times,serif;
          background-color: transparent; font-style: normal;"><br>
          <span></span></div>
        <div style="color: rgb(0, 0, 0); font-size: 13.3333px;
          font-family: times new roman,new york,times,serif;
          background-color: transparent; font-style: normal;"><span>I
            looked at the cpu graphs with nh-timer warning times theres
            no indication of noticable spikes on that time.</span></div>
        <div class="qtdSeparateBR"><br>
          <br>
        </div>
        <div style="display: block;" class="yahoo_quoted">
          <div style="font-family: times new roman, new york, times,
            serif; font-size: 10pt;">
            <div style="font-family: times new roman, new york, times,
              serif; font-size: 12pt;">
              <div dir="ltr"> <font face="Arial" size="2"> On Friday,
                  25 July 2014, 7:06, Pasan Meemaduma
                  <a class="moz-txt-link-rfc2396E" href="mailto:pasandev@ymail.com">&lt;pasandev@ymail.com&gt;</a> wrote:<br>
                </font> </div>
              <br>
              <br>
              <div class="y_msg_container">
                <div id="yiv6183655194">
                  <div>
                    <div
                      style="color:#000;background-color:#fff;font-family:times
                      new roman, new york, times, serif;font-size:10pt;">
                      <div><span>Hi Bogdan,</span></div>
                      <div style="color:rgb(0, 0,
                        0);font-size:13.3333px;font-family:times new
                        roman, new york, times,
                        serif;background-color:transparent;font-style:normal;"><br
                          clear="none">
                        <span></span></div>
                      <div style="color:rgb(0, 0,
                        0);font-size:13.3333px;font-family:times new
                        roman, new york, times,
                        serif;background-color:transparent;font-style:normal;"><span>Nope
                          , I could only see IPs in contact fields.</span></div>
                      <div class="yiv6183655194qtdSeparateBR"><br
                          clear="none">
                        <br clear="none">
                      </div>
                      <div class="yiv6183655194yahoo_quoted"
                        style="display:block;">
                        <div style="font-family:times new roman, new
                          york, times, serif;font-size:10pt;">
                          <div style="font-family:times new roman, new
                            york, times, serif;font-size:12pt;">
                            <div class="yiv6183655194yqt3150432314"
                              id="yiv6183655194yqt51496">
                              <div dir="ltr"> <font face="Arial"
                                  size="2"> On Thursday, 24 July 2014,
                                  15:33, Pasan Meemaduma
                                  <a class="moz-txt-link-rfc2396E" href="mailto:pasandev@ymail.com">&lt;pasandev@ymail.com&gt;</a> wrote:<br
                                    clear="none">
                                </font> </div>
                              <br clear="none">
                              <br clear="none">
                              <div class="yiv6183655194y_msg_container">
                                <div id="yiv6183655194">
                                  <div>
                                    <div
                                      style="color:#000;background-color:#fff;font-family:times
                                      new roman, new york, times,
                                      serif;font-size:10pt;">Hi Bogdan,<br
                                        class="yiv6183655194" style=""
                                        clear="none">
                                      <br class="yiv6183655194" style=""
                                        clear="none">
                                      <tt class="yiv6183655194" style="">No
                                        TCP clients, only udp allowed.
                                        yes some clients uses dns <br
                                          class="yiv6183655194" style=""
                                          clear="none">
                                        <br class="yiv6183655194"
                                          style="" clear="none">
                                        select count(*) from location;<br
                                          class="yiv6183655194" style=""
                                          clear="none">
                                        +----------+<br
                                          class="yiv6183655194" style=""
                                          clear="none">
                                        | count(*) |<br
                                          class="yiv6183655194" style=""
                                          clear="none">
                                        +----------+<br
                                          class="yiv6183655194" style=""
                                          clear="none">
                                        |&nbsp;&nbsp;&nbsp;&nbsp; 7419 |<br clear="none">
                                        <br clear="none">
                                        I got about 7K- 8K in location
                                        table<br class="yiv6183655194"
                                          style="" clear="none">
                                      </tt>
                                      <div
                                        class="yiv6183655194qtdSeparateBR"><br
                                          clear="none">
                                        <br clear="none">
                                      </div>
                                      <div
                                        class="yiv6183655194yahoo_quoted"
                                        style="display:block;">
                                        <div class="yiv6183655194"
                                          style="font-family:times new
                                          roman, new york, times,
                                          serif;font-size:10pt;">
                                          <div class="yiv6183655194"
                                            style="font-family:times new
                                            roman, new york, times,
                                            serif;font-size:12pt;">
                                            <div class="yiv6183655194"
                                              style="">
                                              <div
                                                class="yiv6183655194yqt7288967408"
id="yiv6183655194yqt33608">
                                                <div
                                                  class="yiv6183655194"
                                                  id="yiv6183655194"
                                                  style="">
                                                  <div
                                                    class="yiv6183655194"
                                                    style="">
                                                    <div
                                                      class="yiv6183655194"
                                                      style="color:#000;background-color:#fff;font-family:times
                                                      new roman, new
                                                      york, times,
                                                      serif;font-size:10pt;">
                                                      <div
                                                        class="yiv6183655194"
                                                        style=""><br
                                                          class="yiv6183655194"
                                                          style=""
                                                          clear="none">
                                                      </div>
                                                      <div
                                                        class="yiv6183655194"
                                                        style=""><br
                                                          class="yiv6183655194"
                                                          style=""
                                                          clear="none">
                                                        <br
                                                          class="yiv6183655194"
                                                          style=""
                                                          clear="none">
                                                      </div>
                                                      <div
                                                        class="yiv6183655194"
style="display:block;">
                                                        <div
                                                          class="yiv6183655194"
                                                          style="font-family:times
                                                          new roman, new
                                                          york, times,
                                                          serif;font-size:10pt;">
                                                          <div
                                                          class="yiv6183655194"
                                                          style="font-family:times
                                                          new roman, new
                                                          york, times,
                                                          serif;font-size:12pt;">
                                                          <div
                                                          class="yiv6183655194"
                                                          dir="ltr"
                                                          style=""> <font
class="yiv6183655194" style="" face="Arial" size="2"> On Wednesday, 23
                                                          July 2014,
                                                          19:35,
                                                          Bogdan-Andrei
                                                          Iancu
                                                          <a class="moz-txt-link-rfc2396E" href="mailto:bogdan@opensips.org">&lt;bogdan@opensips.org&gt;</a>
                                                          wrote:<br
                                                          class="yiv6183655194"
                                                          style=""
                                                          clear="none">
                                                          </font> </div>
                                                          <br
                                                          class="yiv6183655194"
                                                          style=""
                                                          clear="none">
                                                          <br
                                                          class="yiv6183655194"
                                                          style=""
                                                          clear="none">
                                                          <div
                                                          class="yiv6183655194"
                                                          style="">
                                                          <div
                                                          class="yiv6183655194"
id="yiv6183655194" style="">
                                                          <div
                                                          class="yiv6183655194"
                                                          style="">
                                                          <div
                                                          class="yiv6183655194"
                                                          style=""><tt
                                                          class="yiv6183655194"
                                                          style="">Hi
                                                          Pasan,<br
                                                          class="yiv6183655194"
                                                          style=""
                                                          clear="none">
                                                          <br
                                                          class="yiv6183655194"
                                                          style=""
                                                          clear="none">
                                                          Do you have
                                                          TCP clients ?
                                                          or do you have
                                                          clients
                                                          registering
                                                          DNS contacts ?
                                                          How many
                                                          records are in
                                                          usrloc ?<br
                                                          class="yiv6183655194"
                                                          style=""
                                                          clear="none">
                                                          No TCP
                                                          clients, only
                                                          udp allowed.
                                                          yes some
                                                          clients uses
                                                          dns <br
                                                          class="yiv6183655194"
                                                          style=""
                                                          clear="none">
                                                          <br
                                                          class="yiv6183655194"
                                                          style=""
                                                          clear="none">
                                                          select
                                                          count(*) from
                                                          location;<br
                                                          class="yiv6183655194"
                                                          style=""
                                                          clear="none">
                                                          +----------+<br
class="yiv6183655194" style="" clear="none">
                                                          | count(*) |<br
class="yiv6183655194" style="" clear="none">
                                                          +----------+<br
class="yiv6183655194" style="" clear="none">
                                                          |&nbsp;&nbsp;&nbsp;&nbsp; 7419 |</tt>
                                                          <div
                                                          class="yiv6183655194"
id="yiv6183655194yqtfd78640" style=""><tt class="yiv6183655194" style=""><br
class="yiv6183655194" style="" clear="none">
                                                          +----------+<br
class="yiv6183655194" style="" clear="none">
                                                          <br
                                                          class="yiv6183655194"
                                                          style=""
                                                          clear="none">
                                                          <br
                                                          class="yiv6183655194"
                                                          style=""
                                                          clear="none">
                                                          Regards,<br
                                                          class="yiv6183655194"
                                                          style=""
                                                          clear="none">
                                                          </tt></div>
                                                          <div
                                                          class="yiv6183655194"
id="yiv6183655194yqtfd50103" style="">
                                                          <pre class="yiv6183655194" style="">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a moz-do-not-send="true" rel="nofollow" shape="rect" class="yiv6183655194" style="" target="_blank" href="http://www.opensips-solutions.com/">http://www.opensips-solutions.com</a></pre>
                                                          On 21.07.2014
                                                          05:18, Pasan
                                                          Meemaduma
                                                          wrote:<br
                                                          class="yiv6183655194"
                                                          style=""
                                                          clear="none">
                                                          </div>
                                                          </div>
                                                          <div
                                                          class="yiv6183655194"
id="yiv6183655194yqtfd82898" style="">
                                                          <blockquote
                                                          class="yiv6183655194"
                                                          style=""
                                                          type="cite">
                                                          <div
                                                          class="yiv6183655194"
id="yiv6183655194yqt53717" style="">
                                                          <div
                                                          class="yiv6183655194"
                                                          style="color:#000;background-color:#fff;font-family:times
                                                          new roman, new
                                                          york, times,
                                                          serif;font-size:10pt;">
                                                          <div
                                                          class="yiv6183655194"
                                                          style="">Hey
                                                          Guys,</div>
                                                          <div
                                                          class="yiv6183655194"
                                                          style=""><br
                                                          class="yiv6183655194"
                                                          style=""
                                                          clear="none">
                                                          </div>
                                                          <div
                                                          class="yiv6183655194"
                                                          style="color:rgb(0,
                                                          0,
                                                          0);font-size:13.3333px;font-family:times
                                                          new roman, new
                                                          york, times,
                                                          serif;background-color:transparent;font-style:normal;">I'm
                                                          using opensips
                                                          1.10.1-1 on a
                                                          debian server
                                                          with wheezy,
                                                          its running on
                                                          a kvm guest. I
                                                          started to
                                                          observe the
                                                          below error in
                                                          opensips. Any
                                                          idea what
                                                          causing it ?</div>
                                                          <div
                                                          class="yiv6183655194"
                                                          style="color:rgb(0,
                                                          0,
                                                          0);font-size:13.3333px;font-family:times
                                                          new roman, new
                                                          york, times,
                                                          serif;background-color:transparent;font-style:normal;"><br
class="yiv6183655194" style="" clear="none">
                                                          </div>
                                                          <div
                                                          class="yiv6183655194"
                                                          style="color:rgb(0,
                                                          0,
                                                          0);font-size:13.3333px;font-family:times
                                                          new roman, new
                                                          york, times,
                                                          serif;background-color:transparent;font-style:normal;">Jul
                                                          20 09:01:28
                                                          /usr/sbin/opensips[29968]:
                                                          CRITICAL:core:timer_ticker:
                                                          timer handler
                                                          &lt;nh-timer&gt;

                                                          lasted
                                                          (4960000 us)
                                                          for more than
                                                          timer tick
                                                          (1000000 us)
                                                          -&gt;
                                                          potential
                                                          timer shifting<br
class="yiv6183655194" style="" clear="none">
                                                          </div>
                                                          <div
                                                          class="yiv6183655194"
                                                          style="color:rgb(0,
                                                          0,
                                                          0);font-size:13.3333px;font-family:times
                                                          new roman, new
                                                          york, times,
                                                          serif;background-color:transparent;font-style:normal;"><br
class="yiv6183655194" style="" clear="none">
                                                          </div>
                                                          <div
                                                          class="yiv6183655194"
                                                          style="color:rgb(0,
                                                          0,
                                                          0);font-size:13.3333px;font-family:times
                                                          new roman, new
                                                          york, times,
                                                          serif;background-color:transparent;font-style:normal;">I
                                                          have 15seconds
                                                          configured for
                                                          nat ping timer
                                                          <br
                                                          class="yiv6183655194"
                                                          style=""
                                                          clear="none">
                                                          </div>
                                                          <div
                                                          class="yiv6183655194"
                                                          style="color:rgb(0,
                                                          0,
                                                          0);font-size:13.3333px;font-family:times
                                                          new roman, new
                                                          york, times,
                                                          serif;background-color:transparent;font-style:normal;"><br
class="yiv6183655194" style="" clear="none">
                                                          </div>
                                                          <div
                                                          class="yiv6183655194"
                                                          style="color:rgb(0,
                                                          0,
                                                          0);font-size:13.3333px;font-family:times
                                                          new roman, new
                                                          york, times,
                                                          serif;background-color:transparent;font-style:normal;">modparam("nathelper",

                                                          "natping_interval",
                                                          15)<br
                                                          class="yiv6183655194"
                                                          style=""
                                                          clear="none">
                                                          </div>
                                                          <div
                                                          class="yiv6183655194"
                                                          style="color:rgb(0,
                                                          0,
                                                          0);font-size:13.3333px;font-family:times
                                                          new roman, new
                                                          york, times,
                                                          serif;background-color:transparent;font-style:normal;"><br
class="yiv6183655194" style="" clear="none">
                                                          </div>
                                                          <div
                                                          class="yiv6183655194"
                                                          style="color:rgb(0,
                                                          0,
                                                          0);font-size:13.3333px;font-family:times
                                                          new roman, new
                                                          york, times,
                                                          serif;background-color:transparent;font-style:normal;">How
                                                          can I fix this
                                                          issue ?<br
                                                          class="yiv6183655194"
                                                          style=""
                                                          clear="none">
                                                          </div>
                                                          </div>
                                                          </div>
                                                          <br
                                                          class="yiv6183655194"
                                                          style=""
                                                          clear="none">
                                                          <fieldset
                                                          class="yiv6183655194"
                                                          style=""></fieldset>
                                                          <br
                                                          class="yiv6183655194"
                                                          style=""
                                                          clear="none">
                                                          <pre class="yiv6183655194" style="">_______________________________________________
Users mailing list
<a moz-do-not-send="true" rel="nofollow" shape="rect" class="yiv6183655194" style="" ymailto="mailto:Users@lists.opensips.org" target="_blank" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a moz-do-not-send="true" rel="nofollow" shape="rect" class="yiv6183655194" style="" target="_blank" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
                                                          </blockquote>
                                                          <br
                                                          class="yiv6183655194"
                                                          style=""
                                                          clear="none">
                                                          </div>
                                                          </div>
                                                          </div>
                                                          <div
                                                          class="yiv6183655194"
id="yiv6183655194yqtfd34936" style=""><br class="yiv6183655194" style=""
                                                          clear="none">
                                                          <br
                                                          class="yiv6183655194"
                                                          style=""
                                                          clear="none">
                                                          </div>
                                                          </div>
                                                          <div
                                                          class="yiv6183655194"
id="yiv6183655194yqtfd21634" style=""> </div>
                                                          </div>
                                                          <div
                                                          class="yiv6183655194"
id="yiv6183655194yqtfd50323" style=""> </div>
                                                        </div>
                                                        <div
                                                          class="yiv6183655194"
id="yiv6183655194yqtfd47007" style=""> </div>
                                                      </div>
                                                      <div
                                                        class="yiv6183655194"
id="yiv6183655194yqtfd66205" style=""> </div>
                                                    </div>
                                                  </div>
                                                </div>
                                              </div>
                                              <br class="yiv6183655194"
                                                style="" clear="none">
                                              <div class="yiv6183655194"
id="yiv6183655194yqtfd74405" style="">_______________________________________________<br
                                                  class="yiv6183655194"
                                                  style="" clear="none">
                                                Users mailing list<br
                                                  class="yiv6183655194"
                                                  style="" clear="none">
                                                <a
                                                  moz-do-not-send="true"
                                                  rel="nofollow"
                                                  shape="rect"
                                                  class="yiv6183655194"
                                                  style=""
                                                  ymailto="mailto:Users@lists.opensips.org"
                                                  target="_blank"
                                                  href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br
                                                  class="yiv6183655194"
                                                  style="" clear="none">
                                                <a
                                                  moz-do-not-send="true"
                                                  rel="nofollow"
                                                  shape="rect"
                                                  class="yiv6183655194"
                                                  style=""
                                                  target="_blank"
                                                  href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br
                                                  class="yiv6183655194"
                                                  style="" clear="none">
                                              </div>
                                              <br class="yiv6183655194"
                                                style="" clear="none">
                                              <br class="yiv6183655194"
                                                style="" clear="none">
                                            </div>
                                          </div>
                                        </div>
                                      </div>
                                    </div>
                                  </div>
                                </div>
                                <br clear="none">
                                <div class="yiv6183655194yqt7288967408"
                                  id="yiv6183655194yqt41836">_______________________________________________<br
                                    clear="none">
                                  Users mailing list<br clear="none">
                                  <a moz-do-not-send="true"
                                    rel="nofollow" shape="rect"
                                    ymailto="mailto:Users@lists.opensips.org"
                                    target="_blank"
                                    href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br
                                    clear="none">
                                  <a moz-do-not-send="true"
                                    rel="nofollow" shape="rect"
                                    target="_blank"
                                    href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br
                                    clear="none">
                                </div>
                                <br clear="none">
                                <br clear="none">
                              </div>
                            </div>
                          </div>
                        </div>
                      </div>
                    </div>
                  </div>
                </div>
                <br>
                <br>
              </div>
            </div>
          </div>
        </div>
      </div>
    </blockquote>
    <br>
  </body>
</html>