[OpenSIPS-Users] multiple sub interfaces - opensips crashes

Tue Nov 3 19:12:23 EST 2020

I didn't read that it was mysql, sorry. I think my suggestion is for
another thread :)

Anyway, it seems that proxysql <https://proxysql.com/ > can be a choice for
mysql...

On Tue, Nov 3, 2020 at 3:46 PM M S <medeanwz at gmail.com> wrote:

> Thanks for the suggestion Federico. I'm using Myql, is there an equivalent?
>
> On Tue, Nov 3, 2020 at 3:42 PM Federico Edorna <fedorna at anura.com.ar>
> wrote:
>
>> If it helps, we are using pgbouncer <https://www.pgbouncer.org/> to
>> avoid opening a lot of connections to db. Pgbouncer acts as a db server for
>> opensips with full workers connections and opens just a few (on demand) to
>> real db server. It helps a lot when you have backup/standby opensips, not
>> increasing those db connections.
>>
>>
>> On Tue, Nov 3, 2020 at 9:13 AM Bogdan-Andrei Iancu <bogdan at opensips.org>
>> wrote:
>>
>>> Maybe we should consider (as future extension) the possibility to bundle
>>> multiple UDP listeners on the same worker.  In this case, we can have a
>>> large number of listeners with a relatively small number of workers/
>>> processes.
>>>
>>> Regards,
>>>
>>> Bogdan-Andrei Iancu
>>>
>>> OpenSIPS Founder and Developer
>>>    https://www.opensips-solutions.com
>>> OpenSIPS Bootcamp 2020 online
>>>    https://opensips.org/training/OpenSIPS_eBootcamp_2020/
>>>
>>> On 11/3/20 10:10 AM, Răzvan Crainea wrote:
>>> > Hello!
>>> >
>>> > No, there is no way to prevent OpenSIPS from opening connections for
>>> > each process. Did you try to start opensips with fewer workers, for
>>> > example just 1, or 3? Does it start properly?
>>> >
>>> > Best regards,
>>> >
>>> > Răzvan Crainea
>>> > OpenSIPS Core Developer
>>> > http://www.opensips-solutions.com
>>> >
>>> > On 11/2/20 1:55 PM, M S wrote:
>>> >> Thank you Bogdan. I actually use: socket=udp:*:5060 in config file.
>>> >> Is there a way to not open a process per interface, to not have 1200
>>> >> or 600 workers? as I said in my previous email, I tried auto scaling
>>> >> and it didn't work.
>>> >> Also, I have increased MySQL max connections but it didn't fix
>>> >> the problem - I wonder if anybody has experience with this...
>>> >>
>>> >> Thanks!
>>> >>
>>> >> On Mon, Nov 2, 2020 at 9:24 AM Bogdan-Andrei Iancu
>>> >> <bogdan at opensips.org <mailto:bogdan at opensips.org>> wrote:
>>> >>
>>> >>     Hi OpenSIPer,
>>> >>
>>> >>     With 600 interfaces (btw , have actually listed the 600 sockets
>>> into
>>> >>     the cfg or pointed the socket to the interface?) with 2 workers
>>> per
>>> >>     socket -> 1200 workers / processes. That means 1200 connections to
>>> >>     your DB server, which may be a bottle neck (by default, mysql
>>> >>     accepts around 100 simultaneous connections).
>>> >>
>>> >>     I suspect your mysql server cannot cope with the 1200 conn,
>>> >>     preventing OpenSIPS to properly start.
>>> >>
>>> >>     Regards,
>>> >>
>>> >>     Bogdan-Andrei Iancu
>>> >>
>>> >>     OpenSIPS Founder and Developer
>>> >>        https://www.opensips-solutions.com
>>> >>     OpenSIPS Bootcamp 2020 online
>>> >>        https://opensips.org/training/OpenSIPS_eBootcamp_2020/
>>> >>
>>> >>     On 11/2/20 1:23 AM, M S wrote:
>>> >>>     Hi all,
>>> >>>     I have a machine with 600 subinterfaces. when I start opensips
>>> >>>     with 2 udp workers per interface, it doesn't start and keeps
>>> >>>     restarting.
>>> >>>     First error message was about too many connections to Mysql which
>>> >>>     I fixed by increasing max_connections, but now I am getting:
>>> >>>
>>> >>>     ERROR:db_mysql:db_mysql_new_connection: initial connect failed
>>> >>>     ERROR:core:db_do_init: could not add connection to the pool
>>> >>>     ERROR:sql_cacher:child_init: Cannot connect to SQL DB from child
>>> >>>     ERROR:core:init_mod_child: failed to initializing module
>>> >>>     sql_cacher, rank 683
>>> >>>     ERROR:core:send_status_code: write(-1) failed (-1): 32, Broken
>>> pipe
>>> >>>     ERROR:core:udp_start_processes: failed to send -1 status code
>>> >>>     ERROR:db_mysql:db_mysql_connect: driver error(2002): Can't
>>> connect
>>> >>>     to local MySQL server through socket '/var/lib/mysql/mysql.sock'
>>> >>> (11)
>>> >>>
>>> >>>     and:
>>> >>>
>>> >>>     ERROR:core:send_status_code: write(-1) failed (-1): 32, Broken
>>> pipe
>>> >>>     ERROR:core:udp_start_processes: failed to send -1 status code
>>> >>>
>>> >>>     Any ideas how I can fix this?
>>> >>>     Also, can I just limit number of opensips forked processes, to
>>> run
>>> >>>     just a certain number process instead of x numbers per interface?
>>> >>>     I tried using auto_scaling but it did not help. in my
>>> >>>     opensips.conf, I have:
>>> >>>     socket=udp:*:5060
>>> >>>     and adding an autoscaling profile in front of it seems to limit
>>> >>>     the processes per interface again, not all...
>>> >>>
>>> >>>     Any help is appreciated.
>>> >>>
>>> >>>     Thanks!
>>> >>>
>>> >>>     _______________________________________________
>>> >>>     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
>>> >> 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
>>>
>> _______________________________________________
>> 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/20201103/61d0e08b/attachment-0001.html>