<html>
  <head>
    <meta content="text/html; charset=windows-1252"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <small>Hi Rodrigo,<br>
      <br>
          Pushed a fix both into 2.2[0] and master[1] branches. If you
      still think sqlite leaks even with this fix,<br>
      please feel free to open an issue on github.<br>
      <br>
      [0]
<a class="moz-txt-link-freetext" href="https://github.com/OpenSIPS/opensips/commit/c1aa55e73f7c56ea4894997aeb7f25a03cb289cf">https://github.com/OpenSIPS/opensips/commit/c1aa55e73f7c56ea4894997aeb7f25a03cb289cf</a><br>
      [1]
<a class="moz-txt-link-freetext" href="https://github.com/OpenSIPS/opensips/commit/c1aa55e73f7c56ea4894997aeb7f25a03cb289cf">https://github.com/OpenSIPS/opensips/commit/c1aa55e73f7c56ea4894997aeb7f25a03cb289cf</a>
    </small><br>
    <pre class="moz-signature" cols="72">Regrads,
Ionut Ionita
OpenSIPS Developer</pre>
    <div class="moz-cite-prefix">On 06/17/2016 05:19 PM, Rodrigo Pimenta
      Carvalho wrote:<br>
    </div>
    <blockquote
cite="mid:BY2PR02MB1655C561280E9B9DB4F8A098B5570@BY2PR02MB1655.namprd02.prod.outlook.com"
      type="cite">
      <meta http-equiv="Content-Type" content="text/html;
        charset=windows-1252">
      <style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
      <div id="divtagdefaultwrapper"
style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
        <div>
          <p>Hi Liviu.</p>
          <p><br>
          </p>
          <p>Very good.</p>
          <p><br>
          </p>
          <p>We will see the resolution process.</p>
          Thank you very much!<br>
          <br>
          Regards.<br>
        </div>
        <br>
        <p><br>
        </p>
        <div id="Signature">
          <div name="divtagdefaultwrapper"
            style="font-family:Calibri,Arial,Helvetica,sans-serif;
            font-size:; margin:0">
            <div class="BodyFragment"><font size="2">
                <div class="PlainText">RODRIGO PIMENTA CARVALHO<br>
                  Inatel Competence Center<br>
                  Software<br>
                  Ph: +55 35 3471 9200 RAMAL 979<br>
                </div>
              </font></div>
          </div>
        </div>
        <br>
        <br>
        <div style="color: rgb(0, 0, 0);">
          <hr tabindex="-1" style="display:inline-block; width:98%">
          <div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt"
              color="#000000" face="Calibri, sans-serif"><b>De:</b>
              <a class="moz-txt-link-abbreviated" href="mailto:users-bounces@lists.opensips.org">users-bounces@lists.opensips.org</a>
              <a class="moz-txt-link-rfc2396E" href="mailto:users-bounces@lists.opensips.org">&lt;users-bounces@lists.opensips.org&gt;</a> em nome de Liviu
              Chircu <a class="moz-txt-link-rfc2396E" href="mailto:liviu@opensips.org">&lt;liviu@opensips.org&gt;</a><br>
              <b>Enviado:</b> sexta-feira, 17 de junho de 2016 11:14<br>
              <b>Para:</b> <a class="moz-txt-link-abbreviated" href="mailto:users@lists.opensips.org">users@lists.opensips.org</a><br>
              <b>Assunto:</b> Re: [OpenSIPS-Users] What is the best
              SQLite version to be used with OpenSIPS 2.2? We
              investigate a memory leak.</font>
            <div> </div>
          </div>
          <div><tt>Hi Rodrigo!<br>
              <br>
              A GitHub issue [1] regarding this leak was just reported
              today by Eric, so you can track the resolution process
              over there! You can even subscribe to that ticket if you
              have an account, in order to receive emails.<br>
              <br>
              [1]: <a moz-do-not-send="true" id="LPlnk258574"
                class="moz-txt-link-freetext"
                href="https://github.com/OpenSIPS/opensips/issues/911">
                https://github.com/OpenSIPS/opensips/issues/911</a>
              <div style="margin-bottom: 20px; overflow: auto; width:
                100%; text-indent: 0px;"
                id="LPBorder_GT_14661730827220.7344820404655459">
                <table style="width: 90%; background-color: rgb(255,
                  255, 255); position: relative; overflow: auto;
                  padding-top: 20px; padding-bottom: 20px; margin-top:
                  20px; border-top: 1px dotted rgb(200, 200, 200);
                  border-bottom: 1px dotted rgb(200, 200, 200);"
                  id="LPContainer_14661730827150.8385706328489059"
                  cellspacing="0">
                  <tbody>
                    <tr style="border-spacing: 0px;" valign="top">
                      <td colspan="1" style="width: 250px; position:
                        relative; display: table-cell; padding-right:
                        20px;"
                        id="ImageCell_14661730827170.6843827770432">
                        <div style="background-color: rgb(255, 255,
                          255); height: 250px; position: relative;
                          margin: auto; display: table; width: 250px;"
                          id="LPImageContainer_14661730827170.41546035387795444">
                          <a moz-do-not-send="true" target="_blank"
                            href="https://github.com/OpenSIPS/opensips/issues/911"
                            style="display: table-cell; text-align:
                            center;"
                            id="LPImageAnchor_14661730827170.83910842926327"><img
                              moz-do-not-send="true" aria-label="Imagem
                              de visualização com link selecionado.
                              Toque duas vezes para abrir o link."
                              style="display: inline-block; margin-left:
                              auto; margin-right: auto; max-width:
                              250px; max-height: 250px; height: 250px;
                              width: 250px; border-width: 0px;
                              vertical-align: bottom;"
                              src="https://avatars3.githubusercontent.com/u/21685?v=3&amp;s=400"
                              height="250" width="250"></a></div>
                      </td>
                      <td colspan="2" style="vertical-align: top;
                        position: relative; padding: 0px; display:
                        table-cell;"
                        id="TextCell_14661730827180.3816031677345342">
                        <div style="top: 0px; color: rgb(0, 120, 215);
                          font-weight: 400; font-size: 21px;
                          font-family:
                          &quot;wf_segoe-ui_light&quot;,&quot;Segoe UI
                          Light&quot;,&quot;Segoe WP
                          Light&quot;,&quot;Segoe UI&quot;,&quot;Segoe
                          WP&quot;,Tahoma,Arial,sans-serif; line-height:
                          21px;"
                          id="LPTitle_14661730827180.6069792356056238">
                          <a moz-do-not-send="true" target="_blank"
                            href="https://github.com/OpenSIPS/opensips/issues/911"
                            style="text-decoration: none;"
                            id="LPUrlAnchor_14661730827190.5211874584329679">2.2
                            runs out of pkg_mem because of db/db_res.c
                            memory leak · Issue #911 · OpenSIPS/opensips</a></div>
                        <div style="margin: 10px 0px 16px; color:
                          rgb(102, 102, 102); font-weight: 400;
                          font-family:
                          &quot;wf_segoe-ui_normal&quot;,&quot;Segoe
                          UI&quot;,&quot;Segoe
                          WP&quot;,Tahoma,Arial,sans-serif; font-size:
                          14px; line-height: 14px;"
                          id="LPMetadata_14661730827200.036808617204725724">
                          github.com</div>
                        <div style="display: block; color: rgb(102, 102,
                          102); font-weight: 400; font-family:
                          &quot;wf_segoe-ui_normal&quot;,&quot;Segoe
                          UI&quot;,&quot;Segoe
                          WP&quot;,Tahoma,Arial,sans-serif; font-size:
                          14px; line-height: 20px; max-height: 100px;
                          overflow: hidden;"
                          id="LPDescription_14661730827210.11339707680130573">
                          OpenSIPS 2.2 will run out of pkg_mem, i
                          believe because of a leak in db/db_res.c Full
                          memlog dump is available here:
                          <a class="moz-txt-link-freetext" href="https://gist.github.com/etamme/7d42024ad684fe834b9fd514d2bd2412">https://gist.github.com/etamme/7d42024ad684fe834b9fd514d2bd2412</a>
                          I am using...</div>
                      </td>
                    </tr>
                  </tbody>
                </table>
              </div>
              <br>
            </tt>
            <pre class="moz-signature" cols="72">Liviu Chircu
