<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p>Thank you Ionut.</p>
<p><br>
</p>
<p>We will try it so.</p>
<p><br>
</p>
<p>Today morning, we noticed that OpenSIPS 2.2 while running and using SQLite, without online clients, without registers and without calls, causes a memory leak. That is, OpenSIPS even without any SIP request causes a memory leak due to the use of SQLite.
<br>
</p>
<p><br>
</p>
<p>After updating the SQLite to a new version, such memory leak was vanished.</p>
<p><br>
</p>
<p>However, even with the newest SQLite, we still get memory leaks again if the proxy receives SIP REGISTER messages. That is, we get the issue every time some client registers. In this case we saw the memory leak in : "
<span style="color: rgb(0, 111, 201);">modparam("db_sqlite", "load_extension", "/usr/lib/sqlite3/pcre.so")</span>"
<br>
</p>
<p><br>
</p>
<p>Let us try the new solution and see what happens.</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>
<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" face="Calibri, sans-serif" color="#000000"><b>De:</b> users-bounces@lists.opensips.org <users-bounces@lists.opensips.org> em nome de Ionut Ionita <ionutionita@opensips.org><br>
<b>Enviado:</b> sexta-feira, 17 de junho de 2016 11:45<br>
<b>Para:</b> OpenSIPS users mailling list<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><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 id="LPlnk442728" class="moz-txt-link-freetext" href="https://github.com/OpenSIPS/opensips/commit/c1aa55e73f7c56ea4894997aeb7f25a03cb289cf">
https://github.com/OpenSIPS/opensips/commit/c1aa55e73f7c56ea4894997aeb7f25a03cb289cf</a>
<div style="margin-bottom: 20px; overflow: auto; width: 100%; text-indent: 0px;" id="LPBorder_GT_14661827001450.24882122046390898">
<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_14661827001310.08047794379763717" 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_14661827001350.9888400112076812">
<div style="background-color: rgb(255, 255, 255); height: 200px; position: relative; margin: auto; display: table; width: 200px;" id="LPImageContainer_14661827001350.9456353245249414">
<a target="_blank" href="https://github.com/OpenSIPS/opensips/commit/c1aa55e73f7c56ea4894997aeb7f25a03cb289cf" style="display: table-cell; text-align: center;" id="LPImageAnchor_14661827001360.697784344002845"><img 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: 200px; width: 200px; border-width: 0px; vertical-align: bottom;" height="200" width="200" src="https://avatars3.githubusercontent.com/u/7924437?v=3&s=200"></a></div>
</td>
<td colspan="2" style="vertical-align: top; position: relative; padding: 0px; display: table-cell;" id="TextCell_14661827001370.16582485107390843">
<div id="LPRemovePreviewContainer_14661827001370.7306123717305801"></div>
<div style="top: 0px; color: rgb(0, 120, 215); font-weight: 400; font-size: 21px; font-family: "wf_segoe-ui_light","Segoe UI Light","Segoe WP Light","Segoe UI","Segoe WP",Tahoma,Arial,sans-serif; line-height: 21px;" id="LPTitle_14661827001370.363472650624067">
<a target="_blank" href="https://github.com/OpenSIPS/opensips/commit/c1aa55e73f7c56ea4894997aeb7f25a03cb289cf" style="text-decoration: none;" id="LPUrlAnchor_14661827001410.09994271476046801">[sqlite][bugfix] free column names when freeing the result · OpenSIPS/opensips@c1aa55e</a></div>
<div style="margin: 10px 0px 16px; color: rgb(102, 102, 102); font-weight: 400; font-family: "wf_segoe-ui_normal","Segoe UI","Segoe WP",Tahoma,Arial,sans-serif; font-size: 14px; line-height: 14px;" id="LPMetadata_14661827001410.034245792136147535">
github.com</div>
<div style="display: block; color: rgb(102, 102, 102); font-weight: 400; font-family: "wf_segoe-ui_normal","Segoe UI","Segoe WP",Tahoma,Arial,sans-serif; font-size: 14px; line-height: 20px; max-height: 100px; overflow: hidden;" id="LPDescription_14661827001430.6890391139794917">
(cherry picked from commit cf380773cec9f91ad08e343c03261154dabc36a5)</div>
</td>
</tr>
</tbody>
</table>
</div>
<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 type="cite">
<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" face="Calibri, sans-serif" color="#000000"><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">
<users-bounces@lists.opensips.org></a> em nome de Liviu Chircu <a class="moz-txt-link-rfc2396E" href="mailto:liviu@opensips.org">
<liviu@opensips.org></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 id="LPlnk258574" class="moz-txt-link-freetext" href="https://github.com/OpenSIPS/opensips/issues/911">
https://github.com/OpenSIPS/opensips/issues/911</a>
<div id="LPBorder_GT_14661730827220.7344820404655459" style="margin-bottom:20px; overflow:auto; width:100%; text-indent:0px" contenteditable="false">
<table id="LPContainer_14661730827150.8385706328489059" style="width:90%; background-color:rgb(255,255,255); 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)" cellspacing="0">
<tbody>
<tr style="border-spacing:0px" valign="top">
<td colspan="1" id="ImageCell_14661730827170.6843827770432" style="width:250px; display:table-cell; padding-right:20px">
<div id="LPImageContainer_14661730827170.41546035387795444" style="background-color:rgb(255,255,255); height:250px; margin:auto; display:table; width:250px">
<a target="_blank" href="https://github.com/OpenSIPS/opensips/issues/911" id="LPImageAnchor_14661730827170.83910842926327" style="display:table-cell; text-align:center"><img 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" height="250" width="250" src="https://avatars3.githubusercontent.com/u/21685?v=3&s=400"></a></div>
</td>
<td colspan="2" id="TextCell_14661730827180.3816031677345342" style="vertical-align:top; padding:0px; display:table-cell">
<div id="LPTitle_14661730827180.6069792356056238" style=""><a target="_blank" href="https://github.com/OpenSIPS/opensips/issues/911" id="LPUrlAnchor_14661730827190.5211874584329679" style="text-decoration:none">2.2 runs out of pkg_mem because of db/db_res.c
memory leak · Issue #911 · OpenSIPS/opensips</a></div>
<div id="LPMetadata_14661730827200.036808617204725724" style="">github.com</div>
<div id="LPDescription_14661730827210.11339707680130573" style="">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 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 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>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset> <br>
<pre>_______________________________________________
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>
</div>
</div>
</div>
</body>
</html>