<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hey Rodrigo,<br>
<br>
Are you running <a 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<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
cite="mid:BY2PR02MB165559007B7A33A9EBB0E834B5570@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;">
<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 moz-do-not-send="true" 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 moz-do-not-send="true" target="_blank"
href="https://github.com/OpenSIPS/opensips/commit/c1aa55e73f7c56ea4894997aeb7f25a03cb289cf"
style="display: table-cell; text-align:
center;"
id="LPImageAnchor_14661827001360.697784344002845"><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: 200px;
width: 200px; border-width: 0px;
vertical-align: bottom;"
src="https://avatars3.githubusercontent.com/u/7924437?v=3&s=200"
height="200" width="200"></a></div>
</td>
<td colspan="2" style="vertical-align: top;
position: relative; padding: 0px; display:
table-cell;"
id="TextCell_14661827001370.16582485107390843">
<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 moz-do-not-send="true" 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 moz-do-not-send="true"
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 moz-do-not-send="true"
class="moz-txt-link-abbreviated"
href="mailto:users-bounces@lists.opensips.org">
users-bounces@lists.opensips.org</a> <a
moz-do-not-send="true"
class="moz-txt-link-rfc2396E"
href="mailto:users-bounces@lists.opensips.org">
<a class="moz-txt-link-rfc2396E" href="mailto:users-bounces@lists.opensips.org"><users-bounces@lists.opensips.org></a></a> em
nome de Liviu Chircu <a moz-do-not-send="true"
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 moz-do-not-send="true"
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
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 moz-do-not-send="true"
target="_blank"
href="https://github.com/OpenSIPS/opensips/issues/911"
id="LPImageAnchor_14661730827170.83910842926327"
style="display:table-cell;
text-align:center"><img
moz-do-not-send="true"
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&s=400"
height="250" width="250"></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 moz-do-not-send="true"
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 moz-do-not-send="true"
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>_______________________________________________
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>