OpenSIPS Developer
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
            <div class="moz-cite-prefix">On 17.06.2016 17:02, Rodrigo
              Pimenta Carvalho wrote:<br>
            </div>
            <blockquote type="cite">
              <div id="divtagdefaultwrapper" style="font-size:12pt;
                color:#000000; background-color:#FFFFFF;
                font-family:Calibri,Arial,Helvetica,sans-serif">
                <p>Hi.</p>
                <p><br>
                  People from my team is investigating a memory leak
                  related to OpenSIPS 2.2.</p>
                <p><br>
                </p>
                <p>As I had commented in another discussion in the past,
                  it seems that the problem comes from SQLite we are
                  using as the Registrar for our OpenSIPS 2.2.</p>
                <p>For example, a script opensips.cfg that doesn't use
                  SQLite didn't cause memory leak. But, a script that
                  uses it and use another module that needs a database
                  (EX: auth.so) causes memory leak.</p>
                <p><br>
                </p>
                <p>We are still in the beginning of the investigation.</p>
                <p>So, what is the best version of SQLite to be used
                  with OpenSIPS 2.2? That is, what version of SQLite was
                  very well tested with OpenSIPS 2.2 and worked  without
                  memory leaks or others issues?</p>
                <p><br>
                </p>
                <p>Any suggestion will be very helpful!</p>
                <p><br>
                </p>
                <p>Best regards.<br>
                </p>
                <p><br>
                </p>
                <div id="Signature">
                  <div name="divtagdefaultwrapper"
                    style="font-family:Calibri,Arial,Helvetica,sans-serif;
                    font-size:; margin:0">
                    <div class="BodyFragment"><font size="2">
                        <div class="PlainText">RODRIGO PIMENTA CARVALHO<br>
                          Inatel Competence Center<br>
                          Software<br>
                          Ph: +55 35 3471 9200 RAMAL 979<br>
                        </div>
                      </font></div>
                  </div>
                </div>
              </div>
              <br>
              <fieldset class="mimeAttachmentHeader"></fieldset>
              <br>
              <pre>_______________________________________________
Users mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a moz-do-not-send="true" 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>
          </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>