<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>Hi Eric.</p>
<p><br>
</p>
<p>Probably not. Because I still don't know what is a federated-sip. And I didn't have to take control of RTPs in opensips script.</p>
<p>However, a coworker in my office will check these details and help us to conclude more things about it.</p>
<p>Is there a quick way to check if someone is using such federated-sip?</p>
<p><br>
</p>
<p>Our version 3.8.6 of SQLite presented the memory leak (when there was no SIP requests), but the version 3.13 doesn't present.</p>
<p><br>
</p>
<p>P.S.: I still have to read about federated SIP and see what are its advantages.<br>
</p>
<p><br>
</p>
<p>Thanks a lot.</p>
<p><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 Eric Tamme <eric@uphreak.com><br>
<b>Enviado:</b> sexta-feira, 17 de junho de 2016 14:12<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>Hey Rodrigo,<br>
<br>
Are you running <a id="LPlnk984859" class="moz-txt-link-freetext" href="https://github.com/etamme/federated-sip">
https://github.com/etamme/federated-sip</a> by chance? Your use of the PCRE module made me think you might be. I run federated-sip and I do use sqlite3 with opensips - my current sqlite version is: sqlite-3.7.17-4.el7.x86_64
<div style="margin-bottom: 20px; overflow: auto; width: 100%; text-indent: 0px;" id="LPBorder_GT_14661836496290.24773507708664222">
<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_14661836496250.4074879682860746" 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_14661836496260.7309128600610805">
<div style="background-color: rgb(255, 255, 255); height: 250px; position: relative; margin: auto; display: table; width: 250px;" id="LPImageContainer_14661836496260.02722797173561531">
<a target="_blank" href="https://github.com/etamme/federated-sip" style="display: table-cell; text-align: center;" id="LPImageAnchor_14661836496260.7214843712399693"><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: 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" style="vertical-align: top; position: relative; padding: 0px; display: table-cell;" id="TextCell_14661836496270.3438336457808685">
<div id="LPRemovePreviewContainer_14661836496270.23901296651463255"></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_14661836496270.6876083549084027">
<a title="Ctrl+Clique ou toque para seguir o link" target="_blank" href="https://github.com/etamme/federated-sip" style="text-decoration: none;" id="LPUrlAnchor_14661836496280.001028468482965672">GitHub - etamme/federated-sip: Federated SIP deployment</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_14661836496280.38737954584392364">
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_14661836496290.9758155168673414">
README.md Federated SIP server. The Federated SIP project is a set of scripts designed to run OpenSIPS + rtpengine in a way that will provide federated, open ...</div>
</td>
</tr>
</tbody>
</table>
</div>
<br>
<br>
I do not know that I have memory leaks outside of what I reported in the github issue.<br>
<br>
-Eric<br>
<br>
<div class="moz-cite-prefix">On 06/17/2016 11:08 AM, 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>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>
<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 Ionut Ionita <a class="moz-txt-link-rfc2396E" href="mailto:ionutionita@opensips.org">
<ionutionita@opensips.org></a><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 id="LPBorder_GT_14661827001450.24882122046390898" style="margin-bottom:20px; overflow:auto; width:100%; text-indent:0px" contenteditable="false">
<table id="LPContainer_14661827001310.08047794379763717" 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_14661827001350.9888400112076812" style="width:250px; display:table-cell; padding-right:20px">
<div id="LPImageContainer_14661827001350.9456353245249414" style="background-color:rgb(255,255,255); height:200px; margin:auto; display:table; width:200px">
<a target="_blank" href="https://github.com/OpenSIPS/opensips/commit/c1aa55e73f7c56ea4894997aeb7f25a03cb289cf" id="LPImageAnchor_14661827001360.697784344002845" 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: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" id="TextCell_14661827001370.16582485107390843" style="vertical-align:top; padding:0px; display:table-cell">
<div id="LPTitle_14661827001370.363472650624067" style=""><a target="_blank" href="https://github.com/OpenSIPS/opensips/commit/c1aa55e73f7c56ea4894997aeb7f25a03cb289cf" id="LPUrlAnchor_14661827001410.09994271476046801" style="text-decoration:none">[sqlite][bugfix]
free column names when freeing the result · OpenSIPS/opensips@c1aa55e</a></div>
<div id="LPMetadata_14661827001410.034245792136147535" style="">github.com</div>
<div id="LPDescription_14661827001430.6890391139794917" style="">(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">
</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>
<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>