[OpenSIPS-Users] What is the best SQLite version to be used with OpenSIPS 2.2? We investigate a memory leak.

Fri Jun 17 19:12:25 CEST 2016

Hey Rodrigo,

Are you running https://github.com/etamme/federated-sip 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

I do not know that I have memory leaks outside of what I reported in the 
github issue.

-Eric

On 06/17/2016 11:08 AM, Rodrigo Pimenta Carvalho wrote:
>
> Thank you Ionut.
>
>
> We will try it so.
>
>
> 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.
>
>
> After updating the SQLite to a new version, such memory leak was vanished.
>
>
> 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 : " modparam("db_sqlite", "load_extension", 
> "/usr/lib/sqlite3/pcre.so")"
>
>
> Let us try the new solution and see what happens.
>
>
> Best regards!
>
>
> RODRIGO PIMENTA CARVALHO
> Inatel Competence Center
> Software
> Ph: +55 35 3471 9200 RAMAL 979
>
>
> ------------------------------------------------------------------------
> *De:* users-bounces at lists.opensips.org 
> <users-bounces at lists.opensips.org> em nome de Ionut Ionita 
> <ionutionita at opensips.org>
> *Enviado:* sexta-feira, 17 de junho de 2016 11:45
> *Para:* OpenSIPS users mailling list
> *Assunto:* Re: [OpenSIPS-Users] What is the best SQLite version to be 
> used with OpenSIPS 2.2? We investigate a memory leak.
> Hi Rodrigo,
>
>     Pushed a fix both into 2.2[0] and master[1] branches. If you still 
> think sqlite leaks even with this fix,
> please feel free to open an issue on github.
>
> [0] 
> https://github.com/OpenSIPS/opensips/commit/c1aa55e73f7c56ea4894997aeb7f25a03cb289cf 
>
> <https://github.com/OpenSIPS/opensips/commit/c1aa55e73f7c56ea4894997aeb7f25a03cb289cf>
> 	
> [sqlite][bugfix] free column names when freeing the result · 
> OpenSIPS/opensips at c1aa55e 
> <https://github.com/OpenSIPS/opensips/commit/c1aa55e73f7c56ea4894997aeb7f25a03cb289cf>
> github.com
> (cherry picked from commit cf380773cec9f91ad08e343c03261154dabc36a5)
>
>
> [1] 
> https://github.com/OpenSIPS/opensips/commit/c1aa55e73f7c56ea4894997aeb7f25a03cb289cf 
>
> Regrads,
> Ionut Ionita
> OpenSIPS Developer
> On 06/17/2016 05:19 PM, Rodrigo Pimenta Carvalho wrote:
>>
>> Hi Liviu.
>>
>>
>> Very good.
>>
>>
>> We will see the resolution process.
>>
>> Thank you very much!
>>
>> Regards.
>>
>>
>> RODRIGO PIMENTA CARVALHO
>> Inatel Competence Center
>> Software
>> Ph: +55 35 3471 9200 RAMAL 979
>>
>>
>> ------------------------------------------------------------------------
>> *De:* users-bounces at lists.opensips.org 
>> <users-bounces at lists.opensips.org> em nome de Liviu Chircu 
>> <liviu at opensips.org>
>> *Enviado:* sexta-feira, 17 de junho de 2016 11:14
>> *Para:* users at lists.opensips.org
>> *Assunto:* Re: [OpenSIPS-Users] What is the best SQLite version to be 
>> used with OpenSIPS 2.2? We investigate a memory leak.
>> Hi Rodrigo!
>>
>> 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.
>>
>> [1]: https://github.com/OpenSIPS/opensips/issues/911
>> <https://github.com/OpenSIPS/opensips/issues/911>
>> 	
>> 2.2 runs out of pkg_mem because of db/db_res.c memory leak · Issue 
>> #911 · OpenSIPS/opensips 
>> <https://github.com/OpenSIPS/opensips/issues/911>
>> github.com
>> 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: 
>> https://gist.github.com/etamme/7d42024ad684fe834b9fd514d2bd2412 I am 
>> using...
>>
>>
>> Liviu Chircu
>> OpenSIPS Developer
>> http://www.opensips-solutions.com
>> On 17.06.2016 17:02, Rodrigo Pimenta Carvalho wrote:
>>>
>>> Hi.
>>>
>>>
>>> People from my team is investigating a memory leak related to 
>>> OpenSIPS 2.2.
>>>
>>>
>>> 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.
>>>
>>> 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.
>>>
>>>
>>> We are still in the beginning of the investigation.
>>>
>>> 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?
>>>
>>>
>>> Any suggestion will be very helpful!
>>>
>>>
>>> Best regards.
>>>
>>>
>>> RODRIGO PIMENTA CARVALHO
>>> Inatel Competence Center
>>> Software
>>> Ph: +55 35 3471 9200 RAMAL 979
>>>
>>>
>>> _______________________________________________
>>> Users mailing list
>>> Users at lists.opensips.org
>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20160617/77c4a0b1/attachment-0001.htm>