<html>
  <head>
    <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <tt>Hi, Ahmed!<br>
      <br>
      Can you tell us exactly what revision of OpenSIPS you are using?
      Please provide the output of the following commands:<br>
      opensips -V<br>
      opensipsctl ps<br>
      <br>
      Also, during startup, is there a process who's "eating" a lot of
      CPU? If so, can you pinpoint the PID to see what type of process
      is that?<br>
      <br>
      Regarding the avp_db_query() issue, did you define a db_url
      parameter for it? Also I am not sure you can do something like
      $var(res) = avp_db_query(...). But anyways, this is something
      completely different, so please open a different topic for it.<br>
      <br>
      Best regards,<br>
    </tt>
    <pre class="moz-signature" cols="72">Răzvan Crainea
OpenSIPS Solutions
<a class="moz-txt-link-abbreviated" href="http://www.opensips-solutions.com">www.opensips-solutions.com</a></pre>
    <div class="moz-cite-prefix">On 01/14/2017 12:24 AM, Ahmed Munir
      wrote:<br>
    </div>
    <blockquote
cite="mid:CAGMN=Jf+cpkBx2RiTX976B9SnQRUZJsa6qdw0UEXanx6BTGBBA@mail.gmail.com"
      type="cite">
      <div dir="ltr">Hi,<br>
        <div>
          <div class="gmail_extra"><br>
          </div>
          <div class="gmail_extra">I've just installed new version of
            opensips 2.2.2 on the test box and updated by routing
            script, the issue currently I'm seeing alot warning messages
            while starting opensips service below;<br>
            <br>
            /usr/sbin/opensips[6902]: WARNING:core:handle_timer_job:
            utimer job <tm-utimer> has a 2830000 us delay in
            execution<br>
            <br>
          </div>
          <div class="gmail_extra">
            <div class="gmail_quote">Number of children running on that
              server is 8 as it is 8 core processor. <br>
              <br>
            </div>
            <div class="gmail_quote">I would like to know what steps do
              I need to take to fix this issue. Btw, warnings only
              occurred during the time of starting opensips service but
              not during calls.<br>
            </div>
            <div class="gmail_quote"><br>
              <br>
            </div>
            <div class="gmail_quote">Further added, a issue I face using
              avp_db_query () function i.e. when using it as <br>
              <br>
              $var(res) = avp_db_query("SELECT Outpulse_number,setid
              FROM Prefix_data where Program_prefix = $var(pg_prefix)",
              "$avp(outpluse), $avp(trunkid)");<br>
              <br>
            </div>
            <div class="gmail_quote">failed to start opensips service
              due to errors below;<br>
              <br>
              ERROR:avpops:__fixup_db_query_avp: no db url defined to be
              used by this function<br>
              ERROR:core:fix_actions: fixing failed (code=-6) at
              //etc/opensips/opensips.cfg:207<br>
              CRITICAL:core:fix_expr: fix_actions error<br>
              ERROR:core:main: failed to fix configuration with err code
              -6<br>
              <br>
              <br>
            </div>
            <div class="gmail_quote">If I add this line:
              avp_db_query("SELECT 1"); above to my $var(res) db query,
              opensips service starts successfully.<br>
              <br>
            </div>
            <div class="gmail_quote">Please advise the steps do I need
              to take to fix above issues.<br>
            </div>
            <div class="gmail_quote"> <br>
            </div>
            <div class="gmail_quote"><br>
              <blockquote class="gmail_quote" style="margin:0px 0px 0px
                0.8ex;border-left:1px solid
                rgb(204,204,204);padding-left:1ex"><br>
                From: Răzvan Crainea <<a moz-do-not-send="true"
                  href="mailto:razvan@opensips.org">razvan@opensips.org</a>><br>
                To: <a moz-do-not-send="true"
                  href="mailto:users@lists.opensips.org">users@lists.opensips.org</a><br>
                Subject: Re: [OpenSIPS-Users] OpenSIPs crashed<br>
                Message-ID: <<a moz-do-not-send="true"
                  href="mailto:40f6dada-e121-a2da-b283-69dff891cd11@opensips.org">40f6dada-e121-a2da-b283-<wbr>69dff891cd11@opensips.org</a>><br>
                Content-Type: text/plain; charset="utf-8";
                Format="flowed"<br>
                <br>
                Hi, Ahmed!<br>
                <br>
                OpenSIPS 1.6.3 is no longer supported (since 2013), so
                there's not much<br>
                we can do right now. Try upgrading your install to the
                latest 1.6.4<br>
                version and see if your problem is solved. Otherwise,
                upgrade to a<br>
                newer, supported version, preferably the latest stable
                release, 2.2.2.<br>
                <br>
                Best regards,<br>
                <br>
                Răzvan Crainea<br>
                OpenSIPS Solutions<br>
                <a moz-do-not-send="true"
                  href="http://www.opensips-solutions.com"
                  rel="noreferrer" target="_blank">www.opensips-solutions.com</a><br>
                <br>
                On 01/12/2017 11:55 PM, Ahmed Munir wrote:<br>
                > Found coredump on one of the server, see some
                partial message below<br>
                > while taking the back trace;<br>
                ><br>
                ><br>
                ><br>
                > Core was generated by `/usr/sbin/opensips -P
                /var/run/opensips.pid -m<br>
                > 64 -u opensips -g opensips'.<br>
                ><br>
                > Program terminated with signal 11, Segmentation
                fault.<br>
                ><br>
                > #0  0x00007f650687a069 in sip_msg_cloner () from<br>
                > /usr/lib64/opensips/modules/<wbr>tm.so<br>
                ><br>
                > Missing separate debuginfos, use: debuginfo-install<br>
                > opensips-1.6.3-notls.x86_64<br>
                ><br>
                ><br>
                ><br>
                > Please advise what might be the reason causing
                opensips to crash.<br>
                ><br>
                >      --<br>
                >     Regards,<br>
                ><br>
                >     Ahmed Munir Chohan<br>
                ><br>
                ><br>
                ><br>
                ><br>
                > --<br>
                > Regards,<br>
                ><br>
                > Ahmed Munir Chohan<br>
                ><br>
              </blockquote>
            </div>
            <br>
            <br clear="all">
            <br>
            -- <br>
            <div class="gmail_signature">Regards,<br>
              <br>
              Ahmed Munir Chohan<br>
              <br>
            </div>
          </div>
        </div>
      </div>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <br>
      <pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
    </blockquote>
    <br>
  </body>
</html>