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

Fri Jun 17 19:23:43 CEST 2016

Hi Eric.

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.

However, a coworker in my office will check these details and help us to conclude more things about it.

Is there a quick way to check if someone is using such federated-sip?

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.S.: I still have to read about federated SIP and see what are its advantages.

Thanks a lot.

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 Eric Tamme <eric at uphreak.com>
Enviado: sexta-feira, 17 de junho de 2016 14:12
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.

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
[https://avatars3.githubusercontent.com/u/21685?v=3&s=400]<https://github.com/etamme/federated-sip>

GitHub - etamme/federated-sip: Federated SIP deployment<https://github.com/etamme/federated-sip>
github.com
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 ...

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<mailto:users-bounces at lists.opensips.org> <users-bounces at lists.opensips.org><mailto:users-bounces at lists.opensips.org> em nome de Ionut Ionita <ionutionita at opensips.org><mailto: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://avatars3.githubusercontent.com/u/7924437?v=3&s=200]<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<mailto:users-bounces at lists.opensips.org> <mailto:users-bounces at lists.opensips.org> <users-bounces at lists.opensips.org><mailto:users-bounces at lists.opensips.org> em nome de Liviu Chircu <liviu at opensips.org><mailto:liviu at opensips.org>
Enviado: sexta-feira, 17 de junho de 2016 11:14
Para: users at lists.opensips.org<mailto: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://avatars3.githubusercontent.com/u/21685?v=3&s=400]<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<mailto:Users at lists.opensips.org>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

_______________________________________________
Users mailing list
Users at lists.opensips.org<mailto:Users at lists.opensips.org>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

_______________________________________________
Users mailing list
Users at lists.opensips.org<mailto: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/53658203/attachment-0001.htm>