<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.</p>
<p><br>
</p>
<p>Does someone here is getting/handling memory leaks with OpenSIPS 2.2 and last version of SQLite?</p>
<p>I'm using newest commit from OpenSIPS 2.2 and newest version of SQLite.</p>
<p><br>
</p>
<p>My query is : <br>
</p>
<p><br>
</p>
<p><span style="color: rgb(0, 111, 201);" lang="EN-US">avp_db_query("select Value from GeneralConfigurations where Attribute = 'CONFIGURATION_INTERCOM_A_NAME'");</span></p>
<p><span lang="EN-US"><br>
</span></p>
<p><span lang="EN-US">Valgrind shows:</span></p>
<p><span lang="EN-US"><br>
</span></p>
<p><span lang="EN-US"></p>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color: rgb(0, 111, 201);" lang="EN-US">==16087== ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 2 from 2)</span></p>
<span style="color: rgb(0, 111, 201);"></span>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color: rgb(0, 111, 201);" lang="EN-US">==16088== Searching for pointers to 296,489 not-freed blocks</span></p>
<span style="color: rgb(0, 111, 201);"></span>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color: rgb(0, 111, 201);" lang="EN-US">==16088== Checked 103,297,688 bytes</span></p>
<span style="color: rgb(0, 111, 201);"></span>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color: rgb(0, 111, 201);" lang="EN-US">==16088== </span></p>
<span style="color: rgb(0, 111, 201);"></span>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color: rgb(0, 111, 201);" lang="EN-US">==16088== 1,024 bytes in 1 blocks are possibly lost in loss record 184 of 246</span></p>
<span style="color: rgb(0, 111, 201);"></span>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color: rgb(0, 111, 201);" lang="EN-US">==16088== at 0x4C2745D: malloc (in /usr/lib64/valgrind/vgpreload_memcheck-amd64-linux.so)</span></p>
<span style="color: rgb(0, 111, 201);"></span>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color: rgb(0, 111, 201);" lang="EN-US">==16088== by 0x8F8B05F: sqlite3MemMalloc (sqlite3.c:20167)</span></p>
<span style="color: rgb(0, 111, 201);"></span>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color: rgb(0, 111, 201);" lang="EN-US">==16088== by 0x8F701C7: sqlite3Malloc (sqlite3.c:23846)</span></p>
<span style="color: rgb(0, 111, 201);"></span>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color: rgb(0, 111, 201);" lang="EN-US">==16088== by 0x8F75459: pcache1Alloc (sqlite3.c:44312)</span></p>
<span style="color: rgb(0, 111, 201);"></span>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color: rgb(0, 111, 201);" lang="EN-US">==16088== by 0x8F8019F: sqlite3BtreeCursor (sqlite3.c:44455)</span></p>
<span style="color: rgb(0, 111, 201);"></span>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color: rgb(0, 111, 201);" lang="EN-US">==16088== by 0x8FD0FDD: sqlite3VdbeExec (sqlite3.c:80098)</span></p>
<span style="color: rgb(0, 111, 201);"></span>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color: rgb(0, 111, 201);" lang="EN-US">==16088== by 0x8FDB89F: sqlite3_step (sqlite3.c:75131)</span></p>
<span style="color: rgb(0, 111, 201);"></span>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color: rgb(0, 111, 201);" lang="EN-US">==16088== by 0x8FDC9A1: sqlite3_exec (sqlite3.c:108122)</span></p>
<span style="color: rgb(0, 111, 201);"></span>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color: rgb(0, 111, 201);" lang="EN-US">==16088== by 0x8D20736: db_sqlite_raw_query (dbase.c:358)</span></p>
<span style="color: rgb(0, 111, 201);"></span>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color: rgb(0, 111, 201);" lang="EN-US">==16088== by 0x9464DB8: db_query_avp (avpops_db.c:436)</span></p>
<span style="color: rgb(0, 111, 201);"></span>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color: rgb(0, 111, 201);" lang="EN-US">==16088== by 0x946943E: ops_dbquery_avps (avpops_impl.c:840)</span></p>
<span style="color: rgb(0, 111, 201);"></span>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color: rgb(0, 111, 201);" lang="EN-US">==16088== by 0x9459A61: w_dbquery_avps (avpops.c:1395)</span></p>
<span style="color: rgb(0, 111, 201);"></span>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color: rgb(0, 111, 201);" lang="EN-US">==16088== </span></p>
<span style="color: rgb(0, 111, 201);"></span>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color: rgb(0, 111, 201);" lang="EN-US">==16088== LEAK SUMMARY:</span></p>
<span style="color: rgb(0, 111, 201);"></span>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color: rgb(0, 111, 201);" lang="EN-US">==16088== definitely lost: 0 bytes in 0 blocks</span></p>
<span style="color: rgb(0, 111, 201);"></span>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color: rgb(0, 111, 201);" lang="EN-US">==16088== indirectly lost: 0 bytes in 0 blocks</span></p>
<span style="color: rgb(0, 111, 201);"></span>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color: rgb(0, 111, 201);" lang="EN-US">==16088== <span style="color: rgb(255, 0, 0);">
possibly lost: 1,024 bytes in 1 blocks</span></span></p>
<span style="color: rgb(0, 111, 201);"></span>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color: rgb(0, 111, 201);" lang="EN-US">==16088== still reachable: 47,457,573 bytes in 296,488 blocks</span></p>
<span style="color: rgb(0, 111, 201);"></span>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color: rgb(0, 111, 201);" lang="EN-US">==16088== suppressed: 0 bytes in 0 blocks</span></p>
<span style="color: rgb(0, 111, 201);"></span>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color: rgb(0, 111, 201);" lang="EN-US">==16088== Reachable blocks (those to which a pointer was found) are not shown.</span></p>
<span style="color: rgb(0, 111, 201);"></span>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span style="color: rgb(0, 111, 201);" lang="EN-US">==16088== To see them, rerun with: --leak-check=full --show-leak-kinds=all</span></p>
<br>
</span>
<p></p>
<p><span lang="EN-US"></span><br>
</p>
<p>After some time running that query, I can see, via command top, that the available memory is decreasing.</p>
<p>In fact, the memory is not freed even after stop running the query for a time.</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>
<span lang="EN-US"></span>
<div style="color: rgb(0, 0, 0);">
<div>
<div style="">
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span lang="EN-US"> </span></p>
<br>
<p style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif";">
<span lang="EN-US"> </span><br>
</p>
</div>
</div>
</div>
</div>
</body>
</html>