[OpenSIPS-Users] Need help regarding avpops db connections

[Dipteshkumar Patel]

Thanks for your response,

I agree that the async avp_db_query creates dynamics mysql connection but
the connections goes in sleep mode and they never closed until opensips
restart, I am sending the mariadb connection initially when starts opensips
and after calls(we are using different db user to identify each of them).
We are making 1000 calls with 100 cps.

Please check mysql process list output in below link
https://pastebin.com/Uk1DeYR0


On Tue, Sep 26, 2017 at 10:23 PM, Bogdan-Andrei Iancu <bogdan at opensips.org>
wrote:

> Hello Patel,
>
> Yes, the avopos module (while using async db queries from script) is the
> one dynamically creating mysql connections. Are all the created connection
> under usage ?
>
> Best regards,
>
> Bogdan-Andrei Iancu
>   OpenSIPS Founder and Developer
>   http://www.opensips-solutions.com
>
> On 09/25/2017 05:37 PM, Dipteshkumar Patel wrote:
>
> Hello Sir,
>
> I am using opensips version 2.3.1 and mariadb-server-5.5.52-1
>
> In which I have configured dispatcher, dialog, avpops , rtpproxy and
> permissions module to use database connection.
> Opensips has 16 children.
>
> And Yes, I am using async db queries in avpops.
>
> I have noticed that as and when I increase CPS the idle DB connections are
> increasing mainly for avpops module. And those connections are not getting
> disconnected until restart opensips.
>
> Please help me out to resolve this as at some point it leads to Too Many
> Connections.
>
> Looking forward for your kind help.
>
> Thanks in advance.
>
>
> _______________________________________________
> Users mailing listUsers at lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20170927/8841da46/attachment.html>